• 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

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

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

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.

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. 

LIVE Remote training classes can be taken anywhere using your own devices. This method provides the same hands-on experience you would get in the classroom, minus the commute.

Classroom training is taken at our facility in downtown Phoenix. We provide everything you need to take the class – including refreshments and technical assistance by onsite support staff. All you need to bring is yourself.

Instructors may or may not be present in the classroom.  A hands-on experience will be provided for each participant regardless of the location chosen.

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.

Refer to your confirmation email to see the start and end times for your class.

The actual class end time may vary from the scheduled end time due to 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.

LIVE Remote students may begin joining the virtual classroom 15 minutes prior to the scheduled start time.

Classroom participants are encouraged to arrive at our facility about 15 minutes before the scheduled start time.

Students that arrive late will be asked to reschedule.