Access 2010 Advanced

Printable, customizable, training materials

Your participants will learn how to use the advanced features of Access 2010. This workshop is designed to teach you a basic understanding of Access 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL, and publish a Web database—among other things. By the time your participants finish this course, they will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!
Access 2010 Advanced


  • Unlimited Users
  • Unlimited Printing Rights
  • Completely Customizable

Just a few of our satisfied customers. View all clients.

Polaroid America's Navy Hertz Tupperware

“These materials are a life saver...”

Read testimonials.

Everything you need to teach a one-day workshop for Access 2010 Advanced:

  • Training Manuals
  • PowerPoint Slides
  • Instructor's Guide
  • Quick Reference Job Aids
  • Icebreakers, Activities,
     & Exercise Files
  • Pre-Assignments,
  • Promotional Advertorials
  • Lesson Plans with Flip Chart Notes

Also available: training video clips, editable books, audiobook workshops, e-learning, and cloud-based LMS.

Access 2010 Advanced Course Outline:

Module One: Getting Started
  • Icebreaker
  • Housekeeping Items
  • The Parking Lot
  • Workshop Objectives

Module Two: Advanced Table Tasks
  • Using the Quick Start Group
  • Using the Property Sheet
  • Adding, Moving and Removing Controls
  • Formatting Controls
  • Setting the Primary Key
  • Using Table Macros

Module Three: Advanced Form Tasks
  • Creating a Sub Form
  • Creating a Web Form
  • Creating a Split Form
  • Creating a Modal Dialog

Module Four: Advanced Reporting Tasks
  • Using Report Sections
  • Using Conditional Formatting
  • Grouping & Sorting Data
  • Adding Calculated Controls
  • Creating Labels

Module Five: Understanding Relationships
  • Types of Relationships
  • Viewing Relationships
  • Editing Relationships
  • About Referential Integrity
  • Establishing Referential Integrity

Module Six: Advanced Query Tasks
  • Sorting and Filtering a Query
  • Adding Calculated Fields
  • Using the Expression Builder
  • Module Seven: Working with SQL
  • What is SQL?
  • Basic SQL Syntax

Module Eight: Linking Data
  • Linking to an Excel Spreadsheet
  • Linking to an Access Database
  • Linking to a SharePoint List

Module Nine: Importing Data
  • Importing From an Excel Spreadsheet
  • Importing From an Access Database
  • Importing from a SharePoint List

Module Ten: Exporting Data
  • Saving an Object as a PDF
  • Exporting To an Excel Spreadsheet
  • Exporting to a SharePoint List

Module Eleven: Advanced Database Tools
  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database

Module Twelve: Wrapping Up
  • Words from the Wise
  • Review of Parking Lot
  • Lessons Learned
  • Completion of Action Plans and Evaluations

Try a FREE sample and see the value for yourself!

Administrative Skills

Career Development

Human Resources

Personal Development

Sales And Marketing

Supervisors And Managers

Workplace Essentials

Office 2016

Office 2013

Office 365

Office 2010

Office 2007