Get Microsoft Access 2013 Certified (MOS) Exam 77-424
3.8 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,887 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Get Microsoft Access 2013 Certified (MOS) Exam 77-424 to your Wishlist.

Add to Wishlist

Get Microsoft Access 2013 Certified (MOS) Exam 77-424

Learn how to pass the Microsoft Office Specialist (MOS) Access 2013 Exam. The entire course is all hands on tutorials
3.8 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,887 students enrolled
Last updated 7/2016
English [Auto-generated]
Current price: $12 Original price: $95 Discount: 87% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 7 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • prepare for the Microsoft 2013 Access 2013 certification exam
  • Learn how to create a database and work with basic functions
  • Understand tables and their usage
  • Work with Queries to search for information from existing data
  • Create Forms and work with controls
  • Generate reports, including customization and branding
View Curriculum
  • Need to have a stable internet connection
  • Basic understanding of database concepts
  • Some experience with Microsoft office products such as Excel and Word

This Microsoft Access 2013 Exam 77-424  is designed for candidates who have a fundamental understanding of the Access 2013 environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Access 2013.

The new Access 2013 certification exam uses practical, performance-based scenarios to evaluate their real-world capabilities with project and standards-based outcome testing.Certified candidates will demonstrate their ability to use principle Access 2013 features to independently create custom, browser-based database applications. Tasks will include creating and managing a database, building tables, creating queries, creating forms and creating reports.

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.

Create and manage a database (20–25%)

Build tables (25–30%)

Create queries (15–20%)

Create forms (15–20%)

Create reports (15–20%)

The Microsoft Access 2013 exam is more relevant than past exams, featuring comprehensive, project-based testing. This means candidates are responsible for demonstrating the ability to complete a realistic Microsoft Office Specialist Access 2013 project.

Who is the target audience?
  • If you wish to obtain the Microsoft Office Specialist Certification (MOS), you should take this course
  • If you need to gain additional skills in Access 2013, this course is for you
  • Refresh your concepts on tables, forms, queries, and reports
  • This course is not for individuals who have not worked within the Access 2013 environment.
Compare to Other Microsoft Access Courses
Curriculum For This Course
28 Lectures
Introduction and Course Agenda
2 Lectures 14:57

This lesson is about the course and the instructor bio

Preview 02:24

This is the course agenda

Preview 12:33
Introducing Microsoft Access 2013
3 Lectures 25:14

This lesson demonstrates how to work with existing templates and modifying those templates. You will also learn the location of the templates and how to access them.

Using Templates

Download and work with Access online templates

Practice Task: Working with Online Template

In this lesson, you will learn how to work with various tools on the Ribbon area. You will also get familiar with the Access 2013 Ribbon and its usage

Reviewing The Ribbon
Opening An Existing Database
5 Lectures 39:42

In this lesson, you will grasp an understanding of various Microsoft Access 2013 options

Preview 10:12

In this lesson, you will understand the concept of an existing database. You will also open the database and explore various aspects.

Opening a Database

Everything you need to know about the table is covered in this lesson such as fields and much more

Anatomy of a Table

Create 5 tables in this practice exercise

Practice Task: Create 5 Tables

In this lesson, you will learn how to add a new record to an existing table, and navigating between tables

Adding a Record
Creating a New Database
4 Lectures 32:48

In this lesson, you will learn how to create a new table and rename it

Creating a New Table

In this lesson, you will learn about different data types in Access 2013. For example, string, integer, and more

Understanding Data Types

There are several data types. In this lesson, you will learn about each data type such as string, integer and others.

Adding Fields and Entering Data

In this practice task, the real challenge is to create a calculated filed in your tables while you add data

Practice Task: Add Data to Tables
Working with Queries
3 Lectures 20:57

When you want to search for information or fetch information from your data, you need to create a query. In this lesson, you will learn how to create queries using the Query Wizard

Using Query Wizard

In this lesson, you will learn how work with the design view of the query and customize various options

Using Query Design View

Queries are an important element of Access 2013. You can create query to fetch information from existing data. In this lesson you will learn how to create a new query to find duplicate values

Creating a New Query
All About Forms
5 Lectures 28:38

In this lesson, you will learn how to use the forms wizard to create forms for use data input

Forms Wizard

The lesson demonstrates the working of forms design view and how to work with different controls.

Forms Design View

In this lesson, Form Controls are detailed out and learn how to place controls on your Access 2013 forms

Working with Form Controls

Practice Task:

In this practice task, create a form using the Forms Wizard, and then within design view, insert a sample logo of you choice.

You can insert any image.

Practice Task: Create a Customized Form and Insert Sample Logo

In this task, create a report and later customize it for branding purposes

Practice Task: Report Customization
All About Reports
4 Lectures 26:12

Using the Report Wizard, you will learn how to create and generate a report in Access 2013

Creating Reports using Report Wizard

Placing controls on reports is demonstrated in this lesson

Report Controls

Brand management and report customization is demonstrated in this lesson, You will learn various techniques on how to customize and brand your reports

Preview 09:05

Create a complete Access 2013 Project

Practice Task: Final Project
Course Conclusion
2 Lectures 02:16

In this lesson, we will recap the course to re-enforce learning concepts

Course Conclusion

Exam details and information on how to go about registering for the exam

Microsoft Office Specialist (MOS) Access 2013 Exam 77-424 Information
About the Instructor
ClayDesk E-learning
4.1 Average rating
1,973 Reviews
84,854 Students
22 Courses
The Knowledge Factory

Welcome! to the Knowledge factory by ClayDesk. My name is Syed Raza, and as the CEO of ClayDesk, I am delighted to provide learning solution to my students. My fellow co-instructors play an important part in building these courses to ensure quality and latest trends in learning - I encourage you to browse through our courses and enroll.

1) We teach with passion and purpose! Every course is delivered with our students in mind. Teaching a combined student population of over 160,000.

2) Our courses will help you gain real world skills and knowledge and change your life today!

3) Our dedication to the teaching profession and teaching online. Udemy has named our instructors as one of its top instructors.

ClayDesk creates and distributes high quality technology training content. Our certified team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Mission Statement- ClayDesk e-learning is dedicated to provide superior e-learning and outsourcing services worldwide.

Syed Raza
4.1 Average rating
2,153 Reviews
88,066 Students
26 Courses
Top Udemy Instructor! 85,000+ students

Why are 85,000+ students (and counting) enrolled in my courses?

1) As the CEO of ClayDesk, I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you gain real world skills and knowledge and change your life today!

3) My dedication to the teaching profession and teaching online. Udemy has named me one of its top instructors.

► Try enrolling in a course with me and see for yourself! ◄


Want to learn how to become A Professional Web Developer?

Would you like to  Boost Your Career?

Then Enroll in my Courses Today! You too can be doing this - and so much more!


About Syed Raza:

Syed graduated from University of Wisconsin in 1995 with a BBA in Finance. Subsequently, he obtained an MBA from Concordia University, LLB and DBL degrees from University Law College, and PhD in Management Sciences. Having obtained MCSE (Microsoft Certified Systems Engineer), MCP+I (Microsoft Certified Professional + Internet), and MCT (Microsoft Certified Trainer), Syed has provided training to thousands of students. ClayDesk provides e-Discovery and cloud computing services including technical training to a wide range of clients globally. 


Syed Raza is an entrepreneur running his own e-learning site along with providing e-discovery and cloud computing consulting and services to a global client base. Syed is a Microsoft Certified Trainer and a Systems Engineer, and his solid finance and management background gives him a competitive edge. He has taught thousands of students in the United States and continues to inspire students of all ages.

Mission Statement- ClayDesk e-discovery and cloud computing is dedicated to provide superior e-learning and outsourcing services worldwide.

Qasim Shah
3.9 Average rating
716 Reviews
35,782 Students
11 Courses
Marketing and Social Evangelist

Qasim graduated from the University of Wisconsin with a BA in Interpersonal Communications; going on to obtain an MBA in Marketing from LUMS University. Alongside the exciting academic thrill seeking, he has a passion for IT, having obtained a MCSE (Microsoft Certified Systems Engineer), MCT (Microsoft Certified Trainer), A+ Hardware Certification and a MCP+I (Microsoft Certified Professional + Internet).

Qasim has been making this world more knowledgeable since 2003, having trained and molded thousands of minds across the globe.

Syed Ali
4.1 Average rating
1,471 Reviews
67,329 Students
20 Courses
Online Instructor - Teaching Over 50,000+ Students!

I am the youngest Instructor present on Udemy Platform and have several years of experience in development environment as programmer. I have been programming since the age of 13.

On the other hand, I have expertise and experience in all phases of project life cycle namely analysis, design, coding, testing and implementation phases. I have experience in working with different operating systems, with keen focus on SharePoint development.

Also have efficiently managed the team and took care in delivering quality deliverables from my team which proved my managerial and leadership skill. Moreover, I have high web developing skills as a web developer and can make websites using WordPress, Joomla, and Drupal. Additionally, can migrate them from one host to the other. I have worked within the following realms:

- Developed script in Python programming language for 3D mapping using raspberry pi and quad-copter
- Developed system for processing data in parallel with data collection
- Redesigned tracking systems to work with tabular data
- Developed tools in Python for vehicle tracking and post-data-collection processing
- Data parsing, statistical analysis