OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udemy logo

77-730 Microsoft Access Certification

4.7 Filled star Filled star Filled star Filled star Half star
Based on 22 ratings
see reviews
Dave Murphy

This course will prepare you to successfully pass the 77-730 Microsoft Access certification exam. The 77-730 is the only exam officially recognised by Microsoft for Access 2016. Every aspect of the exam is covered in detail, together with exercises and solutions. Delivered by a University professor with many years experience in teaching databases to undergraduate students, and who is also a Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will enhance your chances of obtaining this extremely valuable qualification. Prove your database skills by obtaining independent certification from Microsoft.

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Only 6 hours left!
24-Hour Flash Sale
Close your skills gaps with online courses and save big for a limited time.
Up to
85%
off
Get offer

What's inside

Learning objectives

  • All techniques for the microsoft access 77-730 certification exam
  • How to prepare for the exam
  • Be ready to pass the 77-730

Syllabus

Introduction
Course Introduction and Structure
1.1 Create and Modify Databases
1.1.1 Create a blank desktop database
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Prepares learners to pass the Microsoft Access 77-730 certification exam, which validates database skills and enhances career prospects
Delivered by a university professor with experience teaching databases and as a Microsoft Office Specialist examiner
Covers every aspect of the exam in detail, which ensures comprehensive preparation and understanding of the required skills
Includes exercises and solutions, which allows learners to practice and reinforce their understanding of the material
Focuses on Access 2016, which may not be the latest version, so learners should consider if this aligns with their needs

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Comprehensive microsoft access 2016 exam prep

According to students, this course offers comprehensive preparation for the Microsoft Access 77-730 certification exam, covering all necessary topics outlined in the syllabus. Learners appreciate the structure and depth, finding it effective for understanding key Access features from database creation to queries and forms. While the course focuses specifically on Access 2016 (as required by the exam), some reviewers note this might feel slightly dated compared to newer versions. Overall, students find the material clear and the exercises helpful, contributing to their readiness for the certification test.
Focused specifically on the 2016 version for the exam.
"Be aware this course is strictly for Access 2016, which is necessary for the 77-730 exam."
"It's great for passing the specific 2016 certification, but the interface feels older if you're used to newer versions."
"This course is tailored precisely to the Access 2016 exam objectives, so don't expect coverage of newer features."
Practical exercises aid understanding and application.
"The exercises provided were essential for practicing and reinforcing what I learned."
"Watching the demos helped me visualize the steps required in Access."
"Working through the practical examples solidified my understanding much more than just theory."
The course is well-organized and easy to follow.
"The lectures are presented in a clear, logical manner, breaking down complex topics."
"The structure of the course, module by module, made learning very manageable."
"I found the explanations very clear and easy to understand, even for difficult database concepts."
All 77-730 exam topics are thoroughly covered.
"This course covers exactly what you need to know for the 77-730 Access exam. Every objective is addressed."
"The syllabus follows the official exam topics perfectly, making it a great study guide."
"I felt well-prepared for the certification after going through all the modules aligned with the exam requirements."
May be challenging for absolute beginners.
"While it covers the exam, having some basic familiarity with Access helps immensely before starting."
"Some parts move quite quickly; beginners might need supplementary material or pause frequently."
"I recommend knowing the very basics of databases before diving into this exam-focused course."

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 77-730 Microsoft Access Certification with these activities:
Review Database Concepts
Solidify your understanding of core database concepts before diving into Access-specific features.
Browse courses on Database Normalization
Show steps
  • Review the principles of relational databases.
  • Practice creating ER diagrams for simple scenarios.
  • Familiarize yourself with SQL syntax for basic queries.
Review: Microsoft Access 2016 Step by Step
Supplement your learning with a comprehensive guide to Access 2016.
View Microsoft Office Professional 2010 Step by Step on Amazon
Show steps
  • Read the chapters relevant to the course syllabus.
  • Complete the exercises and practice activities.
  • Use the book as a reference when working on projects.
Practice Creating Relationships
Reinforce your ability to create and modify relationships between tables, a crucial skill for Access.
Show steps
  • Create several databases with different relationship types.
  • Practice enforcing referential integrity and setting foreign keys.
  • Experiment with different relationship options.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Review: Access 2016 Bible
Expand your knowledge with an in-depth exploration of Access features and techniques.
View Access 2016 Bible on Amazon
Show steps
  • Browse the chapters on topics you find challenging.
  • Explore the VBA programming sections for advanced customization.
  • Use the book to troubleshoot problems and find solutions.
Explore Advanced Query Techniques
Deepen your knowledge of Access queries by following tutorials on advanced techniques like subqueries and aggregate functions.
Show steps
  • Find tutorials on creating subqueries in Access.
  • Practice using aggregate functions like SUM, AVG, and COUNT.
  • Experiment with different query types.
Document a Database Design
Improve your understanding of database design by documenting the structure and relationships of an existing database.
Show steps
  • Choose a database with multiple tables and relationships.
  • Create an ER diagram representing the database structure.
  • Document the purpose of each table and field.
  • Explain the relationships between tables.
Build a Simple Application
Apply your Access skills by building a small application, such as a contact manager or inventory tracker.
Show steps
  • Define the requirements for your application.
  • Design the database schema with appropriate tables and relationships.
  • Create forms for data entry and display.
  • Implement queries to retrieve and manipulate data.

Career center

Learners who complete 77-730 Microsoft Access Certification will develop knowledge and skills that may be useful to these careers:
Database Administrator
A database administrator is responsible for the performance, integrity, and security of a database. This role involves creating, modifying, and maintaining databases, and this course can help someone build the foundation needed to perform those tasks using Microsoft Access. The course covers creating databases, managing relationships, and ensuring data integrity, all of which are crucial for a database administrator. A background in Microsoft Access, as provided by this course, could be a valuable asset in maintaining databases and troubleshooting database issues. This course covers the creation of database objects, such as tables and queries, which are essential aspects of database administration.
See salaries and explore the career path for Database Administrator
Data Analyst
Data analysts examine data to draw conclusions and make recommendations. This course can help a data analyst understand how data is structured and managed through Microsoft Access. This course is particularly helpful because it covers the creation of queries, grouping and summarizing data, and filtering records, which are all very common tasks for a data analyst. Understanding how to manage and manipulate databases in Access is often helpful for a data analyst as you may need to access existing databases, and create new ones for your team. The course also covers how to export data, which is useful in further analysis with other tools.
See salaries and explore the career path for Data Analyst
Data Entry Specialist
A data entry specialist enters and updates data into databases and computer systems. This course is useful for a data entry specialist as it teaches the fundamentals of database management within Microsoft Access. The course covers how to add, update, and delete records, as well as how to find, filter, and sort through data. The course also teaches how to create and manage fields in tables and how to enforce data validation rules, which are all skills useful for a data entry specialist. The course covers working with forms, which are a common interface used in data entry.
See salaries and explore the career path for Data Entry Specialist
Records Manager
A records manager maintains and organizes records, ensuring that they are accurate and accessible. This course is useful for a records manager, as it covers using Microsoft Access to create and manage databases. The course covers how to create tables, manage relationships, and ensure data integrity, which are essential functions for a records manager. The course also discusses database maintenance and security. This course can help you ensure the files are well structured and easy to access.
See salaries and explore the career path for Records Manager
Database Consultant
A database consultant provides expert advice and solutions for data management tasks. This course may be useful for a database consultant, as it provides hands-on experience with Microsoft Access. A database consultant may be called to help with database creation, data management, database queries, and user interface development, all covered by this course. The course teaches how to create tables, manage relationships, create queries, generate reports, and secure databases. The ability to show you can pass the Microsoft Access certification exam is of obvious value, as well.
See salaries and explore the career path for Database Consultant
Report Developer
A report developer works to create and maintain reports for various business needs. This course may be useful for a report developer by showing how to create forms and reports in Microsoft Access. The course covers techniques for formatting reports, using queries to extract data, and presenting data in a user-friendly format. A background in database management, as provided by the course, may be helpful to a report developer. The course has an objective of printing and exporting data, which is an essential function of report development.
See salaries and explore the career path for Report Developer
Information Systems Manager
An information systems manager plans, directs, and coordinates computer-related activities within an organization. This course may be useful for an information systems manager because it introduces the concepts of database management through Microsoft Access. Proficiency with tools like Access can be useful to manage data systems and ensure data integrity. The course covers database design, which includes creating tables, setting relationships, and managing data. This course may be useful as it familiarizes one with the structure, functionality, and security aspects of data management, which are important for an information systems manager.
See salaries and explore the career path for Information Systems Manager
Business Intelligence Analyst
A business intelligence analyst uses data to help organizations make better business decisions. This course may be useful for a business intelligence analyst by teaching how to work with databases via Microsoft Access. The course covers creating queries, generating reports, and managing database relationships, all skills that are invaluable for a business intelligence analyst. Experience with database management, as provided by the course, could help one perform data extraction, transformation, and loading, which are essential components of business intelligence. This course covers the creation of forms and reports, which are techniques used for visualizing data.
See salaries and explore the career path for Business Intelligence Analyst
Small Business Owner
A small business owner manages the day-to-day operations of their business. This course may be useful for a small business owner as it provides a practical basis for database management with Microsoft Access. The course covers creating, modifying, and managing databases, which are important for tasks such as tracking inventory, customer information, and sales data. This course also focuses on creating queries, which may be useful to manage business intelligence. The course may be useful in helping manage information for many different business needs.
See salaries and explore the career path for Small Business Owner
Office Manager
An office manager is responsible for overseeing administrative tasks in an office environment. This course may be useful for an office manager, as it introduces the concepts of database management using Microsoft Access. The course provides a foundation in database management, which can be helpful for managing office data and files. The course covers creating tables, managing records, and generating reports in Access. An office manager is often called upon to manage data, so this course provides vital skills.
See salaries and explore the career path for Office Manager
Research Assistant
A research assistant helps with academic or scientific research, often involving data collection and analysis. This course may be useful for a research assistant because it teaches database management with Microsoft Access. The course covers creating tables, managing data, and running queries. This course may be useful for data organization and preparing data sets for further analysis, as well as creating data entry forms. The skills gained in this course can help in managing data and ensuring the integrity of research data.
See salaries and explore the career path for Research Assistant
Academic Tutor
An academic tutor provides instruction to students on a given subject. This may be useful for an academic tutor because it provides a background in Microsoft Access. The course may be useful for an academic tutor who needs to teach material on databases to students. The certification this course helps prepare for is ideal for ensuring the tutor can teach the material. The course goes into technical detail about access, and may be useful for preparing for lessons.
See salaries and explore the career path for Academic Tutor
Project Coordinator
A project coordinator helps organize and manage projects. This course may be useful for a project coordinator as it teaches database management using Microsoft Access. This can be useful for project tracking and management. The course covers creating tables, managing relationships, and creating forms and reports, all of which are helpful for organizing information. Learning to manipulate and manage data in the course can help a project coordinator track task completion and resource management.
See salaries and explore the career path for Project Coordinator
Financial Analyst
A financial analyst analyzes financial data to make recommendations to a company. This course is useful for a financial analyst because it teaches how to manage data through Microsoft Access. The course covers the creation of queries, which can help analyze financial data and how to import data into databases. The course also covers data management, which is useful to a financial analyst who often works with large datasets. The course covers printing and exporting data, which is useful to present data in reports.
See salaries and explore the career path for Financial Analyst
Technical Writer
A technical writer creates documentation for software. This course may be useful for a technical writer because it teaches the details of how Microsoft Access functions. Learning how to use a software thoroughly is a requirement for writing detailed and helpful user manuals. The course covers creating and modifying databases, including forms and reports. A technical writer may need to understand how a piece of software works before being able to write about it. The skills learned in this course are specific and practical, aiding a technical writer in documentation tasks.
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 77-730 Microsoft Access Certification.
Cover image
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 features and functions of Access, including creating databases, tables, forms, queries, and reports. It useful reference tool for beginners and intermediate users alike. This book is commonly used as a textbook at academic institutions.
Microsoft Office Professional 2010 Step by Step
Kindle Edition
$$
Cover image
Access 2016 Bible
Save
The Access 2016 Bible comprehensive guide to all things Access. It covers everything from basic database design to advanced VBA programming. is more valuable as additional reading than it is as a current reference. It provides a deeper understanding of the underlying principles of Access and how to use it effectively. It is commonly used by industry professionals.
Access 2016 Bible
Paperback
$$
Access 2016 Bible
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to 77-730 Microsoft Access Certification.
The Complete Guide for SQL with Microsoft SQL Server
Most relevant
Generative AI for Web Developers
Most relevant
Amazon RDS Service Primer
Most relevant
SQL Server Course for Beginners with 100+ examples
Most relevant
Getting Started with Amazon RDS for MariaDB
Most relevant
Manage Data for an Online Grocer Using MySQL Workbench
Most relevant
Geospatial Information Technology Essentials
Most relevant
Tools of the Trade: Linux and SQL
Most relevant
Data Connection and Functionalities in Power BI
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
4.7 Filled star Filled star Filled star Filled star Half star
Effort
9.5 total hours
Via
Udemy
Instructor
Dave Murphy
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Prepares learners to pass the Microsoft Access 77-730 certification exam, which validates database skills and enhances career prospects
Delivered by a university professor with experience teaching databases and as a Microsoft Office Specialist examiner
Covers every aspect of the exam in detail, which ensures comprehensive preparation and understanding of the required skills
Includes exercises and solutions, which allows learners to practice and reinforce their understanding of the material
Focuses on Access 2016, which may not be the latest version, so learners should consider if this aligns with their needs
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to 77-730 Microsoft Access Certification.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser