Microsoft Access 2007: Level 1

Duration: 15 Hrs

Cost: $599 + GST

Enrollment for additional Course or second kid - 10% discount

Course Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.

Performance-based Objectives

Upon successful completion of this course, students will be able to:

• examine the Microsoft® Office Access 2003 database application.
• manage the data in a database.
• examine existing table relationships.
• query the database.
• design simple forms.
• create and modify Access reports.

Course Outline

1. An Overview of Access 2007
1. Relational Databases
2. The Access Environment
3. The Database Environment
4. Examine an Access Table
2. Managing Data
1. Examine an Access Form
2. Add and Delete Records
3. Sort Records
4. Display Record Sets
5. Update Records
6. Run a Report
3. Establishing Table Relationships
1. Identify Table Relationships
2. Identify Primary and Foreign Keys in the Relationships Window
3. Working with Subdatasheets
4. Querying the Database
1. The Select Query
2. Add Criteria to a Query
3. Add a Calculated Field to a Query
4. Perform a Calculation on a Record Grouping
5. Designing Forms
1. Form Design Guidelines
2. Create AutoForms
3. Create a Form Using the Form Wizard
4. Modify the Design of a Form
6. Producing Reports
1. Create an AutoReport
2. Create a Report by Using the Wizard
3. Examine a Report in Design View
4. Add a Calculated Field to a Report
5. Modify the Format Properties of a Control
6. AutoFormat a Report
7. Adjust the Width of a Report

For more information on any course, please call us at (647)-430-7478 or Email us at:   hr@whizkids.ca