Back to Search Results

Training Course Summary:

This course is a hands-on instruction book that will introduce students the skills needed for creating, revising, and customizing the design of tables, queries, forms, reports, and data access pages. This course is also for those pursuing core-level Microsoft Office User Specialist (MOUS) certification in Access 2002. Students will learn intermediate Access 2002 skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages.

Pre-Requisites:

Microsoft Access 2002: Level 1
Windows 2000: Introduction

Training Course Overview/Content:

At course completion, delegates will be able to:

Share data with other applications and enforce referential integrity.
Modify the design of a table to streamline data entry and maintain data integrity.
Use a filter to show records that match criteria and generate different query results by creating different types of joins between tables.
Create select queries that display special records and design other types of queries, including parameter and action queries.
Create forms and change their designs to enhance the appearance and usability of a form, and to make your form more professional.
Create reports and change their designs to better organize and summarize information, and to improve the appearance by enhancing data layout and working with report pagination.
Create, modify, and work with data access pages.