Get Microsoft Access 2013 Certified (MOS) Exam 77-424
3.8 (47 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,665 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 (47 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,665 students enrolled
Last updated 7/2016
English
Current price: $10 Original price: $95 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 7 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Need to have a stable internet connection
  • Basic understanding of database concepts
  • Some experience with Microsoft office products such as Excel and Word
Description

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
28 Lectures
03:10:42
+
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
14:52

Download and work with Access online templates

Practice Task: Working with Online Template
00:17

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
10:05
+
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
10:08

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

Anatomy of a Table
13:09

Create 5 tables in this practice exercise

Practice Task: Create 5 Tables
00:11

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

Adding a Record
06:02
+
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
15:19

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

Understanding Data Types
10:27

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
06:51

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
00:11
+
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
09:27

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

Using Query Design View
06:55

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
04:35
+
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
06:27

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

Forms Design View
07:58

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

Working with Form Controls
13:54

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
00:12

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

Practice Task: Report Customization
00:06
+
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
08:31

Placing controls on reports is demonstrated in this lesson

Report Controls
08:14

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
00:22
+
Course Conclusion
2 Lectures 02:16

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

Course Conclusion
02:12

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

Microsoft Office Specialist (MOS) Access 2013 Exam 77-424 Information
00:04
About the Instructor
ClayDesk E-learning
4.2 Average rating
1,811 Reviews
81,188 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.2 Average rating
1,928 Reviews
83,004 Students
25 Courses
Top Udemy Instructor! 80,000+ students

Why are 80,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. 

Business:

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
4.1 Average rating
670 Reviews
34,232 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.2 Average rating
1,264 Reviews
62,350 Students
19 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