Computer Help Training: Access Courses - Toronto - North York - Mississauga

Access
Introduction

2 Days (9am to 4pm)
$ 550. or 2 Tickets

Other Access Course Levels

Introduction
Intermediate Level 1
Intermediate Level 2
Queries
Advanced
VBA Level 1
VBA Level 2
Version 2007/2010 Upgrade

Register Now

Contact Us

View PDF Course Outlines for All Access Courses

Locations

Toronto
20 Queen Street West, Suite 3306
(Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(Yonge St. & Mulock Dr.)

Microsoft Access is a very powerful tool for storing and analyzing lists of information, but that power comes at the cost of being trickier to learn than the other parts of MS Office. This course will get you over that hurdle. You’ll begin learning how your company database works by creating a simple one of your own. Then students will be taught how to pull information from databases, create forms for displaying old data on the screen as well as adding new data, and produce professional-looking printed reports.

Course Prerequisite: Required: Knowledge of basic Windows use and ability to use keyboard and mouse. Recommended: Use of one or more other programs, such as Excel or Word.

Overview
What is a Database?
Database Objects in Access
Creating / Opening Databases

Tables (Design View)

Creating a Table

Adding Fields

Field Data Types

Saving

Insert Fields

Moving Fields

Change Field Name

Change Field Data Type

Working with Attachments (2007/2010)

Field Size

Format & Decimal Places

Default Value

Caption

Validation Rule/Text

Required

Allow Zero Length

Indexed

Input Mask

Tables (Datasheet View)

Entering Data

Adding Pictures

Zoom and Line Breaks

Column Widths/Row Height

Navigating Records

Formatting Cells

Hiding Columns

Freezing Columns

Cut, Copy & Paste

Deleting Records

AutoNumbers

Sorting

Finding

Filter by Selection

Text Filters, Number Filters, Data Filters (2007/2010)

Filter by Form

Save Filter as Query

Queries

Creating Queries

Adding Fields to Grid

Entering Criteria

Running a Query

Sorting and Hiding

Saving a Query

Moving Columns

Performing Calculations

Formatting Columns

Parameter Queries

Totals Queries

Forms

AutoForms

Split Forms (2007/2010)

Design & Form Views

Layout View (2007/2010)

Moving/Sizing Controls

Edit Text Labels

The Form Header/Footer

Entering Data in the Form

Reports

AutoReports

Report Bands

Adjusting Controls

Merging Fields

Previewing and Printing

Database Objects

Rename Objects

Making a Copy

Deleting Objects

Versions	Toronto	North York	Mississauga	Newmarket
2007/2010	Apr 2/3	Feb 6/7	Feb 13/14	Mar 5/6