Great Canadian Training Company color logo

Microsoft Access Level 1 (Basic)

Microsoft Access Level 1 (Basic)

(2013, 2016, 2019, 2021, 365)

Course Length:

12 hours (2 days)

Learning Objectives

By the end of this 2-day course, you will be comfortable with navigating the Access interface, creating a new database from scratch, querying a database, performing calculations, generating reports, sharing data, and much more. You will:


  • Learn the Access interface
  • Create an Access database
  • Work with tables and records
  • Sort and filter records and create lookups
  • Query a database and perform calculations in a query
  • Create parameter queries and action queries
  • Generate reports and add controls
  • Design a relational database
  • Organize report information, format reports, and include charts and calculated fields
  • Import and export data to other applications

Target Student

All computer users who would like to get up to speed quickly and become familiar with using Access to create and query a database, perform calculations, organize information, generate reports, and share data with others effectively.

Course Outline

Section 1: Getting Started with Access

What is a Database?

Opening a Database

Tables

Queries

Forms

Reports

Review the Ribbon Interface

 

Section 2: Designing a Relational Database

Relational Database Design Process

Relationship Guidelines

Fields and Tables

Primary Keys, Foreign Keys, and Composite Keys

Table Relationships

Relationship Types

Rules of Normalization

 

Section 3: Working with Tables and Records

Navigate through Records

Add New Records

Sort and Filter Data

Datasheet Totals

Subdatasheets

Print Records

 

Section 4: Creating Tables

Table Creation Options

Table Views

Data Types

Insert Fields

Move, Edit, and Delete Fields

Table Properties

Field Size

Field Captions

Default Values

Input Masks

The Lookup Wizard

Renaming a Table

 

Section 5: Creating Table Relationships

The Relationships Window

Referential Integrity

Edit Relationships

Join Lines

Relationships Report

 

Section 6: Creating Queries

Simple Query Wizard

Create a Query from Scratch

Types of Queries

Query Views

Save, Rename, and Delete Queries

Sort Queries

Multi-table Queries

Query Criteria

Comparison Operators

Logical Operators

Wildcards

Formatting Query Fields

 

Section 7: Creating Advanced Queries

Parameter Queries

Wildcards in a Parameter Query

Query Joins

Group Query Results

Add Calculated Fields

Arithmetic Operators

Subqueries

Find Duplicates Query Wizard

Find Unmatched Query Wizard

Crosstab Queries

 

Section 8: Creating Forms

Forms Wizard

Form Views

Form Sections

Add Controls to Forms

Form Design Tools

Field List Pane

 

Section 9: Creating Reports

Report Wizard

Report Views

Report Sections

Add Controls to Reports

Report Design Tools

Group and Sort Reports

Add Background Images to Reports

Format Reports

Include Charts in a Report

Add a Calculated Field to a Report

Add a Subreport to an Existing Report

Add Headers and Footers

 

Section 10: Sharing Data Across Applications

Import Data into Access

Export Data to Excel

Create a Mail Merge

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Access Level 1 (Basic)

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
June 12-13, 2024
9:00 AM to 4:00 PM ET
$750.00 Online
September 17-18, 2024
9:00 AM to 4:00 PM ET
$750.00 Online
January 14-15, 2025
9:00 AM to 4:00 PM ET
$750.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training


Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices


Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!


Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference


Can I customize my course?
OF COURSE!

Tailored Training

Your Reference Guide will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

You can include your own files in your training session to make it more applicable to your day-to-day role.