MOS Access 2016 Microsoft Certification Exam 77-730 from Udemy

UPDATED January 2021

Featured questions in the Q & A section of the course

Update June 2019

Added additional project assignments

Update March 2019

Added additional assignments

The It is targeted to people, who want to succeed in the 77-730 exam.

The Course at a glance

In this course you will find:

58 assignments properly categorized
58 distinct files for each of the above assignments
58 solution videos for every assignment
12 project questions similar to the ones you will face in the exam
2 lectures explaining the examination process and the structure of the multi-project question

The Course in detail

58 assignments properly categorized

In this course you will practice on the following categories:

1. Create and Manage a Database

2. Build Tables

3. Create Queries

4. Create Forms

5. Create Reports

6. Projects

58 distinct files for each of the above assignments

Each and every assignment comes with its distinct file(s) that are necessary to answer the assignment

58 solution videos for every assignment

All assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.

12 project questions similar to the ones you will face in the exam

Since the release of Office 2016, Microsoft introduced a new kind of examination. This examination consists of multiple project questions. We have included 12 such project questions in this course

Fast feedback from our instructors

We give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.

What's inside

Learning objective

By completion of the course, the students will be well prepared to take the mos 77-730 exam

Syllabus

Introduction

How to submit an assignment

Create and Manage a Database

2013

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Includes numerous project questions that mirror the format and style of those encountered on the actual MOS Access 2016 certification exam, offering targeted practice

Features video solutions for each assignment, which allows learners to review their work and understand the correct approach, reinforcing key concepts

Covers the core areas assessed in the MOS Access 2016 exam, including database management, table building, query creation, form design, and report generation

Uses Access 2016, which may be an older version of the software, so learners should verify it aligns with their certification or professional needs

Reviews summary

Mos access 2016 certification exam prep

According to learners, this course is a highly effective resource specifically designed for preparing for the MOS Access 2016 Exam (77-730). Many students found the course content, particularly the assignments and solution videos, to be incredibly helpful and directly relevant to the exam format and question types, including the multi-project questions. Reviewers frequently mentioned feeling well-prepared and confident after completing the material. The course structure, with its emphasis on practice and clear explanations, is often highlighted as a major strength. Some learners specifically appreciated the instructor's responsiveness to questions.

Instructor provides timely feedback.

"The instructor was quick to respond to my questions and provided helpful feedback."

"I appreciated the fast replies from the instructor whenever I got stuck on something."

Addresses the exam's new question type.

"The projects section, especially the multi-project questions, was exactly like the exam."

"It was great that the course included examples of the multi-project questions. That really helped me prepare for the exam format."

"Understanding the multi-project questions from this course gave me a lot of confidence for the test."

Assignments and solutions aid understanding.

"The assignments are very good practice, and the solution videos make everything clear."

"I really liked having the separate files for each assignment and being able to check my work with the solution videos."

"The detailed videos explaining each assignment solution were a key part of my learning process."

Course content aligns perfectly with exam.

"This course was perfect for preparing me to take the MOS Access 2016 certification exam."

"I highly recommend this course for anyone wanting to pass the MOS Access 2016 exam. It covered everything I needed."

"The course content is spot on for the 77-730 exam. I felt completely ready after finishing it."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MOS Access 2016 Microsoft Certification Exam 77-730 with these activities:

Review Database Concepts

Show steps

Reinforce your understanding of core database concepts before diving into Access-specific tasks. This will help you grasp the underlying principles behind Access features.

Browse courses on Relational Databases

Show steps

Review basic database terminology (tables, queries, forms, reports).
Practice creating simple database schemas on paper.
Research the differences between database types.

Microsoft Access 2016 Step by Step

Show steps

Supplement the course material with a comprehensive guide to Microsoft Access 2016. This book provides step-by-step instructions and real-world examples to enhance your understanding.

View Microsoft Office Professional 2010 Step by Step on Amazon

Show steps

Read the chapters related to the course syllabus.
Work through the examples and exercises in the book.
Use the book as a reference when working on assignments.

Practice Creating Basic Tables

Show steps

Solidify your table creation skills by repeatedly practicing different scenarios. This will improve your speed and accuracy in the exam.

Show steps

Create tables with different data types (text, number, date).
Practice setting primary keys and foreign keys.
Import data from external sources (Excel, CSV) into tables.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Create a Cheat Sheet

Show steps

Compile a cheat sheet of common Access functions, shortcuts, and best practices. This will serve as a quick reference during the exam and reinforce your learning.

Show steps

List important Access functions and their syntax.
Include keyboard shortcuts for common tasks.
Summarize best practices for database design and query optimization.

Access 2016 Bible

Show steps

Expand your knowledge of Access with a comprehensive reference guide. This book covers advanced topics and provides in-depth explanations of Access features.

View Access 2016 Bible on Amazon

Show steps

Explore the chapters on advanced query techniques and VBA programming.
Use the book as a reference when tackling complex projects.
Read the sections on database design best practices.

Explore Advanced Query Techniques

Show steps

Deepen your understanding of queries by exploring advanced techniques beyond the course material. This will help you tackle complex exam questions.

Show steps

Find tutorials on using aggregate functions (SUM, AVG, COUNT).
Learn about subqueries and correlated subqueries.
Practice creating parameter queries and action queries.

Design a Database for a Small Business

Show steps

Apply your Access skills to a real-world scenario by designing a database for a small business. This will test your ability to integrate different Access features and solve practical problems.

Show steps

Identify the business requirements and data needs.
Design the database schema (tables, fields, relationships).
Create forms for data entry and reports for data analysis.
Implement queries to retrieve and manipulate data.

Career center

Learners who complete MOS Access 2016 Microsoft Certification Exam 77-730 will develop knowledge and skills that may be useful to these careers:

Database Administrator

A database administrator utilizes database management software to organize and store data. This course, with its focus on Microsoft Access, a common database tool, helps build a foundation in fundamental database operations. The course covers essential skills needed by a database administrator, including creating databases, building tables, constructing queries, and producing reports. These specific skills enable a database administrator to effectively manage and manipulate data, which is crucial for data integrity and efficient access. Someone who wants to become a database administrator may find this course to be particularly useful.

See salaries and explore the career path for Database Administrator

Database Assistant

A database assistant performs various support tasks related to database management. The course work introduces essential skills in database operations using Microsoft Access, which might enable someone to succeed as a database assistant. This course covers how to create and manage databases, and how create tables, queries, and reports, which are essential for managing data. The course’s focus on practical application can help a database assistant manage, organize, and manipulate data efficiently and effectively.

See salaries and explore the career path for Database Assistant

Report Developer

A report developer designs, builds, and maintains reports that communicate data insights and findings. This course provides hands-on experience in creating reports using Microsoft Access, a key skill for report development. The course covers the creation of various report types, giving a report developer the practical skills to present data effectively on reports. The course work with creating forms, queries, and tables, helps a report developer understand how to best visualize information for different audiences and purposes. This course may be useful to someone beginning in the field of report development.

See salaries and explore the career path for Report Developer

Data Manager

A data manager oversees the collection, storage, organization, and security of an organization's data. This course may be useful because it offers a practical learning experience with Microsoft Access, a tool that is often used in this role. The course covers creating and managing databases, building tables, generating queries, and producing reports, all of which help a data manager to organize and manage data effectively and securely. The assignments and project based approach help build a foundation that may be helpful to someone who wants to become a data manager.

See salaries and explore the career path for Data Manager

Business Intelligence Analyst

A business intelligence analyst uses data to identify trends and inform strategic business decisions. This course may be useful for an aspiring business intelligence analyst, as it provides practical, hands-on experience in data management using Microsoft Access. The course dives into creating queries, forms, and reports, all of which are relevant to transforming data into meaningful insights. The project based approach of the course may enable a business intelligence analyst to understand data structure, storage, and retrieval, skills essential for leveraging data to drive business growth.

See salaries and explore the career path for Business Intelligence Analyst

Data Analyst

A data analyst interprets and organizes data to identify trends and insights. This course may be helpful for an aspiring data analyst, because it provides a practical introduction to database management using Microsoft Access. The course's curriculum teaches how to create queries, which allows a data analyst to pull specific data needed for analysis. This helps the data analyst extract and transform data for further exploration and reporting. Furthermore, the course's projects provide real world application of these skills, which helps build confidence in the skills needed for the job of a data analyst.

See salaries and explore the career path for Data Analyst

Information Analyst

An information analyst collects, interprets, and presents data to support decision making within an organization. This course may be useful as it offers practical training in data management using Microsoft Access. The course focuses on creating and managing databases, building tables, writing queries, and generating reports, all of which are essential skills for an information analyst. The multiple assignments in the course may help an information analyst to understand how to find, access, and use data to provide useful insights.

See salaries and explore the career path for Information Analyst

Data Entry Clerk

A data entry clerk inputs information into databases and systems accurately and efficiently. This course may be helpful because it helps to build a foundation in key database operations through practice with Microsoft Access. The course provides hands-on experience on the practical, technical functions used in data work, which builds the skills needed for a data entry clerk. This course may be particularly useful because it focuses on the use of forms and tables, which are fundamental for the job of a data entry clerk.

See salaries and explore the career path for Data Entry Clerk

Information Systems Specialist

An information systems specialist manages and maintains an organization's computer systems and networks. This course may be helpful because the course focuses on key database management tasks, such as creating and managing databases, building tables, creating queries, and generating reports, using Microsoft Access. These skills enable the information systems specialist to work with databases to store, organize, and retrieve data. This course may be helpful because it provides the practical skills and knowledge needed to maintain the integrity and security of data systems.

See salaries and explore the career path for Information Systems Specialist

Records Manager

A records manager oversees an organization's records and information systems, ensuring that they are accurate, secure, and accessible. This course, with its focus on database management tasks like creating, managing, and querying databases, helps build the foundational technical skills needed by a records manager. The ability to build tables and create reports, as taught in the course, is particularly helpful for organizing and presenting data. For someone wishing to become a records manager, this course may be useful due to its practical, hands-on approach to database management.

See salaries and explore the career path for Records Manager

Research Assistant

A research assistant helps with data collection, organization, and analysis for research projects. This course, with its focus on database management using Microsoft Access, provides technical skills needed for a research assistant. Specifically, the course covers the creation of databases, building tables, constructing queries, and producing reports, all of which are useful for managing research data. The practical application of these skills makes this course may be useful to a research assistant who works with research data sets.

See salaries and explore the career path for Research Assistant

Business Systems Analyst

A business systems analyst analyzes and improves business processes by leveraging information technology. This course provides a practical introduction to database management using Microsoft Access, which may prove beneficial to a business systems analyst. With the focus on how to create and manage databases, build tables, construct queries, and produce reports, the course may enable the business systems analyst to understand data storage, retrieval, and manipulation. The course's hands-on projects also may help the business systems analyst learn to analyze data to drive efficiency and solve business challenges.

See salaries and explore the career path for Business Systems Analyst

Technical Support Specialist

A technical support specialist provides assistance to users experiencing issues with software or systems. This course may be useful to those wishing to become a technical support specialist, as it helps them become acquainted with Microsoft Access. The course's assignments provide experience in building tables, creating queries, and generating reports, which are relevant tasks for understanding how software functions. This understanding helps the technical support specialist to diagnose and resolve database related issues. It may also help them communicate effectively with end users about database related challenges.

See salaries and explore the career path for Technical Support Specialist

Project Coordinator

A project coordinator supports project managers by helping to manage tasks, resources, and timelines. The course includes multiple project assignments that provide practical experience working with databases in a project setting. The course also offers guidance on creating and managing databases, building tables, crafting queries, and generating reports using Microsoft Access. These skills enable the project coordinator to manage project data. This course also may be helpful to someone who wants to become a project coordinator.

See salaries and explore the career path for Project Coordinator

Technical Writer

A technical writer creates documentation for software, hardware, or other technical products. This course may be useful to a technical writer who needs to document database related products, or who wants a better understanding of database management. Through the use of Microsoft Access, the course teaches how to build tables, create queries, and generate reports. This course may help a technical writer learn the jargon and concepts needed to document database systems and processes.

See salaries and explore the career path for Technical Writer

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in MOS Access 2016 Microsoft Certification Exam 77-730.

Microsoft Office Professional 2010 Step by Step

Save

Provides a hands-on, step-by-step approach to learning Microsoft Access 2016. It covers all the essential topics, from creating databases to building forms and reports. This book is particularly useful for beginners who want a practical guide to Access. It can be used as a reference during the course or as additional reading to reinforce learning.

Microsoft Office Professional 2010 Step by Step

Kindle Edition

Access 2016 Bible

Save

The Access 2016 Bible comprehensive reference guide for advanced Access users. It covers a wide range of topics, including VBA programming, database design, and data analysis. is more valuable as additional reading for those who want to delve deeper into Access. It is commonly used by industry professionals and advanced students.

MOS Access 2016 Microsoft Certification Exam 77-730

What's inside

Learning objective

Syllabus

Traffic lights

Save this course

Reviews summary

Mos access 2016 certification exam prep

Activities

Career center

Reading list

Share

Similar courses