|
|
Microsoft Access
Introduction
Intermediate
Level 1
Intermediate
Level 2
Queries
Advanced
VBA Level
1
VBA Level
2
Version
2007 Upgrade
Register Now
View Course Outline PDF
(all Access Courses show in one PDF file)
|
|
Course Dates (9am to 4pm)
|
Versions |
Toronto |
North York |
Mississauga |
Newmarket |
|
Version 2003 |
May 8/9
Jul 15/16
Sep 10/11
|
May 1/2
Jul 8/9
Sep 4/5
|
Apr 3/4
Jun 26/27
Aug 11/12
|
Apr 7/8
Jun 3/4
Aug 18/19
|
|
Version 2007 |
|
Apr 1/2
Jul 21/22 |
May 5/6
Sep 8/9 |
|
Course Prerequisites
Required: Knowledge of Windows Introduction topics and ability
to use keyboard and mouse. Recommended: Use of one or more other
programs, such as Excel or Word.
Course Description
This course is intended as a
starting point for Access beginners, or people who use databases created
by others. The main focus is to learn how to create tables and
queries. Table topics: field names, types, setting the properties for
each field, entering records, sorting, finding, filtering, and
formatting. Query topics: the grid, adding tables, entering criteria,
parameters, calculations, and totals. A brief look at forms and
reports is also covered. From here, we highly recommend the
Intermediate Level I course to learn about relational databases, forms
and reports.
Detailed List of Topics
|
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
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
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
Design & Form
Views
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
|
|
