Microsoft Access 2000 Advanced
| Duration: | 1 day |
| Prerequisite: | Microsoft Access Introductory or equivalent experience |
| Course Materials: | Course manual with CD containing exercises, 144 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the Advanced concepts of Microsoft Access 2000 with managing database objects, creating macros and graphic reports, understanding modules, and maintaining databases. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Creating Advanced Forms and Reports
Adding Check Boxes and Toggle Buttons
Using Conditional Formatting
Creating Custom Help
Adding Tab Controls
Adding Charts
Modifying Charts
Adding Subreport Controls
Modifying Section Properties
Managing Database Objects
Work with Objects
Using the Documenter
Grouping Objects
Modifying Groups
Creating a Dialog Box
Creating a Pop-up Form
Creating a Switchboard
Modifying a Switchboard
Creating Macros
Understanding Macros
Creating a Macro
Modifying Actions and Arguments
Creating a Macro Group
Setting Conditional Expressions
Assigning a Macro to an Event
Customizing Toolbars with macros
Troubleshooting Macros
Creating Modules
Understanding Modules
Understanding Macros Versus Modules
Creating a Function Procedure
Use If Statements
Documenting a Procedure
Examining Class Modules
Creating a Sub Procedure
Troubleshooting Module
Managing the Database
Converting databases
Setting Passwords
Changing Startup Options
Encrypting and Decrypting a database
Analyzing Performance
Splitting a Database
Replicating Using the Briefcase
Synchronizing Using the Briefcase