Virtual Live Instructor
Free Training Manual
: Thie Microsoft Access 2016 Advanced course will expand upon the topics covered in the Access 2016 Introduction course, including teaching relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports. lease note: This class taught using the Access 2016 version and is for users of Access 2016, 2013 and 2010. There are very few differences between the versions, and the instructor will highlight any differences.
Upon completion of the course, users will be able to:
Section 1: Organizing a Database for Efficiency
Topic 1: Data Normalization
Topic 2: Creating a Junction Table
Topic 3: Improve Table Structure
Section 2: Joining Tables
Topic 1: Creating Query Joins
Topic 2: Relating Data Within a Table
Topic 3: Working with Subdatasheets
Section 3: Creating Advanced Queries in Access 2016
Topic 1: Creating Parameter Queries
Topic 2: Summarizing Data
Topic 3: Creating Subqueries
Topic 4: Creating Action Queries
Topic 5: Creating Unmatched and Duplicate Queries
Section 4: Using Advanced Reporting Techniques
Topic 1: Including Control Formatting in a Report
Topic 2: Adding a Calculated Field to a Report
Topic 3: Adding a Subreport to an Existing Report
Section 5: Implementing Advanced Form Design
Topic 1: Adding Controls to Forms
Topic 2: Enhancing Navigation and Organization of Forms
Topic 3: Applying Conditional Formatting
Section 6: Using Data Validation
Topic 1: Using Field Validation
Topic 2: Using Form and Record Validation
Section 7: Using Macros to Improve User Interface Design
Topic 1: Creating a Macro
Topic 2: Restricting Records Using a Condition
Topic 3: Validating Data Using a Macro
Topic 4: Automating Data Entry Using a Macro
Section 8: Managing Switchboards
Topic 1: Creating a Database Switchboard
Topic 2: Modify a Database Switchboard
Topic 3: Set Startup Options
Section 9: Using Advanced Database Management
Topic 1: Managing a Database
Topic 2: Determining Object Dependency
Topic 3: Documenting a Database
Please check the course description to find prerequisite information.
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Instructor led training is a cost effective and convenient learning platform for busy professionals. Most courses are available at over 300 locations nationwide and Online.
The classes are taught via the RCI method by professionally certified instructors, and are usually limited to 12 or less students. Each student receives a training manual and practice problems, along with a free course retake. Click here to learn more about Instructor Led Training
Below is a list of upcoming Access Instructor Led Class Dates:
We offer private Access group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Access Private Group Training from Business Computer Skills can help your team.