Microsoft Access 2016 (Advance)

This Access Advanced course will enable delegates to acquire sufficient skills and knowledge in Microsoft Access 2016 in order to design and create a multi-table database and automate operations using macros and develop a general understanding of the programming environment in Microsoft Access 2016.

This Access 2016 Advanced course will enable delegates to acquire sufficient  skills and knowledge in Microsoft Access 2016.  Delegates will learn how to design and create a multi-table database and automate operations using macros and develop a general understanding of the programming environment in Microsoft Access 2016.  

Upon completion of this course delegates should be able to:

• Design a relational database project
• Create a relational database file with multiple tables
• Set table relationships and join tables together
• Create queries based on one or more tables
• Create and work with aggregation queries
• Create and use a series of action queries
• Work with a number of macro techniques
• Create some simple programming code using VBA