Access: Intro to Application Development

Overview: Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Table of Contents

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 commandbutton 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 MacroGroup
          Creating a Macro Group
           Looking at a form and how it is affected by 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 ShowToolbar 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 AutoExecmacro
           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-levelSecurity
           Creating a new workgroup information file
           Activating the logon procedure
           Creating group accounts
           Creating user accounts
           Setting your logon password and removing the Admin userfrom 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

Close window