The Complete Guide to Microsoft Access 2013

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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 through advanced 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 basic through advanced topics, including:

  • 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 basic through 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


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

Expected Outcomes

  1. Understand the purpose of Tables and how they are used in a database
  2. Edit the Form Properties to help Users navigate the Form Fields and enter data
  3. Learn how to design Queries and use Queries to lookup records in the Tables
  4. Use Query Criteria and Parameter Queries to select specific records in the Tables
  5. Learn how to design and modify Reports in Layout and Design Views
  6. Learn how to design Forms and Subform that represent a one-to-many relationship
  7. Create a Switchboard Form with Command buttons that open Forms and Reports
  8. Use a Query to calculate the Total in a Report
  9. Understand how to create and Normalize a database
  10. Learn how to create relationships between Tables in a Database: using Key data
  11. Learn strategies for Archiving data using Action Queries
  12. Optimize a database for Multi-Users and improve network performance