Complete Access 2013

Microsoft Certification Exam 77-424: Access 2013

   Watch Promo

Original Price Access Beginning, Intermediate and Advanced: $600.
SAVE $200 when you buy these courses together.

Save another $100 with the coupon!

"Clear instruction.
"The Instructor is very knowledgeable about Microsoft Access...
"Showing every step necessary to grab each concept."


Microsoft Access is not a beginner's course.
However, our approach to Access is easier than many other texts I have taught.

We teach one-to-one relations, first: One Table for each Form or Query.
Then, in the Intermediate level we get more complex programming: one-to-many.
One to many is represented in Access as Forms with Subforms.
The Advanced level is fun: Action Queries!

The Complete Guide to Microsoft Access 2013

Another Computer Mama Guide: www.thecomputermama.com

If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBooks with pages of detailed instructions
  • Sample presentations and images
  • Practice, Quizzes and Skill Test

All materials for this program are available online. The following resources are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Access 2013
  • Intermediate Guide to Microsoft® Access 2013
  • Advanced Guide to Microsoft® Access 2013
  • Microsoft Access 2013 Sample files

In Beginning Access, you’ll cover basic topics, including:

  • Learn how to navigate the online course and submit your assignments
  • Understand the purpose of Tables and how they are used in a database
  • Edit the Form Properties to help Users navigate the Form Fields and enter data
  • Learn how to design Queries and use Queries to lookup records in the Tables
  • Use Query Criteria and Parameter Queries to select specific records in the Tables
  • Learn how to design and modify Reports in Layout and Design Views
  • Learn how to manage Database files: Save and Save As

In Intermediate Access, you’ll cover these options:

  • Review the definition of one-to-many relationships in a database
  • Create a One-From-Many Relationship by using a Combo Box on a Form
  • Learn how to design Forms and Subform that represent a one-to-many relatinship
  • Use Forms and Subforms to create a Search Form
  • Create a Switchboard Form with Command buttons that open Forms and Reports
  • Use a Query to calculate the Total in a Report

In Advanced Access, you’ll cover advanced topics, including:

  • Understand how to create and Normalize a database
  • Learn how to create relationships between Tables in a Database: using Key data
  • Understand Primary Keys and Relationships
  • Create a Receipt Form that uses a Report and Subreport to calculate the total
  • Become skilled at working with Dates in a Query
  • Visualize the results and export the Reports
  • Learn strategies for Archiving data using Action Queries
  • Optimize a database for Multi-Users and improve network performance

A student who wishes to take Microsoft Access should be comfortable working with files and saving different versions of their work. In terms of Microsoft Excel, students should have some experience creating formulas. Microsoft Access and Excel use similar formulas to calculate dates (DateDiff), Logical functions (IIF), and financials (SUM, COUNT, AVERAGE, MAX and MIN.)

Who Would Benefit from this Course: You!

This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities.

The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.

This course teaches the objectives for the following certification tests:
Expert Certification:
Access® 2013: Exam 77-424

Your Instructor

Elizabeth Nofs
Elizabeth Nofs
Elizabeth Ann Nofs, The Computer Mama, developed the teaching methodology in the Complete Computer Guide series using breakthrough research in gender balanced training. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education in both online and hands-on classrooms. She is the author of more than 60 Microsoft Office Computer Guides as well as a Microsoft Certified Office Specialist.

Elizabeth earned a BA in Biology from the University of Michigan.


Courses Included with Purchase

Beginning Access 2013
Microsoft Certification Exam 77-424: Access 2013
Elizabeth Nofs
Intermediate Access 2013
Microsoft Certification Exam 77-424: Access 2013
Elizabeth Nofs
Advanced Access 2013
Microsoft Certification Exam 77-424: Access 2013
Elizabeth Nofs

Original Price: $600

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!

Original Price Access Beginning, Intermediate and Advanced: $600.

Save $200 when you buy these courses together.

Save another $100 with the coupon!