135
Course Topics and Flow
Download Exercise - Northwind Access Database
Download Exercise - Modules 5 & 6 only
Cheat Sheet - Getting Started with Access
Opening Microsoft Access
Access Quick Access Toolbar
Working with the Access Ribbon
Access Object Panel
Access File Tab
Access Security Prompt
Understanding the Purpose of Access Tables
Building Relationships between Access Tables
Using Access Queries to Select Specific Data
Building a User Interface with Access Forms
Reporting on Access Data with Access Reports
Automate Access Tasks with Macros and VBA
Working in Datasheet View within an Access Table
Sorting the Datasheet View
Filtering the Datasheet View with Filter by Selection
Filter the Datasheet View with Advanced Filter
Preview the "Student Course" Database Tables
Creating an Access Database
Designing Access Tables in Design View
Adding Fields and Defining Common Data Types in an Access Table
Field Size Property
Field Caption Property
Default Value Property
Required Field Property
Input Mask Property
Custom Input Mask
Working with the Lookup Wizard Data Type
Edit a Table Field Drop Down
Adding Field Descriptions
Setting the Table's Primary Key Field
Adding Records in the Datasheet View
Table Exercise Introduction
Understanding Access Table Relationships
Creating Access Table Relationships
Setting Up "Better" Table Relationships
Setting the Relationship Properties
Table Relationships Cascade Update/Delete
Working with Sub Datasheets in Tables
Creating Table Relatioships with the Lookup Wizard
Creating an Access Select Query
Adding Criteria to an Access Select Query
Using AND Conditions in an Access Query
Using OR Conditions in an Access Query
Another OR Condition
Sorting Data within an Access Select Query
Multi-Level Query Sort
Working with Date Criteria in an Access Select Query
Using the "Between" Operator
Access Query Tip -- Using Table Fields within Query Criteria
Using Wildcards in Query Criteria
Access Query Tip --- DATA TYPE MISMATCH
Saving an Access Query
Creating a Calculated Field in an Access Query
Using the MONTH() and MONTHNAME() Functions
Using the IF() Function in a Query Calculated Field
Finding the Difference Between Two Dates Using the DateDiff() Function
Working with an Access Total Query
Grouping and Summarizing Data with a Total Query
Adding a Calculated Field to a Total Query
Saving a Total Query
Total Query Exercise -- Post in the QA Section
Total Query Example -- Products Table
Summarizing Data with a Crosstab Query
Introduction to Access Action Queries
Update Access Table Data with an Update Query
Update Table Data with a Calculation
Saving an Action Query
Creating a New Table with an Access Make Table Query
Deleting Table Data with an Access Delete Query
Appending Records to an Exisiting Table with an Access Append Query
Creating a Query with Multiple Tables
Working with Query Joins
Inner Join and Left Outer Join
Parameter Query Preview
Creating a Single Parameter
Saving the Parameter Query
Creating Date Parameters
Creating Multiple Parameters
Using Wildcards in Parameters
Run a Parameter with a Shortcut
Starting with a Blank Form
Adding Form Fields
Moving Form Fields
Resizing Form Fields
Aligning Form Fields
Spacing Form Fields
Saving a Form
Adding, Deleting and Editing Records
Sorting Form Records
Filtering Form Records using Filter by Selection
Filtering Form Records using Advanced Filter
Introduction to Form Controls
Adding a Header and Footer
Creating Calculated Form Fields
Working with Sub Forms
Working with the Option Group Control
Adding the Tab Control to a Form
Adding Buttons to a Form
Formatting Field Controls
Creating Separation with the Line Control
Changing the Form Background color
Preview an Access Switchboard
Start the Switchboard Manager
Adding Buttons to the Switchboard
Fomatting the Switchboard
Modify the Switchboard
Preview Filtering Query Data with a Form
Setting up the Query
Setting up the Form
Clean Up the Combo Box Control
Creating the Form Button to Run the Query
Adding Form Reference Criteria to the Query
Running the Query
Creating a Blank Report
Adding Fields
Field Layout
Working with Report Sections
Format Fields
Report Margins
Format Painter
Header & Footer
Report Saved
Calculated Field Text Box
Check Box Calculation
Grouping Report Data
Group Headers
Repeat Group Headers
Section Page Breaks
Group Footer
Group Calculation
Unlock Your Certificate of Completion

img

But Don’t Just Take Our Word For It

Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust MyExcelOnline to enhance their professional development and every day.

Some of our course students work at...

Save with our Courses Bundles!

Intro to Excel Bundle

An introduction to Microsoft Excel to get you up to speed and confident using the most common features!

  • Introduction to Excel
  • Formulas
  • Formatting
  • Charts
  • Printing
  • 5 Hours | 56 Lectures | Beginner Level | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Intermediate Excel Bundle

Learn the must know Microsoft Excel features to elevate your Excel level!

  • Formulas
  • Pivot Tables
  • Macros & VBA
  • Data & Analysis
  • Charts
  • 11 Hours | 216 Lectures | Intermediate Level | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Advanced Excel Bundle

Learn the must know Microsoft Excel features to advance your Excel level!

  • Formulas
  • Pivot Tables
  • Macros & VBA
  • Power Query
  • Power Pivot
  • Power BI
  • Excel Dashboards
  • Financial Modeling
  • Charts
  • 40 Hours | 569 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Microsoft Office Bundle

Learn the must know Microsoft Office applications to make you more productive at work!

  • Outlook
  • PowerPoint
  • Word
  • Teams
  • OneNote
  • Access
  • Power Automate
  • Power Apps
  • Project
  • SharePoint
  • Visio
  • Forms
  • 14 Hours | 291 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Frequently Asked Questions

  • You're starting to learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how to get an advantage over your colleagues or peers.
  • You're preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job!
  • You often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck.
  • You spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones.
  • You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training.

Anyone who wants to elevate their Excel knowledge & skills, including…

  • New users, beginners, intermediates and advanced Excel users.
  • Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and reporting.
  • People who want to change careers and apply for a new job that requires knowledge of Microsoft Excel
  • If you want to dramatically reduce repetition, stress, and overtime and exponentially increase your chances of a promotion, pay raise or new job!
  • It doesn’t matter if you are completely new to Excel. No prior Excel knowledge is necessary to participate in this course.


The tutorials were recorded using Excel 2010, 2013, 2016, 2019, 2022 and Microsoft 365.

Most of the concepts taught are compatible with:

  • Excel for Windows: 2007, 2010, 2013, 2016, 2019, 2022 & Microsoft 365
  • Excel for Mac: 2011, 2016, 2019, 2022 & Microsoft 365

No - this isn’t like school - this is self-paced learning - you decide when you start and when you finish.

You get access to all the training materials for life. 

You can access the course site from your work computer, home computer, tablet, smartphone or any other device with an internet connection.

The course site remembers your progress, so you can pick-up right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.

Yes! You will be able to download and keep all the excercise files in each of the courses as well as our PDF Cheat Sheets.

This makes it easy to follow along and practice with our data, whether you are online or offline.

Yes, this course and all the training materials can be accessed on any tablet or smartphone, and it looks beautiful. 

You can watch the course on your iPad, Tablet or mobile phone anywhere and anytime!

Each video has a discussion section. You can use this section to ask questions and see what questions other students have. We will be there helping to answer your questions.


You can also send an email to our dedicated email support if you cannot find your answer.

Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. 

Most companies are willing to invest in making their employees even more awesome at Excel!

We accept all major credit cards like Visa, MasterCard, American Express, Apple Pay and PayPal.

Through our partners like Klarna, Afterpay, and Affirm, we can give you the flexibility of breaking up your purchase into easy installments.

The course fees are shown in USD $

Get in contact with us if you want to pay via bank transfer or check at [email protected]

If you need a Tax Invoice for your records, then this can be emailed to you. We are happy to complete any paperwork your company or government may require.

Yes! Each course comes with lifetime access to all course materials.

There are team packages available at a discounted price!

Each team member will have their own account and be able to track their progress in the course. 

Get a quote by filling in this form here: https://www.myexcelonline.com/corporate-academy-team-packages

Yes! You will receive a Completion Certificate at the end of each course.

You can cancel at any time within the first 30 days and receive a full refund.


Plus, you get to keep all our downloadable course Cheat Sheets and Workbooks!