Course Outlines
Access 2000 - Applications Development (2 Day)

Prerequisites:  Access 2000 - Advanced or equivalent knowledge.

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 to Add or Edit Records

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

  • Creating a Macro Group
  • Customizing an Unbound Form as 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 Customized Form-View Toolbar
  • Creating a Custom Menu Bar for a Form
  • Startup Properties for Toolbars and Menus

Lesson 6: Creating a Splash Screen Form

  • Creating a Form as a Splash Screen
  • Automating the Splash Screen Form
  • Modifying the Startup Properties to Display a Splash Screen
  • Documenting the Application

Lesson 7: Using Visual Basic Procedures

  • Creating a Global 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

 

 

 

Access

Excel

Word

PowerPoint

Project

FrontPage

Outlook

Windows

MS Office

Other