Microsoft Office Access 2003
Relational Database Design
 

Course Description

Have you ever tried unsuccessfully to extract data from your company database? Has anyone told you that you cannot retrieve the information you need? It is expensive to input, maintain and store large banks of data. Being able to get information when and how you need it is one of the most important functions of a database.

This class is designed for people who need to locate and extract data stored in a Microsoft Office Access 2003 database. A query is a request for specific information, based on search criteria. For example, you might query an Access table to see how many people work in the Sales department or who is enrolled in the company medical insurance program. There are many different types of queries. Some queries perform calculations, and other queries change data globally.

In this class, you will improve your query skills so you can extract virtually any data or combination of data from your Microsoft Office Access 2003 system.

Content

• Backup data

• Create relationships between Access tables

• Define and enforce referential integrity

• Perform cascading updates and deletes

• Normalize data

• Compact/Repair a database

• Name fields appropriately

• Create Lookup Fields

• Use hyperlinks in a Table

• Use appearance properties to improve the appearance of fields or field data (format and input masks)

• Use data entry properties to improve the appearance of fields or field data entry process (default values, validation rules, validation text messages and required field entries)

• Create a database from scratch

• Import tables from another database file

• Import/Export data from Excel

• Link tables

• Rename database objects