Access Level 3

Prerequisites:Students Looking to take this course should have taken an introduction to computers class, Access Level 1, and Access Level 2 or the equivelant knowledge.

Designing Applications
 · Previewing Existing Applications
 · Table Structures and Relationships

Creating Advanced Controls
 · Using Lookup Fields
 · Creating Controls
 · Setting Control Properties
 · Testing Controls
 · Calculating Values
 · Sub form Controls
 · Other Calculated Controls

Creating Dialog Boxes
 · Setting Dialog Box Form Properties
 · Adding Dialog Box Controls
 · Creating Options Groups
 · Creating Command Buttons
 · Specifying Defaults
 · Enhancing Dialog Boxes

Using Macros
 · Creating Independent Macros
 · Attaching Macros to Events on Forms
 · Creating Event Macros
 · Creating Conditional Macros

Custom Toolbars
 · Creating Custom Toolbars
 · Adding Buttons to Custom Toolbars
 · Appearance of Toolbar Buttons
 · Custom Toolbars Using Visual Basic

Menus and Shortcuts
 · Creating Custom Menus
 · Creating Custom Shortcut Menus
 · Creating Custom Menu Commands

Creating Switchboards
 · Creating Switchboard Forms
 · Macros for Switchboard Controls
 · Macros to Switchboard Controls

Enhancing Applications
 · Creating Keyboard Shortcut Macros
 · Control Tips and Status Messages
 · Setting Startup Properties
 · Adjusting Objects
 · Adjusting Database Objects
 · Viewing Application Enhancements

Testing Applications
 · Testing Application Performance
 · Identifying Design Issues
 · Resolving Design Issues

Establishing Basic Security
 · Using Advanced System Options
 · Using Database Passwords
 · Working with User-Level Security
 · Enabling the Logon Feature
 · Creating User and Group Accounts
 · Removing and Assigning



Close this Window

SiliconBay Training
4847 Hopyard Rd Suite #4165
Pleasanton, CA 94588
Phone: (925) 462-3277