Extend your Access knowledge into some of the more specialized and advanced capabilities. Learn how to perform summary operations on data, create macros to automate tasks, enhance forms and reports, create and implement switchboard forms, protect information using security protocols, and use Access data in other Office applications.

Prerequisites

Microsoft Access 2003 - Part 2 or equivalent knowledge. 

---

Objectives

After completing this course, students will be able to:

• Validate field entries
• Create a custom input mask
• Create a master-detail form
• Add a picture to a form
• Display the current date on a form
• Create an advanced filter
• Create a parameter query
• Create an action query
• Create a master-detail report
• Add a cover sheet to a report
• Create and run a macro
• Create a command button
• Write an event procedure
• Set database startup options
• Set a database password
• Encode and decode a database
• Use the Database Splitter Wizard and the Linked Table Manager
• Create a replica of a database
• Create a switchboard
• Export Access data to an XML document
• Import an XML document into Access
• Save an Access database in an MDE file
• Create an Access workgroup

---

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