Access 2013 Expert

Printable, customizable, training materials

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed to for the advanced users of Access 2013. 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 Expert 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 develop a deep understanding 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 Expert

$499 

  • 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 Expert:

  • Training Manuals
 
  • PowerPoint Slides
  • Instructor's Guide
 
  • Quick Reference Job Aids
  • Icebreakers, Activities,
     & Exercise Files
 
  • Pre-Assignments,
    Pre-/Post-Assessments
  • 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 Expert Course Outline:

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


Module Two: Customizing Apps (I)
  • Creating a Custom App from Scratch
  • Adding a Template Table Adding a Blank Table
  • Importing Access 2010 Tables
  • Module Two: Review Questions


Module Three: Customizing Apps (II)
  • About Custom Actions
  • Adding a Custom Actin
  • Editing a Custom Action
  • Deleting a Custom Action
  • Module Three: Review Questions


Module Four: Customizing Apps (III)
  • About User Interface Macros
  • Creating an Embedded Macro
  • Creating a Standalone macro
  • Saving Your App as a Package
  • Module Four: Review Questions


Module Five: Working with Validation Rules and Messages
  • Creating a Field Validation Rule
  • Creating a Field Validation Message
  • Creating a Validation Rule
  • Creating a Validation Message
  • Testing Validation Rules
  • Module Five: Review Questions


Module Six: Working with Macros
  • Creating a Before Change Event
  • Working with the Macro Tools Design Tab
  • Working with the Action Catalog
  • Creating an After Event
  • Creating a Named Macro
  • Renaming or Deleting Macros
  • Module Six: Review Questions


Module Seven: Advanced Query Tasks
  • Using Query Design View
  • Creating Ad Hoc Relationships
  • Creating an Update Query
  • Creating a Parameter Query
  • Comparing Two Tables by Using a Join
  • Module Seven: Review Questions


Module Eight: Designing Forms
  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms
  • Module Eight: Review Questions


Module Nine: Advanced Reporting Tasks
  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels
  • Module Nine: Review questions


Module Ten: Advanced Database Tools
  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database
  • Module Ten: Review Questions


Module Eleven: Working with the Access Environment
  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options
  • Module Eleven: Review Questions


Module Twelve: Wrapping Up
  • Words from the Wise
  • Review of Parking Lot

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