This course is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other application programs.
In this course you will:
Modify the design and field properties of a table to streamline data entry and maintain data integrity.
Retrieve data from tables using joins.
Create flexible queries to display specified reports, allow user-determined query criteria, and modify data using queries.
Enhance the capabilities of a form.
Customized reports to organize the displayed information and produce specific print layouts.
Share Access data across other applications.
To get the most out of this course, it is recommended you take our Microsoft Office Access 2010: Level 1 course or have equivalent knowledge.