How much does Microsoft Access Level 1 cost?

$650 per seat. That covers courseware and lab access. Exam vouchers are quoted separately. Volume pricing is available for teams, and a private cohort is usually cheaper per seat past about four people.

How long is Microsoft Access Level 1?

2 days of instructor-led training, delivered live online. Classes run during business hours in the timezone shown on each date.

When is the next Microsoft Access Level 1 class?

The next scheduled date is Nov 30 to Dec 1. There is 1 upcoming date in total, 1 of which is guaranteed to run regardless of enrollment.

Is Microsoft Access Level 1 delivered online?

Yes. It runs live online with an instructor, not as a recording, so you can ask questions as you go. It can also be delivered privately at your site.

Can a government agency buy Microsoft Access Level 1?

Yes. Purchase orders and government purchase cards are both accepted at checkout, and quotes can be formatted for a solicitation response. Terms are net 30 on invoiced orders.

What happens if I need to cancel Microsoft Access Level 1?

Course fees are fully refundable with written notice at least ten business days before the class. Inside that window the fee is forfeited, though one free retake is available within six months of the class date.

ACC-01 Microsoft Access Level 1 | 2-day class

Upcoming dates

All times shown in the class's own timezone. 1 of 1 are guaranteed to run, meaning they go ahead regardless of enrollment.

Dates	Starts	Where	Status	Seat	Book
Nov 30 to Dec 1	9:00 AM to 4:00 PM PST Taught by us	Live virtual	GUARANTEED	$650

About this class

We have 1 scheduled date of Microsoft Access Level 1, starting Nov 30 to Dec 1. It is guaranteed to run regardless of enrollment. We teach this one ourselves, with our own instructors and courseware. Seats are $650 each over 2 days, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

In this course, you will learn how to use to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. Features and functions in Office 365 and Office 2019 / 2016 / 2013 are nearly identical. For this reason, users for all versions (365, 2019, 2016 and 2013) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.

What you'll be able to do

Design and Build a Database
Import Data into Access
Design Tables
Create Table Relationships
Create forms
Design forms
Create queries
Design reports

Course outline

Module 1 What Is A Relational Database

What is a database
What makes data a database and not a spreadsheet
What makes a relational database “relational”?
What are the parts of a relational database

Module 2 Exploring Microsoft Access

Opening and viewing Microsoft Access
Touring the Access Window
Exploring the main parts of an Access database
Using the Access Help features
Using the navigation pane

Module 3 Planning a Relational Database

Planning a database
Identifying classes
Identifying class attributes
Identifying objects
Defining columns

Module 4 Splitting Information Into Tables

The first rule: Making sure every record is unique
Breaking columns down to their lowest forms
Another rule: Avoiding repeats of information
Another rule: Avoiding multiples of the same column
Another rule: Columns need to relate to a primary key
Keeping historical data

Module 5 Designing and Building a Database

Building a database from an existing template
Creating a database
Testing tables in a database

Module 6 Importing Data into Access

Importing Data from an Access Database
Importing Data from Excel

Module 7 Designing Database Tables

Creating table lookups
Using table field properties
Using input masks
Using validation rules
Changing field structure in tables

Module 8 Creating Table Relationships

Defining relationships between tables
Establishing relationships between tables
Using subdatasheets in tables

Module 9 Creating Forms

Creating a basic form
Creating a form with the form wizard
Creating a split form
Creating subforms

Module 10 Form Design

Enhancing the appearance of a form
Charging form layout
Using form properties
Adding command buttons to a form

Module 11 Creating Basic Queries

Creating as query with a wizard
Creating a query from scratch
Editing a query

Module 12 Creating Basic Reports

Creating a report from a table
Creating a report from a query
Examining report types
Documenting the database

Before you attend

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.