Microsoft Access 2016 - Level 3 (with Challenge Exercises)
INF1696 | |
978-1-925526-03-5 | |
B&W printed |
The skills and knowledge acquired in Microsoft Access 2016 - Level 3 (with Challenge Exercises) 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.
Download student files
Download working files to go with this course. Read the installation instructions for opening these files.