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

Created byClayDesk E-learning, Syed Raza, Qasim Shah, Ali Bokhari

Last updated 7/2016

English

What you'll 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

Course content

8 sections • 28 lectures • 3h 10m total length

Introduction2:24
This lesson is about the course and the instructor bio
Course Agenda12:33
This is the course agenda

Using Templates14:52
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.
Practice Task: Working with Online Template0:16
Download and work with Access online templates
Reviewing The Ribbon10:05
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

Microsoft Access 2013 Options10:12
In this lesson, you will grasp an understanding of various Microsoft Access 2013 options
Opening a Database10:08
In this lesson, you will understand the concept of an existing database. You will also open the database and explore various aspects.
Anatomy of a Table13:09
Everything you need to know about the table is covered in this lesson such as fields and much more
Practice Task: Create 5 Tables0:10
Create 5 tables in this practice exercise
Adding a Record6:02
In this lesson, you will learn how to add a new record to an existing table, and navigating between tables

Creating a New Table15:19
In this lesson, you will learn how to create a new table and rename it
Understanding Data Types10:27
In this lesson, you will learn about different data types in Access 2013. For example, string, integer, and more
Adding Fields and Entering Data6:51
There are several data types. In this lesson, you will learn about each data type such as string, integer and others.
Practice Task: Add Data to Tables0:10
In this practice task, the real challenge is to create a calculated filed in your tables while you add data

Using Query Wizard9:27
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 Design View6:55
In this lesson, you will learn how work with the design view of the query and customize various options
Creating a New Query4:35
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

Forms Wizard6:27
In this lesson, you will learn how to use the forms wizard to create forms for use data input
Forms Design View7:58
The lesson demonstrates the working of forms design view and how to work with different controls.
Working with Form Controls13:54
In this lesson, Form Controls are detailed out and learn how to place controls on your Access 2013 forms
Practice Task: Create a Customized Form and Insert Sample Logo0:11
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: Report Customization0:06
In this task, create a report and later customize it for branding purposes

Creating Reports using Report Wizard8:31
Using the Report Wizard, you will learn how to create and generate a report in Access 2013
Report Controls8:14
Placing controls on reports is demonstrated in this lesson
Customizing and Branding Reports9:05
Brand management and report customization is demonstrated in this lesson, You will learn various techniques on how to customize and brand your reports
Practice Task: Final Project0:21
Create a complete Access 2013 Project

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.

Looking forward to seeing you in class

Team ClayDesk

Who this course is for:

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.

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

What you'll learn

Explore related topics

Course content

Introduction and Course Agenda2 lectures • 15min

Introducing Microsoft Access 20133 lectures • 25min

Opening An Existing Database5 lectures • 40min

Creating a New Database4 lectures • 33min

Working with Queries3 lectures • 21min

All About Forms5 lectures • 29min

All About Reports4 lectures • 26min

Course Conclusion2 lectures • 2min

Requirements

Description

Who this course is for: