Beyond the Basics of Database Management
Microsoft Access - Level 2

Prerequisite: Basics of Database Management

Microsoft Access is an electronic database management program included in the professional version of Microsoft Office, and it is used for entering, storing, sorting, searching and manipulating data. Access allows you to create queries, as well as generate reports. This is an intermediate class on Microsoft Access, and covers such topics as creating and modifying tables to store employee benefit information, employee addresses, employee review and training activities, expenses, information on vendors, purchases, etc. You’ll also learn how to create relationships between tables.

The class objectives include:

• Design a table
• Setting the primary key for a table
• Establishing the data type and size of a field
• Establishing the default value of a field
• Creating field validation rules
• Using Input Mask property to restrict data that can be entered in a field
• Using the Format property to control how data is displayed
• Confining data to a list of values using a Lookup field
• Entering data in a field by looking up data in another table
• Creating a table using the table wizard
• Formatting a datasheet
• Creating a one-to-many relationship between two tables
• Enforcing referential integrity
• Creating a one-to-one relationship between two tables
• Modifying table structures
• Displaying records in a subdatasheet

Access 2003 - Level 2
Code: ACS03-2 Date: 1/14/2010 Time: 9:00AM-12:00PM Registration Fee: $75
Access 2007 - Level 2
Code: ACS07-2 Date: 1/14/2010 Time: 1:00PM-4:00PM Registration Fee: $75