Microsoft Access 2010 Intermediate

One day hands-on training in Microsoft Access 2010 will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Topics

• Constrain Data Entry Using Field Properties
• Establish Data Entry Formats for Entering Field Values
• Create a List of Values for a Field
• Create Query Joins
• Join Tables with No Common Fields
• Relate Data Within a Table
• Set the Select Query Properties
• Retrieve Records Based on Input Criteria
• Create Action Queries
• 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
• Organize Report Information
• Format Reports
• Control Report Pagination
• Summarize Report Information
• Add a Subreport to an Existing Report
• Create a Mailing Label Report
• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge

Target Audience
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.

Prerequisite
Completed the Access Basic course or have a basic knowledge of Microsoft Access 2010, including database design and data tables.

Training Class Material:

For more information, call 714-505-3475

For Schedule, click here.