Access 2007 Advanced

Printable, customizable, training materials

This workshop is designed to teach you a deeper understanding of Access 2007 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 2007 Advanced functions without worrying about making mistakes. Making mistakes is a part of learning and is expected in this workshop. Taking the time to learn the advanced features of Access 2007 will increase their knowledge on how databases work and make creating and managing an Access 2007 database easier for everyone.
Access 2007 Advanced

$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 2007 Advanced:

  • 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 2007 Advanced Course Outline:

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


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


Module Three: Advanced Form Tasks
  • Creating a Sub-Form
  • Creating a Split-Form
  • Creating a Modal Dialog
  • Creating a Pivot Table
  • Creating a Pivot Chart


Module Four: Advanced Reporting Tasks
  • Using Report Sections
  • Grouping and 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
  • Using Logical Functions


Module Seven: Working with SQL
  • What is SQL?
  • Understanding SQL Statements
  • Basic SQL Syntax
  • Uses for SQL in Access


Module Eight: Linking Data
  • Linking to an Excel Spreadsheet
  • Linking Access Database
  • Linking to a SharePoint List
  • Linking to a Text or XML File
  • Other Types of Links


Module Nine: Importing Data
  • Importing from an Excel Spreadsheet
  • Importing from an Access Database
  • Importing from a SharePoint List
  • Importing from a Text or XML File
  • Other Types of Imports


Module Ten: Exporting Data
  • Saving an Object as PDF
  • Exporting to an Excel Spreadsheet
  • Exporting to a SharePoint List
  • Exporting to a Word or Text File
  • Other Types of Exports


Module Eleven: Advanced Database Tools
  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Compact and Repair 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 ($2990)

Career Development ($2990)

Human Resources ($2990)

Personal Development ($2990)

Sales And Marketing ($2990)

Supervisors And Managers ($2990)

Workplace Essentials ($2990)

Office 2016 ($2990)

Office 2013 ($2990)

Office 365 ($2990)

Office 2010 ($2990)

Office 2007 ($2990)