Microsoft Access: Advanced

Course details

This two-day course is designed to help a delegate to obtain the skills required to work with Charts & Pivot Tables, Create Macros and Customize Microsoft Access.

A delegate will also learn to work with Advanced Queries, Forms and Reports.

Course Outline

Module 1

Creating Charts & Pivot Tables

• Creating a Freestanding Chart
• Customizing a Chart
• Building a better Chart
• Freezing the Data in Your Chart
• Understanding Pivot Table Procedures
• Creating a Pivot Table — Wizard
• Editing a Pivot Table

Module 2

Networking & Security

• Allowing Users to Share Data
• Preventing Exclusive Access
• Editing Data on a Network
• Multi-User Settings
• Securing your Database
• The User-Level Security Wizard
• Password Security

Module 3

Macros

• How to Create a Macro
• Determining when a Macro Plays
• Summary of Macro Actions
• Creating Macro Groups
• Editing a Macro
• Dealing with Macro Errors
• Creating a Macro to Run at Startup

Module 4

Creating Custom Switchboards

• Changing a Wizard-Created Switchboard
• Creating a Switchboard from Scratch
• Filling out the Switchboard
• Making a Switchboard appear at Startup

Module 5

Customize Access

• Creating Custom Dialog Boxes
• Creating Custom Toolbars
• Creating Custom Menus

Module 6

Creating Complex Filters

• Choosing Fields to Filter
• Specifying Selection Criteria
• Saving a Filter as a Query

Module 7

Advanced Queries

Creating AutoLookup Queries
Using Calculated Fields
Creating Crosstab Queries
Creating Action Queries

• Update Query
• Append Query
• Make Table Query

Module 8

Advanced Forms & Reports

Creating a Form/Report from scratch
Designer Skills
Sections/Headers/Footers
Adding Your Own Controls

• Text Boxes
• Option Buttons
• Check Boxes
• List Boxes
• Command Buttons
• Hyperlinks

Calculated Fields
Putting a Preprinted Form on Screen

Module 9

Personalizing Access

Personalizing Work Environment (Changing Option Settings) Personalize a Database (Changing Startup Options)

Module 10

Speeding up your Database

• Speeding up General Performance
• Speeding up Tables
• Speeding up Queries
• Speeding up Forms & Reports

Module 11

Administering Your Database

• Backing Up a Database
• Compacting a Database
• Repairing a Damaged Database
• Documenting Your Database
• Replicating Your Database