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.