Microsoft Office Access Beginners Course

Prerequisites

This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Access is necessary.

Course Outline

Introduction to databases
Introduction to objects
Getting started in Access
Managing databases and objects
Delete database objects
Working with tables
Modifying tables
Hide fields in a table
Add table descriptions
Rename tables
Add validation rules to fields
Modify field properties
Sorting and filtering records
Print and export data
Working with forms
Create quick forms
Create forms by using the forms wizard
Save forms
Formatting forms
Designing a simple query
Designing a multi-table query
More query design options
Save queries
Modifying queries
Creating reports
Format reports

Microsoft Office Access Advanced Course

Prerequisites

This level assumes that the user has completed the Microsoft Office Access 2016 Beginners course, or has equivalent knowledge of the sills covered in it.

Course Outline

Import database objects and data
Create calculated fields and totals rows
Create linked tables
Create a table from a template by using application parts
Append records from external data
Automate field values and formatting
Manage relationships and keys
Create forms from scratch
Create forms from templates by using application parts
Configure form controls
Navigate through a database
Create a find duplicates query
Create a parameter query
Create select queries
Create crosstab queries
Create action queries
Create calculated fields and grouping within queries
Configure report controls
Protect and maintain databases
Designing your own database