Microsoft Access 2003 Advanced Training Course

ADVANCED TABLE DESIGN TECHNIQUES

• Validating Field Entries
  Creating a Custom Input Mask

ADVANCED FORM TECHNIQUES

• Creating a Master-Detail Form
• Adding a Picture to a Form
• Displaying the Current Date on a Form
• Modifying Form Properties

ADVANCED FILTER AND QUERY TECHNIQUES

• Creating an Advanced Filter
• Including Multiple Conditions in a Query
• Creating a Parameter Query
• Creating an Action Query

ADVANCED REPORT TECHNIQUES

• Creating a Master-Detail Report
• Completing the Report
• Adding a Cover Sheet to a Report
• Modifying Report Properties

WORKING WITH MACROS AND MODULES

• What is a Macro?
• Creating a Macro
• Running a Macro
• Creating a Command Button
• Writing an Event Procedure

USING TOOLS MENU OPTIONS

• Setting Database Startup Options
• Setting a Database Password
• Encoding and Decoding a Database
• Using the Database Splitter Wizard and the Linked Table Manager
• Creating a Replica of a Database

ADDITIONAL ADVANCED ACCESS FEATURES

• Creating a Many-to-Many Relationship Between Tables
• Creating a Switchboard
• Exporting Access Data to an XML Document / Importing an XML Document into Access
• Saving an Access Database in an MDE File
• Creating an Access Workgroup
• Macro Security