|ACCESS 97 - LEVEL 2
||1 Day - 8 Hour Class Session
||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.
Window 2000 Introduction or Windows
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
||Instructor-Led, Group Paced, Classroom-Delivery Learning Model with
Structured Hands-On Activities
||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
||Students enrolling in this course should have the basics of creating
and using database objects, including tables, queries, forms and reports.
||Access 97: Level 3
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
This is the last course in the series. Students will learn to create custom applications
and also use advanced Visual Basic techniques
||Normalize sample tables by identifying
Establish relationships between tables by analyzing table relationships and enforcing
Customize table designs by setting field properties to maintain data integrity and
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
Display table information that has a one-to-many relationship by creating forms that
Customize report designs by grouping, sorting, and summarizing data, and by adding
Please Contact Us For Class Outlines.