|
Provided by: Serebra Learning Corporation Microsoft Access 2000 IntermediateAccess |
 |
Training
Provided by Serebra Learning Corporation
This highly interactive CBT contains six units that cover intermediate Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 2000, students learn how to create complex queries, forms, and reports, share Access information with other programs, and add objects to a form. Related Exam: MOUS Access 2000 Expert. Designed to teach intermediate Access skills.
|
|
||||||||||
Microsoft Access 2000 Intermediate
Audience
Designed to teach intermediate Access skills.
Topics
Unit 1: Creating Multiple Table Queries
- Creating Select Queries
- Sorting a Query on Multiple Fields
- Developing AND Queries
- Developing OR Queries
- Creating Calculated Fields
- Building Summary Queries
- Creating Crosstab Queries
- Modifying Crosstab Queries
Unit 2: Developing Forms and Subforms
- Understanding the Form/Subform Relationship
- Creating Forms with Subforms Using the Form Wizard
- Creating Subforms Using Queries
- Modifying Subforms
- Adding Combo Boxes
- Adding Option Groups
- Adding Command Buttons
- Adding Records with a Form/Subform
Unit 3: Building Complex Reports
- Using the Database Wizard
- Importing Data
- Creating a Report from a Parameter
- Enhancing Report
Objectives
Upon completion of this course, the student will be able to:Create multiple-table queries, including select, AND, OR, summary and crosstab queries Develop forms and subforms Add combo boxes, option groups, and command buttons to forms Build and format complex reports by using the Database Wizard, imported data, a parameter query and Autoformats Share Access information with other programs Create data access pages to connect your database to the World Wide Web Create advanced queries, including update, make-table, append and delete 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...
