Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

77-730: Microsoft Access - from beginner to Specialist

via Udemy

Overview

Learn what Microsoft want you to know for their database certification.

What you'll learn:
  • Create and manage a database
  • Build tables
  • Create queries
  • Create forms
  • Create reports

All the training you need to take (and hopefully)pass your Microsoft Office Specialist exam - and one step towards the Master certification.

Most people who use Access areworking at Level1. Why not go all the way to Level 5?

Please note:This course is not affiliated with, endorsed by, or sponsored by Microsoft.


In this course, learn how to:

Create and manage a database, including:

  • Create and modify databases

  • Manage relationships and keys

  • Navigate through a database

  • Protect and maintain databases

  • Print and export data

Build tables, including:

  • Create and managetables,

  • Manage records in tables, and

  • Create and modify fields.

Create queries, including:


  • Create and modify a query,

  • Create calculated fields and grouping within queries

Create forms and reports, including:


  • Create forms and reports,

  • Configure form and report controls, and

  • Format forms and reports.

This course teaches allthe skills that Microsoft want you to know. Specifically, they are the skillsrequired to undertake the Microsoft Certificate 77-605(for Access 2007), 77-885(for Access 2010), 77-424(for Access 2013) and 77-730(for Access 2016 Core)and will be useful if you wish to take the exam, or which to learn more about Microsoft Access

The core skills which are taught are those tested by Microsoft in the exam. There are topicsthatit wants you to learn aboutMicrosoft Access,and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Access , or

  • you want to learn the skills you need tobecome a certified Microsoft Office Specialist.

Regardless whether you have Access 2007, Access 2010, Access 2013, Access 2016 or Office 365, this course will help you get to a good level, and maybe even want you to get more!

Syllabus

  • Introduction
  • Level 1, Section 1: Creating a database
  • Level 1, Section 2: Create tables
  • Level 1, Section 3: Creating forms, reports and queries
  • Level 2, Section 1: Developing tables in the Datasheet view
  • Level 2, Section 2: Developing tables in the design view
  • Level 2, Section 3: Good table design
  • Level 2, Section 4: Manage multiple tables, relationships and keys
  • Level 3, Section 1: Modifying queries and grouping within queries
  • Level 3, Section 2: Create calculated fields and grouping
  • Level 3, Section 3: Create various types of queries
  • Level 4, Section 1: Create and configure forms
  • Level 4, Section 2: Sub-forms and data sources
  • Level 4, Section 3: Format a form
  • Level 5, Section 1: Create reports
  • Level 5, Section 2: Protect and maintain databases
  • The End

Taught by

Phillip Burton • over one million students so far and I Do Data Limited

Reviews

4.5 rating at Udemy based on 86 ratings

Start your review of 77-730: Microsoft Access - from beginner to Specialist

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.