ACCESS 2013 Intermediate Level

• Applying Validation Rules & Validation Text
• Activating the Lookup Wizard
• Using Hyperlinks
• Utilizing the OLE and Attachment Data Types
• Creating a Multi-field Primary Key
• Running a Relationship Report

Using a Variety of Query Types

• Querying With Two or More Tables
• Creating a Parameter Query
• Creating an Append Query
• Using the Make Table and Update Queries
• Applying a Delete Query
• Creating a Crosstab Query
• Finding Duplicates
• Finding Unmatched Data
• Grouping Records
• Showing Top Values

• Setting Tab Stops on Forms
• Adding Buttons to Forms
• Drawing Elements and Inserting Graphics
• Controlling Form Input Using Option Groups
• Aligning and Distributing Controls
• Changing the Default View of the Form

Enhancing Reports

• Adding a Calculated Field
• Applying Conditional Formatting
• Hiding Fields and Duplicates
• Creating Backgrounds
• Inserting Page Breaks and Creating Headers and Footers
• Grouping and Sorting

Maintaining and Customizing the Database

• Examining the Database Object Relationships
• Documenting the Access Database
• Protecting Data with a Password
• Creating Custom Ribbon Tabs
• Establishing Startup Options and Custom Icons
• Customizing the Navigation Pane
• Changing the Default Save Location