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)
 

 

Pay $ 230. to $ 430. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

Toronto

North York

Mississauga

Newmarket

Version 2003

Oct 21/22

Sep 7/8

Jan 26/27

 

Nov 1/2

Version 2007/2010 *

Jan 6/7

Nov 29/30

Sep 13/14 (2007 only)

Oct 25/26

Oct 12/13

* Version 2010 available for all course dates after Oct 1/10.

 

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

Working with Attachments (version 2007 only)

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 (version 2007 only)

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 (version 2007 only)

Design & Form Views

Layout View (version 2007 only)

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

 

  

Computer Training Courses / SoftSkills Seminars  / Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416.494.4912, Fax: 416.494.9952

www.Computer-Help.ca

Question or Comment - Email Us