Creating Advanced Reports 

• Applying Advanced Formatting
• Grouping Controls
• Setting Advanced Print Layout
• Creating Charts
• Modifying Charts
• Applying Chart Types
• Creating Mult-Column Reports
• Creating Mailing Labels

Managing Database Objects 

• Working with Objects
• Using the Documenter
• Grouping Objects
• Modifying Shortcuts and Groups
• Creating a Dialog Box
• Creating a Pop Up Form
• Modifying a Switchboard

Creating Macros 

• Understanding Macros
• Creating a Macro
• Modifying Actions and Arguments
• Creating a Macro Group
• Setting Conditional Expressions
• Working with Events
• Assigning a Macro to a Command Button
• Troubleshooting Macros

Creating Modules and VBA 

• Understanding Modules and VBA
• Comparing Macros and Modules
• Creating Functions
• Using IF Statements
• Documenting Procedures
• Examing Class Modules
• Creating Sub Procedures
• Troubleshooting Modules 

Maintaining the Database 

• Backing up a Database
• Using Portable Storage Media
• Converting a Database
• Encrypting a Database and Setting a Password
• Changing Access and Startup Options
• Analyzing Database Performance
• analyzing Table Performance
• Splitting a Database
• Compacting and Repairing a Database