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 $ 345. to $ 645. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

North York

Mississauga

Newmarket

Version 2003

Jul 16/17/18

Apr 16/17/18

Aug 18/19/20

May 12/13/14

Sep 22/23/24

Version 2007

Apr 21/22/23

Aug 13/14/15

 

 

 

Course Prerequisites

 

Required: Solid understanding of all Access Introduction topics.

 

Course Description

This three-day course takes an in-depth look at three topics: relating tables, creating forms and creating reports.   We'll show you how to determine when you need to use more than one table, and how to relate them, then we’ll look at how to create queries, forms and reports that are based on related tables.  (Form & Report topics: with and without the wizard, using tools, setting formats, setting control properties, sub-forms, grouping reports and more.)

Detailed List of Topics

 

Create an Employee Form without the Wizard

Add Controls

Move Controls

View Records

Select & Align

Fonts & Size

Size Controls

Save Form

Undo Changes

Change Label Text

Text Alignment

 

Control Properties

      Format

      Status Bar Text

      Control Tip Text

      Validation Rule

      Input Mask

Adding Text Labels

Adding Formulas

Creating Combo Boxes

Form Header / Footer

Adding Command Buttons

Form Properties

Lines & Rectangles

Tab Control

Using a Form

Sorting Records

 

Customers & Contacts

Creating a Contacts Table

Viewing the Customer Table

Creating an Append Query

Setting a Primary Key

Relating Two Tables

Referential Integrity

Cascade Update/Delete

Testing the Relationship

Creating a Contacts Sub Form

Creating a Customer Main Form

Adding a Sub Form to a Main Form

Testing the Completed Form

 

Entering / Viewing Sales Orders

Determining the Tables Needed

Adding Primary Keys to Tables

Creating Additional Tables

Relating the Tables

Creating a Sub Form for Orders

Creating a Main Form for Orders

Adding a Sub Form to a Main Form

Setting a Form Record Source

More Complex Combo Boxes

Form Header / Footer

 

Customers By Province Report

without the Wizard

Report Bands

Set Sorting & Grouping

Adding Fields

Aligning Controls

Counting Customers

Adding Lines

Changing Fonts

Page Setup (margins,etc.)

 

Sales by Customers Report

without the Wizard

Basing a Report on Multiple Tables

Sorting & Grouping

Adding Fields

Format & Align

Creating Formulas

Adding Lines

Formatting Controls

Changing Fonts

Changing Alignment

 

Creating Envelopes

Adding Fields

Setting the Paper Size

Setting Orientation

Setting Margins

Adding Fields

Merging Fields

Omitting Blanks

Adding Page Breaks

 

Creating Labels
Using the Wizard

Choosing Label type

Viewing Wizard Settings

Making Changes

 

Merging with Word

Sending Customer Data to Word

Creating a Word Main Document

Merging the Document

 

Import & Export
Import an Excel File

Link to an Excel File

Export a Table/Query to Excel

 

 

  

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