• Live Instruction

• Hands-on, Guided Activities

• LIVE Remote or Classroom Delivery

What’s Included

  • Small class sizes
  • A digital Access training manual
  • Certificate of course completion
  • FREE retake valid for 12 months
  • Virtual Lab (LIVE Remote)

Onsite Access training available countrywide.

MICROSOFT ACCESS COURSE OUTLINES

Excel Level 1 - Introduction

Our Access 1 class introduces you to the core concepts of simple databases and the Access application. Learn the ways data can be entered, find the information you need within it, and display it in professional reports that can be shared with others.

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
Querying a Database
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a query
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

"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."

Excel Level 2 - Introduction

Extend your knowledge of relational databases with our Access 2 course. See how data relationships are formed and learn how to optimize your database. Gain exposure to more advanced techniques to locate the data you want and build reports to display it.

Recommended Preparation: Access 1

1 Day $264 2 Tickets

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."

Excel Level 3 - Introduction

Build upon the skills you have attained through Access 1 and 2 to use the most advanced features of the Access application. Learn the skills you need to manage your database, increase your productivity by automating common processes, and securely make the information in your database available to other applications and colleagues who lack your level of database knowledge.

Recommended Preparation: Access 1 & 2

1 Day $264 2 Tickets

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 any three classes and receive 20% off.

The Training to YOU Three Class Discount is a terrific way for an individual to purchase multiple classes for a discount. Whether you are looking for a series of classes like Excel 1, 2 & 3 or a variety of classes such as Google Sheets, Docs and Slides the Three Class Discount is the way to go!

State of Arizona employees are eligible for an additional discount.

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 online and in-person Access training classes. Find answers to some of our most frequently questions related to Access training below, or contact us should you require further assistance.

Our Access training classes are all face-to-face, whether you come to our facility or take the class remotely through our virtual meeting and lab.  Our trainers are subject matter experts and passionate about teaching, ensuring that you will have a great learning experience. 

LIVE Remote classes start the set-up process at 8:00 a.m. 

In-person classroom participants should arrive no by 8:15 a.m. 

Students that arrive late will be asked to reschedule. 

Instruction begins at 8:30 a.m. for both classroom and LIVE Remote delivery. 

Classes are scheduled to end at 4:30 p.m. but this may vary depending on class size and student skill level.  

All times are in MST for Phoenix, AZ where Daylight Savings Time is not observed. 

See the local time in Phoenix here for clarification. 

You will need: 

  • A stable, high-speed internet connection (wired is recommended over Wi-Fi whenever available) 
  • A PC or laptop with mouse and keyboard 
  • A second monitor (preferred) or device (screen size should be large enough to view instructor’s share) 
  • Speakers or headphones are a must and a microphone is recommended.  

Click here for full setup instructions, including links to test your system and network.  

If you do not have the resources above, consider taking your class in-person at our training center and we will provide everything you need. 

This depends on your current level of experience. Most will benefit from starting at the beginning with Access 1 which is the perfect introduction to the core concepts, terminology and navigation of the application. Before you decide to start with a course later in the series, we recommend reviewing the full list of topics covered by downloading the PDF outline for that course below the course description. 

Our instructors can travel anywhere in the United States to deliver training. Contact registration for a quote at registration@trainingtoyou.com