Cert Prep: Access 2013 Microsoft Office Specialist (77-424)

Author

Released

5/3/2016

Distinguish yourself from other Access users by preparing for the Microsoft Office Specialist Access 2013 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test candidates prepare for exam 77-424, which covers the five main skills included on the Access 2013 exam: creating databases, tables, queries, forms, and reports.

Disclaimer: Microsoft does not produce, provide, or endorse this video training course.

The course first explores the MOS certification program and highlights its cost, format, and objectives. Jennifer then walks viewers through all of the Access exam areas in detail. She explains how to create and manage Access databases, build tables, join tables with relationships, and create queries, forms, and dynamic reports. She includes free practice files to follow along while learning about each topic. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.

Topics include:

Preparing for the exam

Reviewing exam objectives

Creating a new database

Managing relationships

Protecting a database

Creating tables

Modifying fields

Creating different types of queries

Using calculated fields and groups in a query

Building forms

Creating and formatting reports

Taking a full-length practice exam

Skill Level Intermediate

3h 47m

Duration

76,670

Views

Show MoreShow Less

- [Voiceover] Hi my name is Jennifer McBee.And I'm here to help you passthe Microsoft Office Specialist Exam for Access 2013.I'm a certified MOS master instructor.And I've been mentoring studentsin Microsoft Access since 2006.We'll start with an overview of the differentMOS certifications and how to prepare for the exam.Next we'll cover how to create a database,learn how to create tables and setup the propertiessuch as validation rules,input math.We'll learn how to create a basic forms,how to write queries,we'll review how to establish relationshipsbetween tables so that we can combineinformation for queries,forms and reportsfrom two or more tables.

Finally,we'll learn how to createprofessional dynamic reports.So we can share with othersthe information stored in our tables.We'll finish with a full lengthpractice exercise to test your skills and your speed.When you can finish the practice examin under 40 minutes.You're probably ready to take on the fullAccess 2013 MOS exam.Thanks for joining me on this Access 2013 journey.