SAYERS & ASSOCIATES

Computer Training

 

 

Course Description

ACCESS 97- LEVEL 4 - EXPERT

Course Length 1 Day - 8 Hour Class Session

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.

Prerequisite Window 2000 Introduction  or Windows XP Introduction
Word 97 Level 1
Word 97 Level 2
Word 97 Level 3
Excel 97 Level 1
Excel 97 Level 2
Excel 97 Level 3
Access 97 Level 1 
Access 97 Level 2 
Access 97 Level 3

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. 

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


Please Contact Us For Class Outlines.

   

                

e-mail.gif (7997 bytes)To Contact Us:

training@sayers-associates.com
Office:    (479) 452-4439
                   (888) 933-3579
    Fax:    (479) 452-4418
       Post Office Box 10783  

             Fort Smith, Arkansas 72917