Learn how to enhance your database designs by using the principles of normalization and table relationships. Take the guesswork out of creating databases by using data-normalization techniques. Take advantage of relational database efficiency to maintain data. Save time by controlling data entry and automating tasks. You will also benefit by becoming familiar with Access features that will enable you to customize forms and reports.

• 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, including Microsoft Word and Excel.
• Restructure an existing set of data to improve the design of a database.
• Use a variety of techniques to summarize and present data with queries.
• Create and revise basic Access macros.
• Improve the effectiveness of data displayed in reports.
• Maintain an Access database by using various utility tools.

All Office courses will be taught using Microsoft Office 2007 starting August 1, 2007.

Prerequisite:Microsoft Access 2003: Introduction to Relational Database Design or equivalent experience.