Access 2000 VBA Programming

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