Microsoft Access Level 4 Training Class

Training Menu

Microsoft Access Level 4 - Introduction to Application Development

This is a one day, advanced class that assumes you have already taken the following courses: Access Level 1, Access Level 2 and Access Level 3 (or you have gained equivalent knowledge on your own).

Target Student:

Students that are proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who need to draw on all of these skills and add code to create an application.

Course outline:

Lesson 1: Application Design Concepts

Topic 1A: Planning an Application

Topic 1B: Moving through a Completed Application

Topic 1C: Developing a Distributed Application Design

Lesson 2: Adding Command Buttons to Guide User Navigation

Topic 2A: Using One Form for Two Purposes: To Add or Edit Records

Lesson 3: Automating a Dialog Box Form with a Macro Group

Topic 3A: Creating a Macro Group

Topic 3B: Customizing an Unbound Form to Behave like a Dialog Box

Topic 3C: Documenting a Macro Group

Lesson 4: Creating a Switchboard Form

Topic 4A: Using the Switchboard Manager

Topic 4B: Setting Database Startup Properties

Lesson 5: Working with Command Bars: Toolbars and Menus

Topic 5A: Using a Macro Group to Show and Hide a Toolbar

Topic 5B: Creating a Custom Menu Bar and Shortcut Menu for a Form

Topic 5C: Startup Properties for Toolbars and Menu Bars

Lesson 6: Creating a Splash Screen Form

Topic 6A: Creating a Form as a Splash Screen

Topic 6B: Automating the Splash Screen Form by Using Visual Basic Code

Topic 6C: Modifying Startup Properties to Display a Splash Screen Form

Topic 6D: Documenting the Application

Lesson 7: Using Visual Basic Procedures

Topic 7A: Creating a Public Function

Topic 7B: Adding General Procedures in a Form Module

Topic 7C: Creating Event Procedures

Topic 7D: Viewing a Live Web Site on a Form

Lesson 8: Adding Security to an Application

Topic 8A: Security Overview

Topic 8B: Steps to Securing a Database by Using User-level Security

Topic 8C: Documenting Database Security

Topic 8D: Securing a Database with a Database Password

Topic 8E: Distributing the Secured Application

Appendix A: APP.MDB Diagrams

Book Invoice Application

Access Application

Appendix B: Planning an Application

Planning an Application

Appendix C: Importing Spreadsheets, Databases, and Delimited Text Files

Importing and Linking Data from Spreadsheets

Importing and Linking Database Files

Importing Text Files