Course content

Lesson 1: Application Design Concepts

• Planning an Application
  
• Defining application objectives and requirements
  
• Sketching application objects
  
• Moving through a Completed Application
  
• Looking at the flow and automation of an application's objects
  
• Discussing the benefits of and issues surrounding the use of a distributed application design model
  
• Linking Access tables stored in a separate database
  
• Importing a file into a database

Lesson 2: Adding Command Buttons to Guide User Navigation

• Using One Form for Two Purposes: To Add or Edit Records
  
• Looking at the completed Customer form and its command buttons
  
• Using Visual Basic for Applications code to program a command
• button on one form to open another form ready for adding a new record
  
• Setting a command button's Visible property with an expression

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
  
• Analyzing completed form properties that determine dialog-box design
  
• Analyzing command button, option group, and list box properties
  
• Documenting a Macro Group
  
• Running a report to document a macro group

Lesson 4: Creating a Switchboard Form

• Using the Switchboard Manager
  
• Creating a switchboard with several command buttons
  
• Testing the Switchboard form
  
• Modifying the Switchboard form
  
• Setting Database Startup Properties
  
• Setting startup properties to open the Switchboard form and hide the
• Database window
  
• Testing the application startup

Lesson 5: Working with Command Bars: Toolbars and Menus

• Using a Macro Group to Show and Hide a Toolbar
  
• Analyzing the Show Toolbar macro action
  
• Analyzing and building a custom toolbar
  
• Creating a Custom Menu Bar and Shortcut Menu for a Form
  
• Analyzing built-in menus and standard menu items
  
• Analyzing a custom menu bar
  
• Building a custom menu bar
  
• Startup Properties for Toolbars and Menu Bars
  
• Analyzing the startup options for toolbars, menu bars, and Access special keys

Lesson 6: Creating a Splash Screen Form

• Creating a Form as a Splash Screen
  
• Analyzing the properties of an unbound form
  
• Automating the Splash Screen Form by Using Visual Basic Code
  
• Using a VBA procedure to open a form when another form closes
  
• Using Visual Basic to set a form's OnTimer event and to close the form
  
• Modifying Startup Properties to Display a Splash Screen Form
  
• Changing the form that is displayed upon database startup
  
• Setting additional startup conditions with the AutoExec macro
  
• Documenting the Application
  
• Using the Documenter to run a report on multiple database objects

Lesson 7: Using Visual Basic Procedures

• Creating a Public Function
  
• Defining general function and basic syntax rules
  
• Analyzing a function that increments to the next unused customer ID number
  
• Assigning a public function to a command button's Click event
  
• Adding General Procedures in a Form Module
  
• Enabling and disabling buttons on forms
  
• Analyzing the code for the EnableButtons() Sub procedure
  
• Calling a Sub procedure to enable or disable buttons on a form
  
• Running an event procedure to check the status of several text boxes
  
• Creating Event Procedures
  
• Testing and analyzing the design of a combo box that searches for data
  
• Coordinating the events of two forms by requerying a control to update data
  
• Analyzing code for a form's Unload procedure that uses the Requery method
  
• Viewing a Live Web Site on a Form
  
• Creating a Web Browser control on a form
  
• Creating an event procedure to display a Web site in a control on a form

Lesson 8: Adding Security to an Application

• Security Overview
  
• Discussing the need for security
  
• Steps to Securing a Database by Using User-level Security
  
• Creating a new workgroup information file
  
• Activating the logon procedure
  
• Creating group accounts
  
• Creating user accounts
  
• Setting your logon password and removing the Admin user from the
• Admins group
  
• Using the Security Wizard
  
• Granting permissions to a database and its objects
  
• Testing security
  
• Documenting Database Security
  
• Printing reports about security users and groups
  
• Previewing reports about user and group permissions by object
  
• Securing a Database with a Database Password
  
• Setting a database password
  
• Removing a database password
  
• Distributing the Secured Application

Return to Courses