What’s Included

  • Small class sizes
  • A digital Access training manual
  • Certificate of course completion
  • FREE retake valid for 12 months

How to book an online class?
Onsite Access training available countrywide.

MICROSOFT ACCESS COURSE OUTLINES

Excel Level 1 - Introduction

This course is designed to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms, and reports, and create queries.

1 Day $264 2 Tickets

Detailed Course Outline

Getting Started with Access
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access
Working with Table Data
  • Modify Table Data
  • Sort and Filter Records
Using Forms
  • Create Basic Access Forms
  • Work with Data on Access Forms
Generating Reports
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports
Querying a Database
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a query

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Detailed Course Outline

Designing a Relational Database
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
Joining Tables
  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets
  • Subdatasheets
  • Subdatasheet Detection
Using Data Validation
  • Use Field Validation
  • Use Form and Record Validation
Creating Advanced Queries
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
Organizing a Database for Efficiency
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
Using Advanced Reporting Techniques
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Detailed Course Outline

Implementing Advanced Form Design
  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting
Sharing Data Across Applications
  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge
Using Macros to Improve User Interface Design
  • Create a Macro
  • Restrict Records by Using a Condition
  • Validate Data by Using a Macro
  • Automate Data Entry by Using a Macro
Using VBA
  • Getting Started with VBA
  • Enhance Access by Using VBA
Using Advanced Database Management
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
Distributing and Securing a Database
  • Splitting a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
Managing Switchboards
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Start-up Options

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Three Class Discount

Buy three classes and receive up to 20% off. State employees are eligible for additional discounts.

Training Bundles offer our best, most cost-effective method for Microsoft Office, Google applications, graphic, and specialty classes. Give your valued employees a deep dive into the skills your organization needs today with a Training Bundle!

Training to YOU Tickets

Tickets are a great way to reduce the cost of training your team. Save up to 45% by purchasing your training in bulk.

We are now providing a custom-made registration portal for each organization that purchases 50+ training tickets. These portals allow supervisors and employees to schedule training easily and information workflows keep everyone in the loop.

Give us a call

We are happy to answer any questions you may have.

Call us

(602) 266-1500

TRAINING TO YOU


Class Ratings
4.9 stars from 1984 reviewers:

“Instructor is very patient and helpful. Takes time to help student catch up if lagged a little behind. Plan to take Access Level 3 later. Training to You has always been  great.  Have taken classes in the past few years.”

— J.P. took Access 2 Database Design, Advanced Input and Retrieval

“My Instructor was great. He was knowledgeable and attentive throughout the course. He presented lofty concepts in a manner that was easy to understand and apply in real life. I look forward to my next course! ”

— C.K. took Access 1: Data Structure and Input and Retrieval

“We appreciate Training to You providing the training on site at our office. This was an excellent training for us to train the majority of our team. Thank you to our instructor for his patience and willingness to assist us with our questions.”

— K.P. took Access 2 Database Design, Advanced Input and Retrieval

ACCESS TRAINING FAQ

Training to YOU is dedicated to providing the best in-person and online Access training classes in Phoenix. Please find answers to some of our most frequently asked Access training related questions below, or contact us should you require further assistance.

Our Access training classes are all face-to-face, in other words, our instructors are present in the training lab. Our trainers are Access experts and passionate about teaching, ensuring that you will have a great learning experience.

Our MS Access LIVE Remote classes start at 8:00am and finish at 4.30pm. In-person classroom classes start at 8:30am and finish at 4:30pm. We take a lunch hour around 12:00pm.

No, we provide the computers at our training center in downtown Phoenix.

This depends on your current level of experience. If you’re learning from scratch then our Access 1 is the perfect introduction to the core concepts. Alternatively, you may consider either our Access 2 or Access 3 if you have prior experience with the software.

Yes, we service the Phoenix metro.

Our trainers can also travel anywhere in the country to deliver Access training classes. Obtain a quotation for onsite Access training here.