SAYERS & ASSOCIATES

Computer Training

 

 

Course Description

ACCESS 97 - LEVEL 3

Course Length 1 Day - 8 Hour Class Session

Overview Students will learn how to create action queries, more efficient forms and reports, and macros. This course meets the Microsoft Proficiency Guidelines for Access at the Expert level.

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

Delivery Method Instructor-Led, Group Paced, Classroom-Delivery Learning Model with Structured Hands-On Activities

Benefits

Students will learn how to analyze data by creating complex queries, speed repetitive tasks by creating macros, and work with Access on the Internet.

Target Student Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.

What's Next Access 97 Level 4 - Expert
Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic code.

Objectives Make select queries more versatile by using parameters; and use action queries to update data values and add or delete records.

Refine the information derived from queries by creating outer joins and using crosstab queries.

Enhance form design by manipulating control object properties.

Automate simple tasks by creating macros to open forms and control form properties.

Make forms more functional and automate tasks by creating macros.

Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls.

Use Access to create links to Internet sites, and to save data as HTML documents.


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