Word Processing Services in Toronto Ontario, Night School Toronto, Web Design School in Toronto, Graphic Design Schools in Toronto.
IT, Engineering & Executive Recruitment Specialists, Professional Resume Writing, Interview Coaching and Skills Development

Microsoft Access 2003 - Level 1

Duration: One Day(10AM to 4PM with One Hour Lunch Break)
                  (Weekdays & Saturday)

Cost: $699 +HST

Class Size: 1-3 Persons,Instructor lead training

Course Outline

Lesson 1: An Overview of Microsoft Access
Relational Databases
The Access Environment
The Database Environment
Examine an Access Table

Lesson 2: Managing Data
Examine an Access Form
Add and Delete Records
Sort Records
Display Record Sets
Update Records
Run a Report

Lesson 3: Establishing Table Relationships
Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Working with Subdatasheets

Lesson 4: Querying the Database
The Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms
Form Design Guidelines
Create AutoForms
Create a Form Using the Form Wizard
Modify the Design of a Form

Lesson 6: Producing Reports
Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report

Lesson 7: Planning a Database
Design a Relational Database
Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys

Lesson 8: Building the Structure of a Database
Create a New Database
Create a Table Using a Wizard
Create Tables in Design View
Create Relationships between Tables

Lesson 9: Controlling Data Entry
Restrict Data Entry with Field Properties
Create an Input Mask
Create a Lookup Field

Lesson 10: Finding and Joining Data
Find Data with Filters
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Lesson 11: Creating Flexible Queries
Set Select Query Properties
Create Parameter Queries
Create Action Queries

Lesson 12: Improving Your Forms
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add Command Buttons
Create a Subform

Lesson 13: Customizing Your Reports
Organize Report Information
Set Report Control Properties
Control Report Pagination
Summarize Information
Add a Subreport to an Existing Report
Create Mailing Labels

Lesson 14: Expanding the Reach of Your Data
Publish Access Data as a Word Document
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

For more information please call us at (647) 271-3330 or Email us at: support@writing4careers.com



2010 | All rights reserved | Webmaster: Rachel Ma