|
Provided by: Serebra Learning Corporation Microsoft Access 97 IntermediateAccess |
![]() |
Training
Provided by Serebra Learning Corporation
This highly interactive CBT contains three units that cover advanced Access 97 skills. Through step-by-step instruction within a realistic simulation of Microsoft Access, individuals learn how to create multiple task queries, develop form as and sub-forms, create complex reports, share access information with other office programs and create advanced queries. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long after course completion. This course is designed for individuals who have a basic proficiency in Access 97.
|
|
||||||||||
Microsoft Access 97 Intermediate
Audience
This course is designed for individuals who have a basic proficiency in Access 97.
Topics
Unit 1: Creating Multiple Task Queries
- Creating Select Queries
- Sorting a Query on Multiple Fields
- Developing AND Queries
- Developing OR Queries
- Developing Calculated Fields
- Adding Calculation on Groups of Records
- Developing Crosstab Queries
- Creating Update Queries
Unit 2: Developing Forms and Subforms
- Creating a Form from Multiple Tables
- Moving and Resizing Controls
- Adding Labels and Formatting Controls
Objectives
Upon completion of this course, the student will be able to:- Create complex queries using the AND and OR logical operators
- Create crosstab and update queries
- Develop forms with subforms
- Move, resize, and format controls on a form
- Sort, find, and filter records using a form
- Create complex reports that include report sections, group headers, calculations, graphics, color and special effects
- Share Access information with other Office programs
- Create advanced queries, including top values, parameter, AutoLookup, make-table, append, delete and union queries
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

