1 - day course
Print this page
Course Code: D133
Who should attend?
This course is intented for participants who are familiar with Access 2003.
Prerequisites
Access 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 a Macro ; Creating a Macro Group ; Opening a Macro ; Running a Macro ; Testing a Macro ; Attaching a Macro ; Macro Conditions ;
    SwitchBoard
    Switchboards ; Creating Switchboards ; Editing a Switchboard Form ;
    Customizing Access
    Setting Access Defaults ; Startup Options ; Customizing Command Bars ;
    Administrative Functions
    Compacting a Database ; Documenting a Database ; Splitting a Database ;
    Database Security
    Securing a Database ; Securing a Share-Level Database ; Securing a Multi-User Database ;
    Replicating
    Replicating a Database ;