ACCESS 2013 Advanced Level

• Looking at the Macro Environment
• Creating a Macro
• Finding Macros in Objects
• Attaching a Macro to a Form Button
• Creating an AutoExec Macro

Applying Database Tools

• Creating a Database Backup
• Compacting and Repairing a Database
• Splitting a Database
• Converting a Database to an ACCDE File
• Exploring Access Options

Using Access with Other Applications

• Importing Data
• Exporting Data
• Exporting to PDF
• Exporting into a Word Mail Merge
• Publishing in HTML to a Web Browser

• Adding Calculated Fields
• Splitting a Single Field into Multiple Fields
• Converting Text to Proper Case
• Organizing with the Partition Function
• Querying Dates
• Nesting IIf Functions
• Developing a Union Query
• Setting a Starting AutoNumber
• Creating a Self Join Query

Applying Techniques to Forms and Reports

• Using Functions
• Adding Conditional Formatting and Data Bars
• Creating Multi-table Reports
• Using Sub forms
• Creating Lookup Forms
• Creating a Switchboard/Navigation Form