Microsoft Access 2016

Microsoft Access 2016 – Beginning (6-8 hours)

  • Database Concepts
  • Access Basics (Screen, Menu, Help)
  • Opening/Saving/Closing a File
  • Viewing a Table
  • Editing a Table
  • AutoCorrect and Spell Checking
  • Form vs. Table View
  • Changing a Table Image
  • Sorting
  • Printing a View
  • Page Setup and Printing
  • Creating and Restructuring a Table
  • Filtering and Finding Data
  • Creating Reports

Microsoft Access 2016 – Intermediate (6-8 hours)

  • Importing Spreadsheets
  • Publishing a Database Object
  • Creating a Primary Key
  • Converting Field Types
  • Changing Field Sizes
  • Custom Display Formats
  • Input Masks
  • Using the Lookup Wizard
  • Assigning Captions
  • Setting Default values
  • Using the Expression Builder
  • Creating Validity Rules & Text
  • Creating Queries
  • Saving/Opening Queries
  • Using Wildcards
  • Compound Queries
  • Creating calculated Controls
  • Using Summary Operators
  • Querying Multiple Tables
  • Action Queries
  • Creating Permanent Relationships
  • Enforcing Referential Integrity
  • Creating Custom Reports
  • Saving/Opening Reports
  • Creating Custom Forms
  • Saving/Opening/Printing Forms
  • Database Properties

Microsoft Access 2016 – Advanced (6-8 hours)

  • Creating Indexes
  • Parameter Queries
  • Crosstab Queries
  • Customizing Forms
  • Customizing Reports
  • Backing Up/Restoring
  • Compacting/Repairing a Database
  • Linked Table Manager
  • Startup Options
  • Upsizing Wizard
  • Protecting a Database
  • Customizing Access Options
  • Customizing the Quick Access Toolbar
  • Using Add-ins