Publisher: Microsoft

Version: 2000
Length: 2 day s
Course-ID: 076403x

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