Microsoft Access 2016 for Beginners - Code Chiefs

Microsoft Access 2016 for Beginners

Regular price £19.00 Sale

Unlimited Access

12 Units, 58 Activities and Labs

Certificate of Completion

Level 3 Equivilent Content

10+ Hours of Content

Course Description

If you want to brush up on your Access skills or upskill to this vital technology, now is the time with our Microsoft Access 2016 for Beginners course. We’ve made it easy to learn with this Microsoft Access 2016 program that covers all the basics, including:

An introduction to the Access interface

The basics of creating a database with tables, forms, queries, and reports

Table management tools, including data normalization and the Relationships window

Techniques for importing and exporting data with Access

Requirements

Our Microsoft Access 2016 for Beginners course is fully compatible with any kind of device which is able to run Microsoft Access 2016. Whether you are using Windows computer, Mac, or Linux, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Who is it for?

This Microsoft Access 2016 for Beginners course is ideal for those students who want to build on the Introduction to MS Access 2016 course, want to further develop thier skills or take their MS Access knowledge to the next level.

Career path

After completing this Microsoft Access 2016 for Beginners course you will be able to build up accurate knowledge and skills with real confidence to up skill in your career.

Curriculum

Getting Started with Access

  • Microsoft Access 2016
  • Access Files
  • Opening Databases
  • Access Web Apps
  • The Access 2016 Application Window
  • Tables
  • Forms and Views
  • Queries
  • Reports
  • The Ribbon Interface
  • Database Templates
  • Web App Templates
  • Save Options
  • Field Definition
  • Methods to Create a Form
  • Form Object Views
  • Form Sections
  • Modifying Existing Forms
  • Saving Forms
  • Deleting Forms
  • Access Web App Views
  • Using Tell Me
  • Accessing Advanced Help Options
  • Summary
  • Review Questions

 

Working with Table Data

  • AutoCorrect
  • Commit, Save, and Undo
  • Quick Search
  • The Find and Replace Dialog Box
  • Datasheet Totals
  • Adding New Records
  • Updating Records with a Query
  • Append Queries
  • Navigating Through Records
  • Printing Records
  • The Sort Feature
  • The Filter Feature
  • Filter Commands
  • The Group Feature
  • Lookup Fields
  • The Property Sheet Pane
  • Summary
  • Review Questions

Querying a Database

  • Query Views
  • The Simple Query Wizard
  • Types of Queries
  • The Run Command
  • Query Design
  • Saving Queries
  • Deleting Queries
  • Renaming Queries
  • Query Criteria
  • Comparison Operators
  • Logical Operators
  • Sorting Query Results
  • Grouping Query Results
  • Formatting Query Fields
  • The Zoom Dialog Box
  • Arithmetic Operators
  • Adding Calculated Fields
  • Adding Conditional Logic
  • Summary
  • Review Questions

Creating Advanced Queries

  • Parameter Queries
  • Wildcards in a Parameter Query
  • The Ampersand Operator
  • Action Queries
  • Types of Action Queries
  • The Find Duplicates Query Wizard
  • The Find Unmatched Query Wizard
  • Crosstab Queries
  • Multiple Table Queries
  • Summary
  • Review Questions

 

Generating Reports

 

  • Report Creation Tools
  • Using Application Parts to Create Reports
  • Report Views
  • The Report Wizard
  • Saving a Report
  • Modifying an Existing Report
  • Deleting a Report
  • Report Sections
  • Adding Controls
  • Modifying Control Properties
  • Managing Labels
  • Inserting Images
  • Galleries
  • Themes
  • Adding a Header or Footer
  • Inserting Page Numbers
  • Page Setup Options
  • The Print Preview Tab
  • Summary
  • Review Questions

Customising the Access Environment

  • Access Options
  • Summary
  • Review Questions

 

Designing a Relational Database

 

  • Relational Databases
  • The Relational Database Design Process
  • The Statement of Purpose
  • Existing Data
  • Guidelines for Determining Fields
  • Business Rules
  • Guidelines for Grouping Fields into Tables
  • Primary Keys
  • Foreign Keys
  • Composite Keys
  • Table Relationships
  • Table Creation Options
  • Importing Tables from Other Databases
  • Creating Tables with Templates
  • Table Views
  • Data Types
  • Inserting Fields
  • Quick Start Fields
  • Deleting Fields
  • Calendar for Picking Dates
  • The Lookup Wizard
  • The Table Properties Dialog Box
  • Renaming a Table
  • Changing Field Captions
  • Changing Field Sizes
  • Configuring Fields to Auto-Increment
  • Setting the Default Value for a Field
  • The Relationships Window
  • Referential Integrity
  • Guidelines for Enforcing Referential Integrity
  • The Edit Relationships Dialog Box
  • Join Lines
  • Relationship Report
  • Summary
  • Review Questions

 

Joining Tables

  • Query Joins
  • Inner Joins
  • Outer Joins
  • The Join Properties Dialog Box
  • Joining Tables with No Common Fields
  • Self-Joins
  • The Alias Property
  • Subdatasheets
  • Subqueries
  • Summary
  • Review Questions

Organising a Database for Efficiency

  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Denormalization
  • The Table Analyzer Wizard
  • Many-to-Many Relationships
  • Junction Tables
  • Summary
  • Review Questions

Sharing Data Across Applications

  • Data Importing
  • The Get External Data Wizard
  • Delimiters
  • Data Exporting
  • Exporting Access Data to Excel
  • The Microsoft Word Mail Merge Wizard
  • Merge Fields
  • The Mail Merge Task Pane
  • Summary
  • Review Questions

Advanced Reporting

  • Report Design Elements
  • Report Design Tools
  • The Group, Sort, and Total Pane
  • The Field List Pane
  • Adding a Background Image to a Report
  • Report Format Tools
  • Report Control Properties
  • Report Pagination
  • Data Bars
  • Charts
  • Calculated Fields
  • Subreports
  • Summary
  • Review Questions

Additional Reporting Options

 

  • The Label Wizard
  • Activity 12-1
  • Publishing a Report as PDF
  • Activity 12-2
  • Summary
  • Review Questions

Extra Materials

  • Appendices
  • Keyboard Shortcut Quick Reference Sheet
  • Glossary

Certification

Courses featured on

Liquid error: Could not find asset snippets/eu-cookie-banner-app.liquid