Access 97: Introduction to Application Development

Code:

 ZD52-443

Series:

 Office Productivity

Duration:

 1 day
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 to add or edit records

Automating a dialog-box form with a macro group
Creating a macro group
Customizing 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
Using Visual Basic code to show and hide a customized form-view toolbar
Creating a custom menu bar for a form
Startup properties for toolbars and menus		 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 global function
Adding General procedures in a form module
Creating event procedures

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

Appendices
APP.MDB diagram
Planning an application
Importing spreadsheets, databases, and delimited text files
Access 97: Introduction to Application Development


Course specifications
Course number: 052-443
Software version number: 97
Course length: 1 day


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 code.

Prerequisites:
Access 97: Level 1, Level 2, and Advanced or equivalent knowledge.

Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:
Students will learn how to build an application by designing and creating the database objects and a graphical user interface.

Target student:
Students enrolling in this course should understand table, query, form, report, and macro design and function, as well as data normalization and table relationships.


Access 97: Introduction to Application Development

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.
  • Create and use custom toolbars and menus by using the Customize dialog box.
  • Create a form to use as a splash screen on application startup by setting properties and writing Visual Basic code.
  • Identify elements of Visual Basic for Applications syntax and decide where to place code by examining a global function, a module-level function, and an event procedure.
  • Secure an application by defining application-level and file-level security, by creating a workgroup information file, and by setting a database password.