Access 2003: Intermediate

Learning Outcomes:

• Correctly define referential integrity from information in the manual.

• Utilizing set criteria, analyze and identify table design problems and normalize tables with 90% accuracy.

• Successfully design select queries using the information from the Lesson Lab.

• Given a list of information, correctly choose the appropriate features and apply them to customize forms.

• Accurately design, create and use data access pages as directed in the Lesson Lab.

Students will learn how to design and create a new Access database, how to customize database components, and how to share Access data with other applications. This course is also one of a series for those pursuing MOS certification in Access 2003.

* Planning a Database
* Building the Structure of a Database
* Controlling Data Entry
* Finding and Joining Data
* Creating Flexible Queries
* Improving Your Forms
* Customizing Your Reports
* Expanding the Reach of Your Data

Access 2003: Intermediate

Upon successful completion of this one day course, students will be able to: Follow the steps required to properly design a simple database. Create a new database with related tables. Control data entry by modifying the design of a table to streamline data entry and maintain data integrity. Find and retrieve desired data by using filters and joins between tables and within a single table. Create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries. Enhance the appearance, data entry, and data access capabilities of your forms. Customize reports to better organize the displayed information and produce specific print layouts such as mailing labels. Use Access data in other applications, such as Word and Excel.

Class targeted to:

· Those responsible for creating new databases, the designing of tables and relationships, intermediate level queries, forms, reports, and data access pages.

Prerequisites:

Windows: Introduction and Access 2003: Introduction.