SAYERS & ASSOCIATES

Computer Training

 

 

Course Description

ACCESS 97 - LEVEL 2

Course Length 1 Day - 8 Hour Class Session

Overview Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple table for data that is used in customized forms and reports. 

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

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

Benefits Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports.

Target Student Students enrolling in this course should have the basics of creating and using database objects, including tables, queries, forms and reports.

What's Next Access 97:  Level 3 Advanced  
In this course students learn advanced features such as creating advanced queries, creating more efficient forms and reports and working with macros. 

Access 97:  Level 4 Expert - Introduction to Application Design 
This is the last course in the series. Students will learn to create custom applications and also use advanced Visual Basic techniques

Objectives Normalize sample tables by identifying design problems. 

Establish relationships between tables by analyzing table relationships and enforcing referential integrity. 

Customize table designs by setting field properties to maintain data integrity and creating indexes. 

Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values. 

Customize form designs by creating calculated fields, combo boxes, and unbound controls. 

Display table information that has a one-to-many relationship by creating forms that contain sub-forms. 

Customize report designs by grouping, sorting, and summarizing data, and by adding sub-reports. 


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