The skills and knowledge covered in this publication are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access 2003.

• split the tables from a database file
• completely secure a database file and its objects so that unauthorised access is prevented
• create and maintain multiple copies of a database file
• create aggregated queries
• create a data access page
• create data access pages using the Design View
• create simple macros
• use conditions in macros
• create macros that used with forms
• create a macro for an option group to provide instant filtering
• write a simple procedure in VBA.

1. Splitting A Database
2. Database Replication
3. Aggregate Queries
4. Data Access Pages
5. Data Access Page Techniques
6. Macro Basics
7. Macro Techniques
8. Macros On Forms
9. Option Groups And Macros
10. VBA Introduction