Access
Intermediate Level 1

3 Days (9am to 4pm)
$ 825. or 3
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.)

 

 

 

 

 

 

Almost all databases use multiple relational tables, and this course teaches you why and how to work with them. Building on the base of the Introduction course, you will create your own small relational database. Once that’s done you’ll move on to making reports based on it, in particular learning how to join together information from multiple tables into single sources of data, including data that is outside the database in Excel. You’ll also learn how on-screen forms and print-outs are affected by having two or more tables in play at the same time, as well as sophisticated form tools like drop-down boxes.

Course Prerequisite: Solid understanding of all Access Introduction topics.

 

Creating Forms

Creating a Form

      Using the Wizard

      Creating a Form from Scratch

      Add Text

      Add Fields & Formulas

      Add a Picture/Drawing

      What are Controls?

      Select Boxes

      Move and Size Controls

      Align Controls and the Different Views

      Basic Formatting

      Using the Colour Icons

      Spacing Between Objects

      Delete Objects

      Cut, Copy, Paste

      Copy Formats

      Bring to Front/Send to Back

      The Toolbox

      Tab Order

      Print

      Forms Based on Multiple Tables

Control Properties

      Name

      Control Source

      Default Value

      Validation Rule, Validation Text

      Format, Decimal Places

      Custom Date Formats

      Input Mask

      Status Bar Text & Control Tip

      Enabled & Locked

      Tab Stop

 

Combo Boxes

      Type 1 - You Type a List of Choices

      Type 2 - Display Data from a Table

Type 3 - Display from Master Table, Store in Related Table (Linked) Working with Bands/Form

      Change the Background Colour

      Rulers/Grid

      Form Properties

Command Buttons

      Creating with the Wizard

Subforms

      Add to Main Form

      About Child Fields and Master Fields

      Edit a Subform from within Main Form

     

Relating Tables

Why Relate Tables?

How to Relate Tables

Referential Integrity

Cascade Update/Delete

Testing the Relationship

Edit and Delete Relationships

Primary Keys and Unique Indexing

See Related Data in a Table

 

 

Creating Reports

All Applicable Forms Topics, plus:

      Wizards, Creating a Blank Report

      Print Preview vs. Layout Preview

      Page Setup

      Report Bands & Band Properties

      Sorting and Grouping

      Calculations in a Report             

      Envelopes

      Label Wizard

 

Import, Export, & Link

Importing and Linking Tables

Exporting Tables or Queries

Word Merge

Versions Toronto North York Mississauga Newmarket

2007/2010

 

 

Apr 10/11/12

Feb 21/22/23

 

 

  

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