Length of Course: 1 day

Overview:
This one-day course provides students with advanced features of Microsoft Access.

Prerequisites:
Prior to attending this class, students should have the following experience:

• Understanding of the basic concepts involved in working with a personal computer (PC)
• Familiarity with the Windows interface
• Microsoft Access - Level 1 and Microsoft Access - Level 2, or equivalent knowledge

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

• Make select queries more versatile and useful by using parameters.
• Use action queries to update data values and add or delete records.
• Generate different query types by creating various types of joins between tables.
• Use crosstab queries to summarize data.
• Use advanced form features including properties, functions, and design tools to facilitate data entry and improve accuracy in forms.
• Display table information that has a one-to-many relationship by creating forms that contain subforms.
• Automate tasks by creating macros to open forms and control form properties.
• Make forms more functional by using macros to provide user interaction and automate data entry.
• Make reports more concise and easier to understand by using properties and functions in report controls.
• Create mailing labels.
• Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.
• Integrate Access data with other Microsoft Office application.