Access: Introduction to Application Development

Course Content

Lesson 1: Application Design Concepts

Planning an Application
Examining a Completed Application
Developing a Distributed Application Design

Lesson 2: Adding Command Buttons to Guide User Navigation

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

Lesson 3: Automating a Dialog-box Form with a Macro Group

Creating a Macro Group
Customizing an Unbound Form to Behave like a Dialog Box
Documenting a Macro Group

Lesson 4: Creating a Switchboard Form

Using the Switchboard Manager
Setting Database Startup Properties

Lesson 5: Working with Custom Toolbars and Menus

Using a Macro Group to Show and Hide a Toolbar
Creating a Custom Menu Bar for a Form
Startup Properties for Toolbars and Menu Bars

Lesson 6: Creating a Splash Screen Form

Creating a Form as a Splash Screen
Automating the Splash Screen Form by Using Visual Basic Code
Modifying Startup Properties to Display a Splash Screen Form
Documenting the Application

Lesson 7: Using Visual Basic Procedures

Creating a Public Function
Adding General Procedures in a Form Module
Creating Event Procedures
Viewing a Live Web Site on a Form

Lesson 8: Adding Security to an Application

Security Overview
Steps to Securing a Database by Using User-level Security
Documenting Database Security
Securing a Database with a Database Password
Distributing the Secured Application