Target Audience: This course is designed for students who already have knowledge and skills in Excel and who wish to begin taking advantage of the higher-level functionality to analyze and present data.

Upon successful completion of this course, students will be able to:

·         streamline data entry and maintain data integrity.

·         join tables to retrieve data from unrelated tables.

·         create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.

·         improve forms.

·         customize reports to organize the displayed information and produce specific print layouts.

·         share data between Access and other applications.

Course Content:

Lesson 1: Controlling Data Entry

Lesson 2: Joining Tables

Lesson 3: Creating Flexible Queries

Lesson 4: Improving Forms

Lesson 5: Customizing Reports

Lesson 6: Sharing Data Across Applications