Access 2007 Advanced Courseware

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.
- 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 2007 Advanced corporate training workshops:

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


Download
FREE Sample
 

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!

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.