Learn intermediate Access 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, customize forms and reports, create more complex queries and create data access pages.

Prerequisites

Microsoft Access 2003 - Part 1 or equivalent knowledge. 

---

Objectives

After completing this course, students will be able to:

• Specify a required field in a table
• Define a default field value in a table
• Add a Memo field to a table
• Display multiple tables on the Access desktop
• Resize and reposition the Table window
• Create a relationship between two tables in a database
• Display and use a subdatasheet
• Design a custom form
• Add a header and footer to a form
• Create a query to extract information from multiple tables
• Create a query to generate summary information
• Create a report of information in multiple tables
• Add a calculated control to a report
• Create a data access page
• Add a PivotTable and PivotChart to a data access page
• Add a Lookup field to a table
• Define an input mask for a field
• Export an Access datasheet to Microsoft Office Excel
• Use the Database Wizard

Course Materials

The courseware (book) and student data files are included with the class. The courseware is Microsoft Approved Courseware. The courseware has been reviewed and approved to satisfy Microsoft Office Specialist certification exam standards.

[Part 1]  [Part 2]  [Part 3]

Top of Page