Microsoft Access 2016 - Level 3

INF1632
978-1-925526-00-4
B&W printed

The skills and knowledge acquired in Microsoft Access 2016 - Level 3 are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

At the completion of this course you should be able to:

  • design a relational database project
  • create a relational database file with multiple tables
  • set table relationships and join tables together
  • export records to and import records from a wide variety of sources and applications
  • create queries based on one or more tables
  • create and work with aggregation queries
  • create and use a series of action queries
  • make your Microsoft Access data and computer more secure
  • understand and use a variety of tools that ensure the wellness of your database files
  • create some simple programming code using VBA

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip