Access 2013 Advanced

Printable, customizable, training materials

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. The participants will learn how to use the advance features of Access to help them better manage a database. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Advanced functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to learn the advanced features of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.
Access 2013 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 2013 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 2013 Advanced Course Outline:

Module One: Getting Started
  • Housekeeping items
  • Pre-Assignment Review
  • Parking Lot
  • Workshop Objectives
  • Action Plans

Module Two: Using App Views
  • Understanding Views
  • Adding a New View
  • Editing a View
  • Deleting a View
  • Adding a Popup View
  • Module Two: Review Questions

Module Three: Customizing Apps (I)
  • Checking Your Database Name or Server Location
  • Modifying the Action Bar
  • Opening a Table for Editing
  • Moving, Resizing, or Deleting Controls
  • Module Three: Review Questions

Module Four: Customizing Apps (II)
  • Adding Controls from the Ribbon
  • Adding Controls from the Field List
  • Changing Control Properties
  • Module Four: Review Questions

Module Five: Advanced Record Tasks
  • Showing Totals
  • Adding from Outlook
  • Saving a Record as an Outlook Contact
  • Adjust Row Height
  • Hiding and Un-hiding Fields
  • Freezing and Unfreezing Fields
  • Formatting Text
  • Module Five: Review Questions

Module Six: Adding Other Types of Fields
  • Adding Rich Text and Long Text Fields
  • Adding Attachment Fields
  • Adding Hyperlink Fields
  • Adding Lookup & Relationship Fields
  • Adding Calculated Fields
  • Module Six: Review Questions

Module Seven: Advanced Field Tasks
  • Adjusting the Field Size/Width
  • Setting Field Default Value
  • Working with More Fields
  • Working with Field Validation Options
  • Using the Field List
  • Module Seven: Review Questions

Module Eight: Working in Table Design View
  • Opening Design View
  • Working with Field Properties
  • Setting the Primary Key
  • Using the Properties Sheet
  • Working with Table Properties
  • Viewing Table Relationships
  • Using Relationship Tools
  • Viewing Object Dependencies
  • Module Eight: Review Questions

Module Nine: Working with External Data
  • Linking Data
  • Importing Data
  • Using the Table Analyzer
  • Refreshing Data
  • Exporting Data
  • Module Nine: Review Questions

Module Ten: Creating Queries
  • Creating a Select Query
  • Creating a Make Table Query
  • Creating an Append Query
  • Creating a Cross tab Query
  • Showing and Removing Tables
  • Module Ten: Review Questions

Module Eleven: Creating Forms and Reports
  • Creating a Form with the Form Wizard
  • Creating a Report with the Report Wizard
  • Modifying Form Layout
  • Navigating the Field List
  • Key Features on the Form Tools Tabs
  • Key Features on the Report Tools Tabs
  • Module Eleven: Review Questions

Module Twelve: Wrapping Up
  • Words from the Wise
  • Parking Lot
  • 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