Overview: This class was designed for the advanced user who wants to learn skills to complete a database with complete user functionality. 

Duration:  1 day (9am-5pm)

Prerequisites:  A thorough knowledge of basic database design including building tables, forms, reports and queries, as well as the ability to understand and set relationships.  It is suggested that you complete Access Intermediate and Access Advanced before you attempt this class.

The skills taught in this class include:

Unit 1: Application design

Topic A: Planning an application
Topic B: Compact and Repair

Unit 2: Advanced forms

Topic A: Creating Subforms
Topic B: Creating Tabbed Forms 
Topic C: Creating Lists Forms

Unit 3: Working with form controls

Topic A: Working with dialog boxes
Topic B: Working with macro groups
Topic C: Using ActiveX Controls

Unit 4: Switchboards and splash screens

Topic A: Working with Switchboards
Topic B: Working with Splash Screens
Topic C: Automating Splash Screens

Unit 5: Custom Interfaces

Topic A: Working with toolbars 
Topic B: Creating custom menu bars
Topic C: Customizing Shortcut keys
Topic D: Creating Custom Help

Unit 6: Security

Topic A: Workgroups
Topic B: Use-Level Security Setup
Topic C:  User-Level Security Removal   

 

< PC Skills | Schedule | Sign Up >