About this course
The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.
Microsoft Access 2010 Level 2 is designed for users who have an understanding of how tables are created, records are entered, modified and deleted, and how simple queries, reports and forms are created.
At Course Completion
After completing this course, students will be able to:
use various data validation features in Access to protect data
format the data in a table
perform more advanced queries using a variety of querying techniques
create and use parameter queries
create calculated queries
modify and adapt an existing form according to specific needs
create and use macros in Access
work with a number of macro techniques
create macros on forms
Before attending this course, students must have:
Microsoft Access 2010 Level 2 assumes some knowledge of the software to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.