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

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

 

  

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