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

  • 4.9
  • 0 Enerolled
    • Introduction
      • Welcome 0 min
      • What you should know before watching this course 0 min
      • Using the exercise files 0 min
      • Using the challenges 0 min
    • 1. Microsoft Office Specialist Exam Overview
      • Compare the Microsoft Office Specialist certifications 0 min
      • Prepare for the exam 0 min
      • Review the exam objectives and format 0 min
    • 2. Create and Manage a Database
      • Create a new database 0 min
      • Set up the primary key 0 min
      • Manage relationships 0 min
      • Navigate through a database 0 min
      • Protect and maintain a database 0 min
      • Save and export a database 0 min
      • Challenge: Create a database 0 min
      • Solution: Create a database 0 min
    • 3. Build Tables
      • Create a new table 0 min
      • Format a table 0 min
      • Manage records 0 min
      • Create and modify fields 0 min
      • Challenge: Build tables 0 min
      • Solution: Build tables 0 min
    • 4. Create Queries
      • Work with simple select queries 0 min
      • Create multi-table queries 0 min
      • Create crosstab queries 0 min
      • Modify a query 0 min
      • Utilize calculated fields and group within a query 0 min
      • Challenge: Create queries 0 min
      • Solution: Create queries 0 min
    • 5. Create Forms
      • Create basic forms 0 min
      • Create navigation forms and split forms 0 min
      • Set form controls 0 min
      • Format forms 0 min
      • Challenge: Create a form 0 min
      • Solution: Create a form 0 min
    • 6. Create Reports
      • Create a report 0 min
      • Set report controls 0 min
      • Format a report 0 min
      • Challenge: Create a report 0 min
      • Solution: Create a report 0 min
    • 7. Final Practice Exam
      • Challenge: Full-length practice exam 0 min
      • Solution: Full-length practice exam 0 min
    • Conclusion
      • Next steps 0 min
  • Description

    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.

Trailer video

Build Responsive Websites

Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

This Course Incluce

4 Hours video
Certificate
42 Lectures
Lifetime access