Microsoft Access 2007 Advanced

Anyone whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2007. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.

By the end of this course you will be able to produce advanced form interfaces, maintain data integrity; handle complex queries, forms, and reports; and share data between Access and other applications.

Skills Gained
* 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 records, allow for user-determined query criteria, and modify data using queries.
* Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.
* Customize reports to organize the displayed information and produce specific print layouts.
* Share data across different applications.

Course Outline
Controlling Data Entry
Restrict Data Entry Using Field Properties. Establish a Pattern for Entering Field Values. Create a List of Values for a Field.

Joining Tables
Create Query Joins. Join Unrelated Tables. Relate Data Within a Table.

Creating Flexible Queries
Set Select Query Properties. Create Parameter Queries. Create Action Queries.

Improving Forms
Design a Form Layout. Enhance the Appearance of a Form. Restrict Data Entry in Forms. Add a Command Button to a Form. Create a Subform.

Customising Reports
Organize Report Information. Format the Report. Set Report Control Properties. Control Report Pagination. Summarize Report Information. Add a Subreport to an Existing Report. Create a Mailing Label Report.

Sharing Data Across Applications
Import Data into Access. Export Data. Analyze Access Data in Excel. Export Data to a Text File. Merge Access Data with a Word Document.

Examinations

This course is one of a series of courseware titles that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.