Course description
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: Level 1, Access 2000: Level 2, and Access 2000 Advanced or equivalent knowledge.
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
· Design an application by defining application objectives and requirements and by using external data sources.
· Navigate from one form to another in data-entry mode by using a command button.
· Automate a form designed as a dialog box by using a macro group.
· Create and modify a Switchboard form by using the Switchboard Manager.
· Customize forms by creating custom toolbars and menus.
· Create a form to use as a splash screen on application startup by setting properties and writing Visual Basic for Applications code.
· Identify elements of Visual Basic for Applications syntax and decide where to place code by examining a standard function, a module-level function, and an event procedure, including an event procedure to display a Web page in a Web Browser control on a form.
· Secure an application by defining application-level and file-level security, by creating a workgroup information file, and by setting a database password.
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 for Two Purposes: To Add or Edit Records
Lesson 3: Automating a Dialog-box Form with a Macro Group
Creating a Macro Group
Customizing an Unbound Form to Behave like 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 Toolbar
Creating a Custom Menu Bar for a Form
Startup Properties for Toolbars and Menu Bars
Lesson 6: Creating a Splash Screen Form
Creating a Form as a Splash Screen
Automating the Splash Screen Form by Using Visual Basic Code
Modifying Startup Properties to Display a Splash Screen Form
Documenting the Application
Lesson 7: 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
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