Access 2000 VBA Programming

2 days

Overview

Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code.

Prerequisites

Access 2000 Advanced, or equivalent knowledge.

Benefits

Students will learn how to build an application by designing and creating the database objects and a graphical user interface.

Target student

Students should already understand table, query, form, report, and macro design and function, as well as data normalization and table relationships.

Application design concepts

Planning an application
Examining a completed application
Developing a distributed application design

Adding command buttons to guide user navigation

Using one form for two purposes to add or edit records

Automating a dialog-box form with a macro group

Creating a macro group
Customising an unbound form as a dialog box
Documenting a macro group

Creating a Switchboard form

Using the Switchboard Manager
Setting database startup properties

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

Creating a Splash Screen form

Creating a form as a splash screen
Automating the Splash Screen form
Modifying startup properties to display a Splash Screen form
Documenting the application

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

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