Access 97: Introduction To Application Development

Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic code.

Benefits

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

Prerequisites

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

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.

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.

Delivery Method:

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

Course duration

1 Day(s)

Course outline

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

Lesson 3: 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

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

Lesson 6: 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

Lesson 7: Using Visual Basic procedures

Creating a global function
Adding General procedures in a form module
Creating event procedures

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

Appendix A: APP.MDB diagram

Appendix B: Planning an applications

Appendix C: Importing spreadsheets, databases, and delimited text files

Hardware/Software Requirements

You will need 12 megabytes (MB) of Random Access Memory (RAM) if you are using Microsoft Access. See your reference manual for hardware considerations that apply to your specific hardware setup.

In addition, you will need to install printer drivers (either local or network). This book was written using the Windows 95 platform; however, the manufacturer’s documentation states that Access 97 can also run on Windows NT 3.51 Workstation or Windows NT 4.0.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.