Computer Training Course Outline for PC Training Experts, Serving Irvine, Newport Beach, and Mission Viejo

This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.

Performance-Based Objectives

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 Outline*
Module 1: Controlling Data Entry Constrain Data Entry Using Field Properties Establish Data Entry Formats for Entering Field Values Create a List of Values for a Field	Module 4: Improving Forms Restrict Data Entry in Forms Organize Information with Tab Pages Add a Command Button to a Form Create a Subform Display a Summary of Data in a Form Change the Display of Data Conditionally
Module 2: Joining Tables Create Query Joins Join Tables with No Common Fields Relate Data Within a Table	Module 5: Customizing Reports Organize Report Information Format Reports Control Report Pagination Summarize Report Information Add a Subreport to an Existing Report Create a Mailing Label Report
Module 3: Creating Flexible Queries Set the Select Query Properties Retrieve Records Based on Input Criteria Create Action Queries	Module 6: Sharing Data Across Applications Import Data into Access Export Data to Text File Formats Export Access Data to Excel Create a Mail Merge Create a Mail Merge Create a Mail Merge Create a Mail Merge Create a Mail Merge Create a Mail Merge


Register	Dates Offered	Email	Print Friendly	Show All

*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.