• Microsoft Office Access Beginners Course
  • Microsoft Office Access Advanced Course

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