Access 97 VBA Programming

Prerequisites

Access 97 Advanced, or equivalent knowledge.

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

Students should already understand table, query, form, report, and macro design and function, as well as data normalisation 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 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 Using Visual Basic code to show and hide a customised form-view toolbar Creating a custom menu bar for a form Startup properties for toolbars and menus
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 global function Adding General procedures in a form module Creating event procedures
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

	Printer Friendly Version
	Download Outline As PDF

One of the best external courses I have ever attended

- Bayer