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!

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

  • PowerPoint
    Slides
  • Web-based
    Training
  • Quick
    Reference
    Sheets
  • Icebreakers & Exercise
    Files
  • Training Manuals
    & Instructor Guide


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!

    Soft Skills Library

    Administrative Support
    Anger Management
    Assertiveness And Self-Confidence
    Attention Management
    Basic Bookkeeping
    Body Language Basics
    Budgets And Financial Reports
    Business Ethics
    Business Etiquette
    Business Succession Planning
    Business Writing
    Call Center Training
    Change Management
    Civility In The Workplace
    Coaching And Mentoring
    Communication Strategies
    Conflict Resolution
    Creative Problem Solving
    Critical Thinking
    Customer Service
    Emotional Intelligence
    Employee Motivation
    Employee Onboarding
    Employee Recruitment
    Facilitation Skills
    Generation Gaps
    Human Resource Management
    Interpersonal Skills
    Job Search Skills
    Knowledge Management
    Lean Process And Six Sigma
    Measuring Results From Training
    Media And Public Relations
    Meeting Management
    Middle Manager
    Negotiation Skills
    Office Politics for Managers
    Overcoming Sales Objections
    Performance Management
    Personal Productivity
    Presentation Skills
    Project Management
    Proposal Writing
    Public Speaking
    Safety In The Workplace
    Sales Fundamentals
    Stress Management
    Supervising Others
    Supply Chain Management
    Talent Management
    Teamwork And Team Building
    Time Management
    Train-The-Trainer
    Work-Life Balance
    Workplace Diversity
    Workplace Harassment
    Workplace Violence
    Delivering Constructive Criticism
    Leadership And Influence
    Manager Management
    Managing Workplace Anxiety
    Organizational Skills






    Microsoft Office Library

    Access 2007 Advanced
    Access 2007 Essentials
    Access 2010 Advanced
    Access 2010 Essentials
    Excel 2007 Advanced
    Excel 2007 Essentials
    Excel 2010 Advanced
    Excel 2010 Essentials
    Excel 365 Essentials
    Groove 2007 Essentials
    InfoPath 2007 Advanced
    InfoPath 2007 Essentials
    InfoPath 2010 Advanced
    InfoPath 2010 Essentials
    OneNote 2007 Advanced
    OneNote 2007 Essentials
    OneNote 2010 Advanced
    OneNote 2010 Essentials
    Outlook 2007 Advanced
    Outlook 2007 Essentials
    Outlook 2010 Advanced
    Outlook 2010 Essentials
    Outlook 365 Essentials
    PowerPoint 2007 Advanced
    PowerPoint 2007 Essentials
    PowerPoint 2010 Advanced
    PowerPoint 2010 Essentials
    PowerPoint 365 Essentials
    Project 2007 Advanced
    Project 2007 Essentials
    Project 2010 Advanced
    Project 2010 Essentials
    Publisher 2007 Advanced
    Publisher 2007 Essentials
    Publisher 2010 Advanced
    Publisher 2010 Essentials
    SharePoint Designer 2007 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 365 Essentials
    Lync 365 Essentials
    OneNote 365 Essentials
    SharePoint 365 Essentials



    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.