Application Development w/Access

3-day workshop, $380 +tax
9:00 am-4:00 pm

Application Development with Access is hands-on instruction that will guide you through the process of developing an application by using one or more Access databases. Students that are proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who need to draw on all of these skills and add code to create an application.

This class is designed for the student who is proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who needs to draw on all these skills and add code to create an application. The prerequisite courses for this course are:

1. Introduction to Computers
2. Introduction to Access
3. Advanced Access

Skills developed in this course:

You will learn about the process of developing an Access application by using one or more Access databases.  This is the last class in the Access series. You may consider the other series (Word, Excel, and so on) to increase your experience with the Office suite.

Class-Based Objectives

• Design an application by planning the scope and components of an application and by using external data sources.
• Navigate from one form to another form in data-entry mode by using a command button, and make a command button invisible on the second form.
  
• Automate a form designed as a dialog box by using a macro group.
  
• Create and modify a Switchboard form by using the Switchboard Manager. Display the Switchboard form when the database opens by changing database Startup properties.
  
• Create and use custom toolbars and menus by using the Customize dialog box and setting properties.
  
• Create an unbound 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 Application syntax and decide where to place code by working with a standard function, a Private module-level procedure, and Sub procedures attached to event properties.
  
• Secure an application by defining application-level and file-level security, by creating a workgroup information file, and by setting a database password

These are a few of the skill you will learn:

• Planning an Application
• Moving through a Completed Application
• Developing a Distributed Application Design
• Using One Form for Two Purposes: To Add or Edit Records
• Creating a Macro Group
• Customizing an Unbound Form to Behave like a Dialog Box
• Documenting a Macro Group
• Using the Switchboard Manager
• Setting Database Startup Properties
• Using a Macro Group to Show and Hide a Toolbar
• Creating a Custom Menu Bar and Shortcut Menu for a Form
• Startup Properties for Toolbars and Menu Bars
• 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
• Creating a Public Function
• Adding General Procedures in a Form Module
• Creating Event Procedures
• Viewing a Live Web Site on a Form
• 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