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

Course content

23 sections • 135 lectures • 17h 0m total length

Introduction13: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.

Exercise Files, Instructor's Notes, Quiz & Answers5:58
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
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
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

Access 2016 Overview - First Look13:34
Access 2016 training video on the basic overview of the application itself including: startup screen, Ribbon, Navigation pane, working area, Status Bar and more!
New Tell Me What You Want Or Help Feature1:48
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.
Change Office Theme4:40
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.
Quick Access Toolbar7:02
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.
Customize Ribbon9:01
Access 2016 training video on how to customize the Ribbon including adding and removing tabs, commands and groups.
Datasheet Appearance1:46
Access 2016 training video on how to customize the Datasheet's appearance including it's font size.
Document Window Options7:25
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.
Basic Introduction to Tables, Queries, Forms & Reports13:41
Access 2016 training video on the basics of the four major objects in Access including: Table, Query, Form and Report.
Create a New Database6:41
Access 2016 training video on how to create a new database file for your tables, queries, forms and reports.
Basics Quiz

Creating Tables23:18
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.
Entering Records in Tables4:35
Access 2016 training video on how to enter in records in a table efficiently with some tips, tricks and shortcuts.
Export Table to XPS or PDF3:31
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.
Table Structuring9:31
Access 2016 training video on table structuring in a way that allows you
to create relationships between tables from a poorly designed database.
Tips for Managing Tables5:25
Access 2016 training video on tips for managing your tables including:
deleting, renaming and hiding tables, table descriptions, and object
groups.
Basics on Primary, Composite & Foreign Keys13:51
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.
Basic Introduction Setting Up Tables for Relationships7:35
Access 2016 training video on how to setup up tables to relate to one another by creating Primary and Foreign key fields.
Create One-to-Many Relationships17:48
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-One Relationships13:29
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.
Denormalization or Denormalize13:32
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.
Managing Table Data15:03
Access 2016 training video on how to manage your table's data including how to: enter, modify, update and delete records.
Sorting Records5:10
Access 2016 training video on how to sort your table's records.
Filtering Records10:03
Access 2016 training video on how to filter your table's records.
Subdatasheets11:43
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.
Tables Quiz

Query Wizard19:22
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!
Basics on Creating a Query in Design View12:15
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.
Setting Query Criteria20:58
Access 2016 training video on how to set criteria for your query including: text, numbers, dates, blank, empty fields.
Add a Calculating Field7:33
Access 2016 training video on how to create a field that performs a calculation on other fields using functions, or formulas.
Grouping Records & Totals8:15
Access 2016 training video on how to group your records, and add a calculation to that group by using the Totals feature.
Customize Table or Query Datasheet3:39
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!
Queries Quiz

Basic Introduction to Forms18:42
Access 2016 training video on the basic introduction to a Form, and includes how to sort and filter records in a form.
Create Forms Instantly12:06
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.
Form Wizard5:58
Access 2016 training video on how to use the Form Wizard to create a Form quickly for your database.
How to Modify & Edit Forms14:49
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.
Forms Quiz

Report Views8:11
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.
How to Create Instant Reports8:48
Microsoft Access 2016 training video on how to create an instant report
including the different report views: Layout, Design and Print Preview.
Step by Step Report Wizard10:37
Microsoft Access 2016 training video on how to create a Report step by step using the Report Wizard!
Ceate Custom Calculating Fields22:19
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!
Formatting Controls6:16
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.
Applying Themes5:29
Microsoft Access 2016 training video on how to apply a Theme to your Reports, which is a collection of complimentary fonts and colors.
Inserting Images7:41
Microsoft Access 2016 training video on how to insert images into your Reports, and thereby making them more aesthetically pleasing.
Insert Background Images & Watermarks9: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 Hyperlinks4:07
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.
Prepare for Print6:31
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.
Reports Quiz

Exercise Files, Instructor's Notes, Quiz & Answers5:58
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.
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.
Quiz & Answers - Quizzes are available online at the end of most Sections for you test yourself on what you've learned.

Data Defaults & Validation Rule14:39
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.
Show Column History4:46
Microsoft Access 2016 training video on how to use Show Column History, which tracks and keeps a history of previous data entered.
Input Masks9:07
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.
Lookup Fields11:58
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.
Control Data Entry Quiz

Inner & Outer Data Joins11:16
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.
Join Unrelated Tables2: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.
Self Join6:03
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.
Top Values Query4:40
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.
Unique Values & Records5: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 Query3:46
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.
Parameter Query8:06
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.
Update Query9:09
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.
Append Query6:57
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.
Delete Query7:13
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.
Make Table Query5:23
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.
Advanced Queries Quiz

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. MAC users, since the videos are recorded with the Windows version of Microsoft Access, the interface will be bit different.

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

What you'll learn

Explore related topics

Course content

Access 2016 Introduction1 lecture • 13min

Access 2016 Level 1 - Beginner1 lecture • 6min

Basics9 lectures • 1hr 6min

Tables14 lectures • 2hr 35min

Queries6 lectures • 1hr 12min

Forms4 lectures • 52min

Reports10 lectures • 1hr 29min

Access 2016 Level 2 - Intermediate1 lecture • 6min

Control Data Entry4 lectures • 41min

Advanced Queries11 lectures • 1hr 10min

Requirements

Description

Who this course is for: