Master Microsoft Access - Access from Beginner to Advanced
4.5 (507 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,116 students enrolled

Master Microsoft Access - Access from Beginner to Advanced

Develop dynamic Access databases fast in this easy to learn Microsoft Access Course (2010, 2013, 2016, 2019 & 365)
4.5 (504 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,116 students enrolled
Created by Kirt Kershaw
Last updated 5/2020
English
English [Auto-generated]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 17 hours on-demand video
  • 1 article
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Build a solid understanding on the Basics of Microsoft Access
  • How to create an Access Database from scratch
  • Master Microsoft Access from Beginner to Advanced
  • Create Tables to store and organize all raw data
  • Use a Query to search and retrieve data fast
  • Enter and view records in a more organized layout using Forms
  • Generate very detailed, professional looking Reports
  • Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 18 years of Access training
Requirements
  • This course was created with Access 2016. But, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007
  • You will need Microsoft Access installed on your computer to follow along and complete the exercise files
Description

Microsoft Access All-In-One Training   

This Microsoft Access course includes all three Levels from Beginner to Advanced   

  • Microsoft Access Level 1 – Beginner   

  • Microsoft Access Level 2 – Intermediate   

  • Microsoft Access Level 3 – Advanced   

Material recorded with Access 2016 but works in 2010, 2013, 2016, 2019 and 365.

As your instructor I will use my 18+ years of Access training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Access.    

At completion of this course you will master Access skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass the Access 2016 (77-730) Exam and become certified, like me.  Below are just a few of the topics that you will master:   

  • Create powerful, effective Access Databases   

  • Enter, edit, update, search, sort and filter Table records   

  • Set defaults and validate data for more accurate data entry   

  • How to quickly edit, filter and search records in a Form   

  • Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms   

  • Add custom fields to perform calculations: Sum, Count, Average and more   

  • Add, sort and filter groups as well as keeping them from splitting across pages in your Reports   

  • Use criteria in a Query to dramatically refine your search   

  • View unique records and use Actions Queries to Update, Add and Delete records fast   

  • Automate data entry and accuracy dramatically by creating Macros and much more…   

Who this course is for:
  • This Microsoft Access course contains all three levels of learning for the: Beginner, Intermediate and Advanced users
  • Includes all the training you need to help you pass the Access 2016 (77-730) Exam and become certified
Course content
Expand all 135 lectures 17:00:33
+ Access 2016 Introduction
1 lecture 13:20
Access 2016 training video on the basic introduction to Access 2016 as a relational database, or a database that breaks the data down into its smallest most meaning parts, or tables and then links those tables in a relationship to pull data as needed, and thereby making process more efficient for both user and computer.
Preview 13:20
+ Access 2016 Level 1 - Beginner
1 lecture 05:58
  1. Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  2. Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  3. Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
Exercise Files, Instructor's Notes, Quiz & Answers
05:58
+ Basics
9 lectures 01:05:38

Access 2016 training video on the basic overview of the application itself including: startup screen, Ribbon, Navigation pane, working area, Status Bar and more!

Preview 13:34

Access 2016 training video on the new Tell Me What You Want that is part of the Help feature, and is used to find answers to questions about features in Access, as well as execute commands.

Preview 01:48

Access 2016 training video on how to change the Office Theme which is basically the color scheme of the application's layout, as well as default database folder, setting User name and Initials.

Preview 04:40

Access tutorial on how to customize the Quick Access Toolbar by adding commands in numerous ways, and how to remove them as well as you'll see in this Access training video.

Preview 07:02

Access 2016 training video on how to customize the Ribbon including adding and removing tabs, commands and groups.

Preview 09:01
Access 2016 training video on how to customize the Datasheet's appearance including it's font size.
Preview 01:46

Access 2016 training video on the three Document Window Options which is  how you want the Access working windows to operate including:  Overlapping Windows, Tabbed Documents and Display Document Tabs.

Preview 07:25
Access 2016 training video on the basics of the four major objects in Access including: Table, Query, Form and Report.
Preview 13:41

Access 2016 training video on how to create a new database file for your tables, queries, forms and reports.

Preview 06:41
Basics Quiz
9 questions
+ Tables
14 lectures 02:34:34

Access 2016 training video on how to create a table that is used to store raw data, and which queries, forms and reports are built upon.

Creating Tables
23:18
Access 2016 training video on how to enter in records in a table efficiently with some tips, tricks and shortcuts.
Entering Records in Tables
04:35

Access 2016 training video on how to export a table to XPS, or PDF file
format to send to someone who doesn't have Access on their computer, or as a quick snapshot of a table.

Export Table to XPS or PDF
03:31

Access 2016 training video on table structuring in a way that allows you
to create relationships between tables from a poorly designed database.

Table Structuring
09:31

Access 2016 training video on tips for managing your tables including:
deleting, renaming and hiding tables, table descriptions, and object
groups.

Tips for Managing Tables
05:25

Access 2016 training video basics on creating Primary, Composite and Foreign keys, as well as how and when to use them in your tables, prior to creating relationships between two or more tables.

Basics on Primary, Composite & Foreign Keys
13:51
Access 2016 training video on how to setup up tables to relate to one another by creating Primary and Foreign key fields.
Basic Introduction Setting Up Tables for Relationships
07:35

Access 2016 training video on how to create a One-to-Many relationship between two tables, where you can have basically one record linked to many other records like: one customer that has many orders. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records.

Create One-to-Many Relationships
17:48

Access 2016 training video on how to create a One-to-One relationship between two tables, where you can have basically one record linked to one other record like: one client that has one billing contact for that client. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records.

Create One-to-One Relationships
13:29

Access 2016 training video on denormalizing an a table, or breaking tables down into smaller, more meaningful parts i.e. tables. For example, a poorly designed database would have all the information like: clients, customers, orders, shipping, products loaded into one table, instead of one table for each meaningful part.

Denormalization or Denormalize
13:32

Access 2016 training video on how to manage your table's data including how to: enter, modify, update and delete records.

Managing Table Data
15:03
Access 2016 training video on how to sort your table's records.
Sorting Records
05:10
Access 2016 training video on how to filter your table's records.
Filtering Records
10:03

Access 2016 training video on subdatasheets which are datasheets nested within datasheets, or like tables within tables, but that are related. In other words, it's the ability to look up related data in another table without leaving your current table's datasheet view.

Subdatasheets
11:43
Tables Quiz
17 questions
+ Queries
6 lectures 01:12:02

Access 2016 training video on how to create a query by using the Query Wizard, which is a step by step process where Access asks you questions and based upon your answers creates your query!

Query Wizard
19:22

Access 2016 training video on how to create a query by Design, or in the design view including adding: tables and fields from those tables to the query.

Basics on Creating a Query in Design View
12:15
Access 2016 training video on how to set criteria for your query including: text, numbers, dates, blank, empty fields.
Setting Query Criteria
20:58
Access 2016 training video on how to create a field that performs a calculation on other fields using functions, or formulas.
Add a Calculating Field
07:33
Access 2016 training video on how to group your records, and add a calculation to that group by using the Totals feature.
Grouping Records & Totals
08:15

Access 2016 training video on how to customize your table's or query's datasheet including: banded rows, alternating colors, font types, cell effects and more!

Customize Table or Query Datasheet
03:39
Queries Quiz
6 questions
+ Forms
4 lectures 51:35
Access 2016 training video on the basic introduction to a Form, and includes how to sort and filter records in a form.
Basic Introduction to Forms
18:42

Access 2016 training video on how to create a Form instantly! Also, I'll show you here how to edit your Instant Forms including working with stacked and tabular layouts, and how to remove them as well.

Create Forms Instantly
12:06
Access 2016 training video on how to use the Form Wizard to create a Form quickly for your database.
Form Wizard
05:58

Microsoft Access 2016 training video on how to edit and modify the database's Forms in the Design View including: moving, aligning, resizing labels, text boxes or fields as well as changing the Tab Order, or the order of fields you can tab to in the Form view.

How to Modify & Edit Forms
14:49
Forms Quiz
4 questions
+ Reports
10 lectures 01:29:26

Microsoft Access 2016 training video on the different type of views to view, print or edit your reports including: Report View, Layout View, Design View and Print Preview.

Report Views
08:11

Microsoft Access 2016 training video on how to create an instant report
including the different report views: Layout, Design and Print Preview.

How to Create Instant Reports
08:48
Microsoft Access 2016 training video on how to create a Report step by step using the Report Wizard!
Step by Step Report Wizard
10:37

Microsoft Access 2016 training video on how to create a field that you can add a formula, or function to and do some calculations by itself, or with other fields in your reports!

Ceate Custom Calculating Fields
22:19

Microsoft Access 2016 training video on how to format numbers in your Reports by working with the Formatting Controls, which include formatting to currency, decimal places and data formats.

Formatting Controls
06:16

Microsoft Access 2016 training video on how to apply a Theme to your Reports, which is a collection of complimentary fonts and colors.

Applying Themes
05:29

Microsoft Access 2016 training video on how to insert images into your Reports, and thereby making them more aesthetically pleasing.

Inserting Images
07:41

Microsoft Access 2016 training video on how to insert background images, or watermarks into your Reports and make them appear more aesthetically pleasing, or to help with identification of the topic or type of report a person is reading.

Insert Background Images & Watermarks
09:27

Microsoft Access 2016 training video on how to insert background images, or watermarks into your Reports and make them appear more aesthetically pleasing, or to help with identification of the topic or type of report a person is reading.

Inserting Hyperlinks
04:07

Microsoft Access 2016 training video on how to insert hyperlinks into your Reports, in the Report View, which can be helpful for outside referencing of data found within the Report.

Prepare for Print
06:31
Reports Quiz
8 questions
+ Access 2016 Level 2 - Intermediate
1 lecture 05:58
  1. Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  2. Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  3. Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
Exercise Files, Instructor's Notes, Quiz & Answers
05:58
+ Advanced Tables
4 lectures 40:30

Microsoft Access 2016 training video on how to use Data Defaults and Data Validation, which includes saving time entering data with default data, and get accurate data entry by controlling the user's input with Data Validation.

Preview 14:39

Microsoft Access 2016 training video on how to use Show Column History, which tracks and keeps a history of previous data entered.

Show Column History
04:46

Microsoft Access 2016 training video on how to use Input Masks, which is used as a pattern for all data to be entered into a field including how much data and where.

Input Masks
09:07

Microsoft Access 2016 training video on how to use Lookup Fields, which is used to lookup the details of a field prior to selecting it from a drop-down list.

Lookup Fields
11:58
Advanced Tables Quiz
4 questions
+ Advanced Queries
11 lectures 01:10:27

Microsoft Access 2016 training video on how to create an Inner Join and an Outer Join, which are used to either all related records from two tables as long as both contain a field with the same data, or all records from the first table with only matching records in the specified join fields of the other table.

Inner & Outer Data Joins
11:16

Microsoft Access 2016 training video on how to Join Unrelated Data, which is used to you have two tables with no fields in common.

Join Unrelated Tables
02:16

Microsoft Access 2016 training video on how to create a Self Join, which is used to join a table to itself when it contains two fields with duplicate data, but in different records.

Self Join
06:03

Microsoft Access 2016 training video on how to create a Top Values Query, which is used to find the top number or percentage of items, like the top 5.

Top Values Query
04:40

Microsoft Access 2016 training video on how to use Unique Values and Unique Records, which are either used to omit records with duplicates in your query, or used to return only unique records based on all field in the underlying data source that makes up that record.

Unique Values & Records
05:38

Microsoft Access 2016 training video on how to use Unique Values and Unique Records, which are either used to omit records with duplicates in your query, or used to return only unique records based on all field in the underlying data source that makes up that record.

Wildcard Query
03:46

Microsoft Access 2016 training video on how to create a Parameter Query, which is used to prompt the user prior to opening the Query for additional criteria.

Parameter Query
08:06

Microsoft Access 2016 training video on how to create an Update Query, which is an Action Query and it's used to make bulk changes to values within a table.

Update Query
09:09

Microsoft Access 2016 training video on how to create an Append Query, which is an Action Query and it's used to add records from one table into another.

Append Query
06:57

Microsoft Access 2016 training video on how to create a Delete Query, which is an Action Query and it's used to delete records in bulk from a table.

Delete Query
07:13

Microsoft Access 2016 training video on how to create a Make Table Query, which is an Action Query and it's used to insert records from a query into a new table.

Make Table Query
05:23
Advanced Queries Quiz
10 questions