77-730: Microsoft Access - From Beginner To Specialist

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

Requirements

Before beginning, you will need to know how to use a Windows computer, including a mouse.

It would be good if you have used a database or Microsoft Excel before, but this is not essential.

You should have MS Access 2007, 2010, 2013, 2016 or 365 installed on your computer.

Description

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 are working at Level 1. Why not go all the way to Level 5?In this course, learn how to:Create and manage a database, including:Create and modify databasesManage relationships and keysNavigate through a databaseProtect and maintain databasesPrint and export dataBuild tables, including:Create and manage tables,Manage records in tables, andCreate and modify fields.Create queries, including:Create and modify a query,Create calculated fields and grouping within queriesCreate forms and reports, including:Create forms and reports,Configure form and report controls, andFormat forms and reports.This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required 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 topics that it wants you to learn about Microsoft 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 about 8 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 , oryou want to learn the skills you need to become 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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Welcome to Udemy

Lecture 3 Introduction to Udemy

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 Curriculum

Lecture 6 Final Databases

Section 2: Level 1, Section 1: Creating a database

Lecture 7 Opening Microsoft Access, and Creating a blank database

Lecture 8 Let's take a look around

Lecture 9 Opening the Northwind Database

Lecture 10 Create a database from a template

Lecture 11 Practice Activity Number 1

Lecture 12 Practice Activity Number 1 - Solution

Section 3: Level 1, Section 2: Create tables

Lecture 13 Create a table

Lecture 14 Navigating tables

Lecture 15 Copying and pasting data

Lecture 16 Practice Activity Number 2

Lecture 17 Practice Activity Number 2 - Solution

Section 4: Level 1, Section 3: Creating forms, reports and queries

Lecture 18 Create a form

Lecture 19 Other form types

Lecture 20 Create a report based on the table

Lecture 21 Create a report by using a wizard

Lecture 22 Create a query using the Query Design

Lecture 23 Create a query by using a wizard

Lecture 24 Practice Activity Number 3

Lecture 25 Practice Activity Number 3 - Solution

Section 5: Level 2, Section 1: Developing tables in the Datasheet view

Lecture 26 Find and replace data

Lecture 27 Manage records in tables

Lecture 28 Advanced filter

Lecture 29 Managing tables

Lecture 30 Create and modify fields

Lecture 31 Add validation rules

Lecture 32 Practice Activity Number 4

Lecture 33 Practice Activity Number 4 - Solution

Section 6: Level 2, Section 2: Developing tables in the design view

Lecture 34 Introducing the Design View, and changing the number field type

Lecture 35 Using Input Masks

Lecture 36 Primary Keys and Autonumbers

Lecture 37 Using Lookup Values

Lecture 38 Practice Activity Number 5

Lecture 39 Practice Activity Number 5 - Solution

Section 7: Level 2, Section 3: Good table design

Lecture 40 Introducing Normal Forms

Lecture 41 First Normal Form

Lecture 42 Second Normal Form

Lecture 43 Third Normal Form

Section 8: Level 2, Section 4: Manage multiple tables, relationships and keys

Lecture 44 Import data from Excel spreadsheets

Lecture 45 Append data, and link data

Lecture 46 Create relationships between tables

Lecture 47 Enforce referential integrity

Lecture 48 Cascade Update Related Fields

Lecture 49 Cascade Delete Related Records

Lecture 50 Subdatasheets, and miscellaneous relationships options

Lecture 51 Documenting your Database

Lecture 52 Practice Activity Number 6

Lecture 53 Practice Activity Number 6 - Solution

Section 9: Level 3, Section 1: Modifying queries and grouping within queries

Lecture 54 Modifying queries

Lecture 55 Formatting in queries

Lecture 56 Group and summarize data

Lecture 57 Set filtering criteria - Text

Lecture 58 Set filtering criteria on results

Lecture 59 Set filtering criteria on NULLs

Lecture 60 Practice Activity Number 7

Lecture 61 Practice Activity Number 7 - Solution

Section 10: Level 3, Section 2: Create calculated fields and grouping

Lecture 62 Creating our first calculated field

Lecture 63 Date/Time Functions

Lecture 64 Math and Text Functions

Lecture 65 Group Data Using Operators

Lecture 66 Practice Activity Number 8

Lecture 67 Practice Activity Number 8 - Solution

Section 11: Level 3, Section 3: Create various types of queries

Lecture 68 Create a multi-table query

Lecture 69 Searching for missing information

Lecture 70 Create a parameter query

Lecture 71 Create a crosstab query

Lecture 72 Create an action query

Lecture 73 Create an append query

Lecture 74 Practice Activity Number 9

Lecture 75 Practice Activity Number 9 - Solution

Section 12: Level 4, Section 1: Create and configure forms

Lecture 76 Create a report - Recap

Lecture 77 Move form controls

Lecture 78 Add form controls

Lecture 79 Set form control properties - Data, Event and Other tabs

Lecture 80 Set form control properties - Format tab

Lecture 81 Applying table layouts

Lecture 82 Practice Activity Number 10

Lecture 83 Practice Activity Number 10 - Solution

Section 13: Level 4, Section 2: Sub-forms and data sources

Lecture 84 Add sub-forms

Lecture 85 Modify data sources

Lecture 86 Create a form from a template with application parts

Lecture 87 Create Navigation forms

Section 14: Level 4, Section 3: Format a form

Lecture 88 Modify tab order in forms

Lecture 89 Insert headers and footers

Lecture 90 Themes, sorting and print settings

Section 15: Level 5, Section 1: Create reports

Lecture 91 You already know how to do this!

Lecture 92 Practice Activity Number 11

Lecture 93 Practice Activity Number 11 - Solution

Lecture 94 Group and Sort fields

Section 16: Level 5, Section 2: Protect and maintain databases

Lecture 95 Protect and maintain databases

Lecture 96 Print and export data

Section 17: The End

Lecture 97 Thank you very much

Lecture 98 Bonus Lecture

This course is for you if you want to develop your Microsoft Access skills.,This course will use the latest version of Access, but is ideal for you if you use any modern version - Access 2007, 2010, 2013, 2016 or 365.,This course is also for you if you use an older version of Microsoft Access, but want to learn the newer versions.,This course is for you if you want to become certified in Microsoft Access, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.,You will cover the content tested in Microsoft Office Specialist Exams 77-605 (for Access 2007), 77-885 (for Access 2010), 77-424 (for Access 2013) and 77-730 (for Access 2016 Core),This course may not be for you if you want to learn Microsoft Access for Macintosh computers, or if you already have advanced knowledge of Access.