MO-500 Microsoft Access Expert Certification

Focused View

Dave Murphy

8:36:16

124 View

Chapter 1 Introduction

001. Course Introduction and Structure.mp4

05:20

Chapter 2 Modify Database Structure

001. Import Objects or Data from Other Sources.mp4

05:34

002. Delete Database Objects.mp4

03:27

003. Hide and Display Objects in the Navigation Pane.mp4

03:41

Chapter 3 Manage Table Relationships and Keys

001. (Part 1) Understand Relationships.mp4

08:08

002. (Part 2) Understand Relationships.mp4

08:20

003. (Part 3) Understand Relationships.mp4

08:41

004. (Part 4) Understand Relationships.mp4

09:02

005. Display Relationships.mp4

02:46

006. Set the Primary Key.mp4

04:57

007. Enforce Referential Integrity.mp4

01:18

008. Set Foreign Keys.mp4

02:51

Chapter 4 Print and Export Data

001. Configure Print Options for Records, Forms, and Reports.mp4

05:09

002. Export Objects in Alternative Formats.mp4

04:54

Chapter 5 Objective Domain 1 Exercises and Solutions

001. Objective Domain 1 Exercises and Solutions.mp4

20:26

Chapter 6 Create Tables

001. Import Data into Tables.mp4

05:15

002. Create linked tables from external sources.mp4

04:51

003. Import tables from other databases.mp4

01:49

Chapter 7 Manage Tables

001. Hide Fields in Tables.mp4

02:50

002. Add Total Rows.mp4

01:23

003. Add Table Descriptions.mp4

01:43

Chapter 8 Manage Table Records

001. Find and Replace Data.mp4

01:47

002. Sort Records.mp4

02:32

003. Filter Records.mp4

05:03

Chapter 9 Create and Modify Fields

001. (Part 1) Add and Remove Fields.mp4

04:04

002. (Part 2) Add and Remove Fields.mp4

03:32

003. Add Validation Rules to Fields.mp4

08:54

004. Change Field Captions.mp4

02:31

005. Change Field Sizes and Data Types.mp4

04:12

006. Configure Auto Increment and Set Default Values.mp4

03:39

007. Apply Built-In Input Masks.mp4

10:35

Chapter 10 Objective Domain 2 Exercises and Solutions

001. Objective Domain 2 Exercise Solutions.mp4

25:13

Chapter 11 Create and Run Queries

001. Create Simple Queries.mp4

06:04

002. Create Basic Crosstab Queries.mp4

04:08

003. Create Basic Parameter Queries.mp4

09:06

004. (Part 1) Create Basic Action Queries.mp4

07:36

005. (Part 2) Create Basic Action Queries.mp4

02:24

006. (Part 3) Create Basic Action Queries.mp4

05:31

007. (Part 4) Create Basic Action Queries.mp4

05:21

008. Create Basic Multi-Table Queries.mp4

11:59

009. Save Queries.mp4

02:47

010. Run Queries.mp4

02:20

Chapter 12 Modify Queries

001. Add, Hide, and Remove Fields, Sort and Filter Data.mp4

09:16

002. Filter Data Within Queries.mp4

05:44

Chapter 13 Objective Domain 3 Exercises and Solutions

001. Objective Domain 3 Exercises and Solutions.mp4

37:19

Chapter 14 Configure Form Controls

001. Introduction to Forms.mp4

06:21

002. (Part 1) Add, Move, and Remove Form Controls.mp4

10:08

003. (Part 2) Add, Move, and Remove Form Controls.mp4

07:55

004. (Part 3) Add, Move, and Remove Form Controls.mp4

12:46

005. (Part 4) Add, Move, and Remove Form Controls.mp4

06:15

006. (Part 5) Add, Move, and Remove Form Controls.mp4

07:19

007. Add and Modify Form Labels.mp4

02:11

Chapter 15 Format Forms

001. Modify Tab Order on Forms.mp4

02:29

002. Sort Records by Form Field.mp4

02:34

003. Modify Form Positioning.mp4

03:59

004. Insert Information in Form Headers and Footers.mp4

03:59

005. Insert Images on Forms.mp4

01:29

Chapter 16 Objective Domain 4 Exercises and Solutions

001. Objective Domain 4 Exercises and Solutions.mp4

23:35

Chapter 17 Configure Report Controls

001. Introduction to Access Reports.mp4

02:29

002. Group and Sort Fields on Reports.mp4

04:43

003. Add and Modify Report Controls and Labels.mp4

08:18

Chapter 18 Format Reports

001. Format a Report into Multiple Columns.mp4

04:26

002. Modify Report Positioning.mp4

01:34

003. Format Report Elements.mp4

09:09

004. Change Report Orientation.mp4

03:26

005. Insert Information in Report Headers and Footers.mp4

02:32

006. Insert Images on Reports.mp4

02:13

Chapter 19 Objective Domain 5 Exercises and Solutions

001. Objective Domain 5 Exercises and Solutions.mp4

14:01

Chapter 20 Sample Exam

001. Sample Exam Project 1.mp4

03:32

002. Sample Exam Project 2.mp4

03:17

003. Sample Exam Project 3.mp4

05:09

004. Sample Exam Project 4.mp4

03:06

005. Sample Exam Project 5.mp4

02:04

006. Sample Exam Project 6.mp4

03:38

Chapter 21 Associate Access 77-730 Optional Lectures

001. Create a Blank Desktop Database.mp4

05:02

002. Create a Database from a Template.mp4

02:41

003. Compact and Repair a Database.mp4

02:37

004. Back Up a Database.mp4

02:26

005. Split a Database.mp4

06:01

006. Encrypt a Database with a Password.mp4

03:19

007. Recover Data from Backup.mp4

02:38

008. Create a Table.mp4

09:25

009. Create a Form.mp4

11:33

010. Create a Form from a Template with Application Parts.mp4

05:00

011. Create a Report Based on the Query or Table and in Design View.mp4

04:18

012. Create a Report Using the Report Wizard.mp4

02:37

Description

Complete Techniques for the MO-500 Microsoft Access Expert Certification Exam

What You'll Learn?

Become expert in all of the techniques specified for the Microsoft Access Expert MO-500 Certification Exam
Learn how best to prepare to take the MO-500 exam
Be familiar with the standard and format of the MO-500 exam by using our Sample Certification Exam
Understand the requirements for Expert Certification

Who is this for?

All students who wish to obtain the Microsoft Access MO-500 Expert Certification.

No prior knowledge is assumed. Suitable for students at all levels.

Commit to completion of the course exercises and sample exam.

What You Need to Know?

Copy of Microsoft Access 2016 or Microsoft Access 365/2019

Suitable for beginners

More details

Description
This course will prepare you to successfully pass the MO-500 Microsoft Access Expert certification exam. The MO-500Â is the only exam officially recognised by Microsoft for Access 365 Apps and Access 2019. 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.
The course is designed to ensure that you are familiar with all of the techniques specified by Microsoft for the MO-500 Objective Domain (Syllabus). Every aspect of the requirements specified by Microsoft is comprehensively covered using video lectures together with appropriate exercises designed to ensure your understanding of the database techniques covered in each of the lectures.
The exercises have been designed so that when you take the actual exam you will be fully prepared for the standard and style of the projects and tasks set by Microsoft.
When you take and successfully pass the MO-500 exam your skills in the use of Microsoft Access will have been independently proven. Your CV will, as a result, be significantly enhanced as this qualification will make you a valuable asset to any organisation.
Who this course is for:
All students who wish to obtain the Microsoft Access MO-500 Expert Certification.
No prior knowledge is assumed. Suitable for students at all levels.
Commit to completion of the course exercises and sample exam.

User Reviews

Rating

average 0

Total votes0

Focused display

With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in Business Information Systems with the Technological University Dublin. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a Bachelor in Science degree (Hons) from Trinity College Dublin and a Masters Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.