Who should attend? |
This course is intented for participants who are familiar
with Access 2000 - 2003. |
Prerequisites |
Access 2000 - 2003 Level 2 - Advanced Database Design |
Course Objectives |
Upon completion of the course, participants will be able to accomplish the following:
- Understand
macro concepts, create, run, and test Access macros
- Create
and use switchboard forms
- Set
Access defaults, apply Startup options, and
create and attach command bars
- Acquire
information about running administrative functions in Access
- Establish
and maintain security in a database
- Replicate
a database
|
Course Content |
|
|
Macros
Macro
Concepts ; Creating
Macros ; Creating
Macro Groups ; Opening
Macros ; Running
Macros ; Testing
Macros ; Attaching
a Macro ; Macro
Conditions ;
|
|
SwitchBoard
Switchboard Overview ; Creating
Switchboards ; Editing
a Switchboard Form ;
|
|
Customizing
Access
Setting
Access Defaults ; Startup
Options ; Customizing
Command Bars ;
|
|
Administrative
Functions
Compacting
Databases ; Documenting
a Database ; Splitting
Databases ;
|
|
Database
Security
Securing
Databases ; Securing
Share-Level Databases ; Securing
Multi-User Databases ;
|
|
Replicating
|