Access 2010 Advanced Courseware

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!
- OR -
  • No Annual Renewal Fees
  • Unlimited Users
  • Unlimited Printing Rights
  • All Components are Completely Customizable!

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

Polaroid America's Navy Aramex Delivery Unlimited Hertz Tupperware

“These materials are a life saver...”

Read testimonials.

This trainer's courseware kit includes everything you need to teach Access 2010 Advanced Microsoft Office training workshops:


  • Participant Training Manuals
  
  • Instructor's Guide
    with Lesson Plans
  • PowerPoint Slides and
    Flip Chart Notes
  
  • Quick Reference Sheets
  • Icebreakers, Exercise Files,
    and other Workshop Activities
  
  • Pre-Assignments,
    Post-Assessments
  • Promotional Advertorials
  
  • Online Training Versions



Download
FREE Sample
 

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!

    Microsoft Office Training

    Access 2007 Advanced
    Access 2007 Essentials
    Access 2010 Advanced
    Access 2010 Essentials
    Access 2010 Expert
    Access 2013 Advanced
    Access 2013 Essentials
    Access 2013 Expert
    Excel 2007 Advanced
    Excel 2007 Essentials
    Excel 2010 Advanced
    Excel 2010 Essentials
    Excel 2010 Expert
    Excel 2013 Advanced
    Excel 2013 Essentials
    Excel 2013 Expert
    Excel 365 Essentials
    Groove 2007 Essentials
    InfoPath 2007 Advanced
    InfoPath 2007 Essentials
    InfoPath 2010 Advanced
    InfoPath 2010 Essentials
    InfoPath 2010 Expert
    Lync 365 Essentials
    OneNote 2007 Advanced
    OneNote 2007 Essentials
    OneNote 2010 Advanced
    OneNote 2010 Essentials
    OneNote 2013 Advanced
    OneNote 2013 Essentials
    OneNote 365 Essentials
    Outlook 2007 Advanced
    Outlook 2007 Essentials
    Outlook 2010 Advanced
    Outlook 2010 Essentials
    Outlook 2010 Expert
    Outlook 2013 Advanced
    Outlook 2013 Essentials
    Outlook 2013 Expert
    Outlook 365 Essentials
    PowerPoint 2007 Advanced
    PowerPoint 2007 Essentials
    PowerPoint 2010 Advanced
    PowerPoint 2010 Essentials
    PowerPoint 2010 Expert
    PowerPoint 2013 Advanced
    PowerPoint 2013 Essentials
    PowerPoint 2013 Expert
    PowerPoint 365 Essentials
    Project 2007 Advanced
    Project 2007 Essentials
    Project 2010 Advanced
    Project 2010 Essentials
    Project 2010 Expert
    Publisher 2007 Advanced
    Publisher 2007 Essentials
    Publisher 2010 Advanced
    Publisher 2010 Essentials
    Publisher 2013 Advanced
    Publisher 2013 Essentials
    SharePoint 365 Essentials
    SharePoint Designer 2007 Essentials
    SharePoint Designer 2010 Essentials
    Visio 2007 Advanced
    Visio 2007 Essentials
    Visio 2010 Advanced
    Visio 2010 Essentials
    Windows 7 Essentials
    Word 2007 Advanced
    Word 2007 Essentials
    Word 2010 Advanced
    Word 2010 Essentials
    Word 2010 Expert
    Word 2013 Advanced
    Word 2013 Essentials
    Word 2013 Expert
    Word 365 Essentials



    Why choose Global Courseware?

    · Classroom ready: save hundreds of hours in prep
    · Modify content to increase relevancy to your audience
    · Peace of mind: professional, classroom tested presentation materials
    · Print as many copies as you need, whenever you want
    · Unlimited number of trainers within your organization
    · Rebrand using your name and logo (and remove ours!)