Excel L4-Managing Multiple Workbooks (4/13), Excel L1-Basics (4/19)

(314) 596-2534

Office Productivity Training, LLC
Office Productivity Training, LLC
  • Home
  • Upcoming Events
  • 90-minute Training
  • Software Training
  • Business Skills Training
  • Online & Virtual Training
  • Our Blog
  • Excel Training
  • Access & Project Training
  • Outlook-OneNote Training
  • Word & Office Training
  • PowerPoint & Publisher
  • Other Training Topics
  • Instructional Design
  • Consulting Services
  • About Us
  • Contact Us
  • More
    • Home
    • Upcoming Events
    • 90-minute Training
    • Software Training
    • Business Skills Training
    • Online & Virtual Training
    • Our Blog
    • Excel Training
    • Access & Project Training
    • Outlook-OneNote Training
    • Word & Office Training
    • PowerPoint & Publisher
    • Other Training Topics
    • Instructional Design
    • Consulting Services
    • About Us
    • Contact Us
  • Home
  • Upcoming Events
  • 90-minute Training
  • Software Training
  • Business Skills Training
  • Online & Virtual Training
  • Our Blog
  • Excel Training
  • Access & Project Training
  • Outlook-OneNote Training
  • Word & Office Training
  • PowerPoint & Publisher
  • Other Training Topics
  • Instructional Design
  • Consulting Services
  • About Us
  • Contact Us

Learn to Track Data Like a Pro though our Microsoft Project and Microsoft Access Training

Microsoft Access is a great tool for storing, analyzing, imputing, and reporting data. Our standard and customized Microsoft Access training courses guide you through the process of creating solid relational databases.


Microsoft Project gives you the tools to keep track of and manage the tasks, resources, and costs for any project. 


We  want to make life easier for you. We can use your own projects and data to create databases and project files that you can take back to work with you. Contact us to learn more about our Microsoft Project and Access training services.

Contact Us for a free Estimate and Consultation

Access and Project Courses

Access Courses

Access L1 - Fundamentals

12 hours

Learn everything you need to know to design a solid relational database. Topics include:

  • Database basics
  • Understanding Access Objects
  • Designing a Table
  • Restructuring a Table
  • Field Types
  • The Primary Key
  • Using Input Masks
  • Data Validation
  • Filtering Records
  • Relating Tables
  • Query Basics
  • Form Basics
  • Report Basics

Access L2 - Advanced Queries

4 hours

Learn the tricks to analyzing, summarizing, and calculating data with Access Queries. Topics include:

  • Using Wildcards in a Query
  • Compound Queries
  • Operators   
  • Creating Calculated Fields
  • Using Summary Operators
  • Querying Multiple Tables
  • Action Queries
  • Parameter Queries
  • Crosstab Queries    

Access L3 - Advanced Forms & Reports

4 Hours

Design easy to use forms and great reports. Topics include:

  • Designing Forms
  • Adding Charts to a Form
  • Working with Bound/Unbound Objects
  • Adding a Combo/List Box
  • Creating an Option Group
  • Adding Command Buttons
  • Adding Control Tips
  • Adding a Background Picture
  • Creating Custom Reports 
  • Adding a Calculated Control
  • Navigation Forms
  • Macros 


Project Courses

Project L1 - Project Fundamentals

8 hours

Learn how to create an estimated project time line by tracking the tasks, resources, and costs of a project. Topics include:

  • Creating a New Project Plan
  • Defining a Project
  • Assigning a Project Calendar 
  • Adding Tasks 
  • Importing Tasks From Other Programs
  • Creating Work Breakdown Structure 
  • Defining Task Relationships
  • Scheduling Tasks 
  • Adding Resources
  • Creating a Resource Calendar
  • Entering Costs
  • Assigning Resources to Tasks
  • Resolving Resource Conflicts
  • Optimizing a Project Plan
  • Setting a Baseline


Project L2 - Tracking and Reporting

4 hours

Planning a project is just the start. This course covers the features needed to analyze and track a Project from start to end. Topics Include:

  • Entering Task Progress 
  • Updating Task Progress with SharePoint 
  • Viewing Project Progress 
  • Adding Custom Fields
  • Creating Custom Views
  • Analyzing a Project Plan
  • Rescheduling Tasks
  • Updating a Baseline
  • Reporting Options
  • Creating a Project Plan Template
  • Sharing Resources
  • Linking Project Plans 

HELPING YOU BE MORE PRODUCTIVE WITH THE SOFTWARE YOU USE EVERY DAY

Course Outlines

Outline - Access Level 1 (pdf)Download
Outline - Access Level 2 (pdf)Download
Outline - Access Level 3 (pdf)Download
Outline - Project L1 (pdf)Download
Outline - Project L2 (pdf)Download

How to Quickly Summarize Data in Access

Check out our Access Summary Query tutorial.

Tips & Tricks

Access Tips Handout (pdf)Download

Contact Us

We'd love to hear from you

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Give us a call

 We love our customers, so feel free give us a call. 

Office Productivity Training, LLC

PO Box 912 O'Fallon IL 62269

(314) 596-2534

Social

Copyright © 2023 Office Productivity Training, LLC - All Rights Reserved.

Powered by GoDaddy

  • 90-minute Training

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept