Access 365 Classes

Access 365 Classes

Sign In IconSign in to register for classes.

Click the series titles below to display course outlines and sign up for classes.

Access 101: Database Overview

Through both lecture and hands on, this overview introduces you to:

  • Basic database terminology
  • Components that make up Microsoft Access
  • Tables, queries, forms, and reports

Access 101 Course Dates & Times

Check the class date/time that you want to attend.

Wed Apr 22, 202009:30 am to 10:30 am
Mon Jul 13, 202001:00 pm to 02:00 pm

Access 102: Creating Tables

In this hour, you'll learn:

  • Several ways to create a table in Microsoft Access
  • Different types of fields and field properties
  • Distinctions between Datasheet View and Design View

Access 102 Course Dates & Times

Check the class date/time that you want to attend.

Wed Apr 29, 202009:30 am to 10:30 am
Mon Jul 20, 202001:00 pm to 02:00 pm

Access 103: Data Entry Tips and Tricks

This course has a lot of different data entry tips and tricks to teach you. You'll also learn how to:

  • Format a datasheet
  • Export that data into Microsoft Excel or Microsoft Word

Access 103 Course Dates & Times

Check the class date/time that you want to attend.

Wed May 6, 202009:30 am to 10:30 am
Mon Jul 27, 202001:00 pm to 02:00 pm

Access 104: Create Tables for a Contacts Database

During this hour, you'll be creating a Contact Management database. You'll be:

  • Walking through the process of creating the necessary tables
  • Creating tables that track contact information, phone numbers, and email
  • Designing tables that let you to store files related to the contact and keep chronological notes

Access 104 Course Dates & Times

Check the class date/time that you want to attend.

Wed May 13, 202009:30 am to 10:30 am
Mon Aug 3, 202001:00 pm to 02:00 pm

Access 105: Create Tables for a Customer Database

Spend this hour discovering how to:

  • Construct the tables necessary to create a Customer database
  • Create tables to track customer information, products, and order details
You'll be able to apply the concepts covered in this class to most database table designs.

Access 105 Course Dates & Times

Check the class date/time that you want to attend.

Wed May 20, 202009:30 am to 10:30 am
Mon Aug 10, 202001:00 pm to 02:00 pm

Access 201: Importing Data Tips and Tricks

This course teaches you how to:

  • Import data into Access
  • Export data to other programs such as Excel and Word
  • Clean up data in an Excel workbook prior to importing it into Access

Access 201 Course Dates & Times

Check the class date/time that you want to attend.

Wed May 27, 202009:30 am to 10:30 am
Mon Aug 17, 202001:00 pm to 02:00 pm

Access 202: Filters and Sorts

Learn tips and tricks for:

  • Applying filters and sorting data
  • Using these features in the Datasheet mode, Form View, and Report View

Access 202 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jun 3, 202009:30 am to 10:30 am
Mon Aug 24, 202001:00 pm to 02:00 pm

Access 203: Introduction to Queries

This course teaches you the basics for creating queries. You'll learn how to:

  • Link tables
  • Write custom formulas
  • Concatenate data
You'll also learn how to use the Query Wizard to create a query that finds duplicate or unmatched data.

Access 203 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jun 10, 202009:30 am to 10:30 am
Mon Aug 31, 202001:00 pm to 02:00 pm

Access 204: Action Queries

Learn how to use the Action queries:

  • Make Table
  • Append
  • Update
  • Delete
Also explore the difference between using the Datasheet View button and the Run button.

Access 204 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jun 17, 202009:30 am to 10:30 am
Mon Sep 14, 202001:00 pm to 02:00 pm

Access 205: Advanced Queries

Explore advanced queries using:

  • Calculations
  • IIF function and IsNull function
  • Concatenation to combine text within your queries

Access 205 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jun 24, 202009:30 am to 10:30 am
Mon Sep 21, 202001:00 pm to 02:00 pm

Access 206: Table Relationships

This course teaches you about table relationships and referential integrity. You'll learn about:

  • Table normalization
  • Defining relationships between tables
  • Primary Key
  • Applying referential integrity
  • The pros and cons of using referential integrity

Access 206 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 1, 202009:30 am to 10:30 am
Mon Sep 28, 202001:00 pm to 02:00 pm

Access 207: SQL Queries Part 1

In this segment, you'll be introduced to Structured Query Language (SQL).  You'll be:

  • Examining the structure of SQL queries
  • Learning how to view Access Queries, also known as Query By Example (QBE) as SQL queries
SQL is used by most database programs and Access is no exception.

Access 207 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 8, 202009:30 am to 10:30 am
Mon Oct 5, 202001:00 pm to 02:00 pm

Access 208: SQL Queries Part 2

In SQL Queries Part 2, you'll learn how to:

  • Recognize and edit SQL queries that are used as Record Sources for forms and reports
  • Write SQL for Action Queries

Access 208 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 15, 202009:30 am to 10:30 am
Mon Oct 19, 202001:00 pm to 02:00 pm

Access 301: Forms Overview

This is an overview of the types of forms you can create using Microsoft Access. You'll be introduced to:

  • Forms Ribbon
  • Forms Wizard
  • Different types of forms you can create
 You'll learn the pros and cons of each method.

Access 301 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 22, 202009:30 am to 10:30 am
Mon Oct 26, 202001:00 pm to 02:00 pm

Access 302: Form Layout View Part 1

This course illustrates the basics of working with forms in the Layout View. You'll learn about:

  • Forms are automatically created in the Layout view
  • Design and Arrange Ribbons
  • How to make simple editing and format changes

Access 302 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 29, 202009:30 am to 10:30 am
Mon Nov 2, 202001:00 pm to 02:00 pm

Access 303: Form Layout View Part 2

In Part 2 of Form Layout View, you'll discover:

  • Advanced ways to work with, edit, and modify Layout forms
  • How to use the Navigation Form to organize multiple forms within your database

Access 303 Course Dates & Times

Check the class date/time that you want to attend.

Wed Aug 5, 202009:30 am to 10:30 am
Mon Nov 9, 202001:00 pm to 02:00 pm

Access 304: Form Design View Part 1

In Form Design View Part 1, you'll learn how to:

  • Create a form from scratch using the Design View
  • Add fields and labels to your form
  • Use the Design, Arrange, and Format Ribbons

Access 304 Course Dates & Times

Check the class date/time that you want to attend.

Wed Aug 12, 202009:30 am to 10:30 am
Mon Nov 16, 202001:00 pm to 02:00 pm

Access 305: Form Design View Part 2

This hour continues with Form Design View. You'll find out how you can:

  • Add additional objects to a form such as Combo boxes, List boxes, Check boxes, and Option buttons (Radio buttons)
  • Use the Controls Wizard to create Combo boxes and Command buttons

Access 305 Course Dates & Times

Check the class date/time that you want to attend.

Wed Aug 19, 202009:30 am to 10:30 am
Mon Nov 23, 202001:00 pm to 02:00 pm

Access 306: Form Design View Part 3

During this segment of Form Design View, we'll show you how to:

  • Create a main form and sub forms
  • Use queries and Text boxes to add formulas to your form
  • Add a Tab Control to the form

Access 306 Course Dates & Times

Check the class date/time that you want to attend.

Wed Aug 26, 202009:30 am to 10:30 am
Mon Nov 30, 202001:00 pm to 02:00 pm

Access 307: Form Design View Part 4

Wrapping up Form Design View, in this hour you'll learn about advanced features found in the Property Sheet:

  • Record Source
  • Default View
  • Data Entry
  • Allow Additions,  Allow Deletions, Allow Edits
  • Options for the Detail Section, Text Boxes, Labels, and Buttons

Access 307 Course Dates & Times

Check the class date/time that you want to attend.

Wed Sep 2, 202009:30 am to 10:30 am
Mon Dec 7, 202001:00 pm to 02:00 pm

Access 308: Create Forms for a Contacts Database

During this course, you'll create a:

  • Form for an individual contact that contains subforms displaying the contact's phone numbers and email addresses
  • List of contacts
  • Data entry form to add new contacts
The tables used in this class are the same tables that were created in Access 104: Create Tables for a Contacts Database.

Access 308 Course Dates & Times

Check the class date/time that you want to attend.

Wed Sep 9, 202009:30 am to 10:30 am
Mon Dec 14, 202001:00 pm to 02:00 pm

Access 309: Create Forms for a Customer Database

During this hour, you'll be designing forms for a Customer database. You'll create:

  • A customer form that displays all the orders placed by the customer
  • An order form that allows the user to enter a new order for an existing customer
The tables used in this class are the same tables that were created in Access 105: Create Tables for a Customer Database.

Access 309 Course Dates & Times

Check the class date/time that you want to attend.

Wed Sep 16, 202009:30 am to 10:30 am
Mon Dec 21, 202001:00 pm to 02:00 pm

Access 401: Adding Buttons to a Form

This course introduces you to the Controls Wizard. It demonstrates how to use it to add commonly used buttons to a form. You'll learn how to:

  • Add navigation buttons
  • Include a button to close a form
  • Create a Main Menu form that contains buttons to open several different forms
  • Display the Main Menu form when you open the database

Access 401 Course Dates & Times

Check the class date/time that you want to attend.

Wed Sep 23, 202009:30 am to 10:30 am
Mon Jan 11, 202101:00 pm to 02:00 pm

Access 402: Editing Macros

This hour demonstrates how to edit macros you've created using the Control Wizard. It introduces you to the Macro Editor program within Microsoft Access.

You'll learn how to add folders containing Access database to the Access Trust Center so that when you open a trusted database you will no longer see the prompt asking you if the database is trusted.

Access 402 Course Dates & Times

Check the class date/time that you want to attend.

Wed Sep 30, 202009:30 am to 10:30 am
Mon Jan 25, 202101:00 pm to 02:00 pm

Access 403: Use the Controls Wizard to Automate Forms

This course uses the techniques learned in the Access 401 and 402 classes to make a database more user-friendly. You'll use the Controls Wizard to add buttons to automate the use of the database by:

  • Improving navigation within forms
  • Opening and closing forms
  • Printing out form data

Access 403 Course Dates & Times

Check the class date/time that you want to attend.

Wed Oct 7, 202009:30 am to 10:30 am
Mon Feb 1, 202101:00 pm to 02:00 pm

Access 501: Report Layout View Part 1

Part 1 of Report Layout View demonstrates report options. You'll see how to access the Report Options on the Create Ribbon and use:

  • Report to tabular reports automatically
  • Report Design to create reports from scratch
  • Blank Report not based on any table or query
  • Report Wizard to help you build your report

Access 501 Course Dates & Times

Check the class date/time that you want to attend.

Wed Oct 14, 202009:30 am to 10:30 am
Mon Feb 8, 202101:00 pm to 02:00 pm

Access 502: Report Layout View Part 2

In Part 2 of Report Layout View, you'll learn additional formatting commands that allow you to customize the look of your reports created using the Layout View.

Access 502 Course Dates & Times

Check the class date/time that you want to attend.

Wed Oct 21, 202009:30 am to 10:30 am
Mon Feb 22, 202101:00 pm to 02:00 pm

Access 503: Report Design View Part 1

This segment of Report Design View shows you how to add fields, groups, and sorts to a report.

Access 503 Course Dates & Times

Check the class date/time that you want to attend.

Wed Oct 28, 202009:30 am to 10:30 am
Mon Mar 1, 202101:00 pm to 02:00 pm

Access 504: Report Design View Part 2

This hour of Report Design View shows you how to:

  • Create detailed and summary reports
  • Add calculated fields in group headers and footers
  • Add calculated fields in report headers and footers
You'll also learn why you cannot add calculated fields to page headers or footers.

Access 504 Course Dates & Times

Check the class date/time that you want to attend.

Wed Nov 4, 202009:30 am to 10:30 am
Mon Mar 8, 202101:00 pm to 02:00 pm

Access 505: Report Design View Part 3

This course shows you several of the Report Properties, allowing you additional ways to format reports such as:

  • Keeping data together on a page
  • Forcing a new page based on a field change
  • Using the Build command to add commonly used fields to report headers and footers
You'll learn how to allow specific fields to grow or shrink based on the data contained in the fields.

Access 505 Course Dates & Times

Check the class date/time that you want to attend.

Wed Nov 18, 202009:30 am to 10:30 am
Mon Mar 15, 202101:00 pm to 02:00 pm

Access 506: Report Design View Part 4

In Report Design View Part 4, you'll see how you can create a Main report that contains sub-report(s).

You'll learn how to display subtotals and totals within these reports.

Access 506 Course Dates & Times

Check the class date/time that you want to attend.

Wed Dec 2, 202009:30 am to 10:30 am
Mon Mar 22, 202101:00 pm to 02:00 pm