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.
| This course consists of 11 modules |
| Module One |
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 Two |
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 Three |
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 Four |
Creating Custom Switchboards
Changing a Wizard-Created Switchboard
Creating a Switchboard from Scratch
Filling out the Switchboard
Making a Switchboard appear at Startup |
| Module Five |
Customize Access
Creating Custom Dialog Boxes
Creating Custom Toolbars
Creating Custom Menus |
| Module Six |
Creating Complex Filters
Choosing Fields to Filter
Specifying Selection Criteria
Saving a Filter as a Query |
| Module Seven |
Advanced Queries
Creating AutoLookup Queries
Using Calculated Fields
Creating Crosstab Queries
Creating Action Queries
- Update Query
- Append Query
- Make Table Query |
| Module Eight |
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 Nine |
Personalizing Access
Personalizing Work Environment
(Changing Option Settings)
Personalize a Database
(Changing Startup Options) |
| Module Ten |
Speeding up your Database
Speeding up General Performance
Speeding up Tables
Speeding up Queries
Speeding up Forms & Reports |
| Module Eleven |
Administering Your Database
Backing Up a Database
Compacting a Database
Repairing a Damaged Database
Documenting Your Database
Replicating Your Database |
