Microsoft Access Complete Beginner to Advanced
4.6 (2,452 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.
22,253 students enrolled

Microsoft Access Complete Beginner to Advanced

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports
4.6 (2,448 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.
22,250 students enrolled
Created by Kyle Pew
Last updated 5/2019
English
English [Auto], Italian [Auto], 2 more
  • Polish [Auto]
  • Romanian [Auto]
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
  • 13 hours on-demand video
  • 8 articles
  • 11 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
  • Manage Large Sets of Data in Microsoft Access Relational Design
  • Build an Efficient Database Table Design
  • Control User Data Entry Effectively
  • Build Dynamic Access Database Queries
  • Present Dynamic Reports
  • Build Automation, Saving Time and Money
Requirements
  • Windows Machine with Microsoft Access
  • No Prior Microsoft Access Knowledge Needed
Description

Microsoft Access all in One Package

This Microsoft Access course combines 4 different courses.

  • Microsoft Access 101 - An Introduction to Access and Table Design

  • Microsoft Access 102 - Access Queries

  • Microsoft Access 103 - Form and Reports

  • Automate Microsoft Access Tasks with Macros and VBA

Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.

Material recorded with Access 2016 but works in 2007, 2010, 2013, and 2016

Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating Effective Database Tables

  • Understanding Table Relationships

  • Building Dynamic User Data Forms

  • Effectively Retrieve Data Using Access Queries

  • Build Effective Reports

  • Automate Access Database Tasks with Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!

Who this course is for:
  • Users Looking to Gain a Working Knowledge of Microsoft Access from Beginner to Advanced
Course content
Expand all 173 lectures 13:16:52
+ Access Overview - Quick Overview of Access Interface
6 lectures 21:31
Working with the Access Ribbon
03:45
Access Object Panel
04:12
Access File Tab
03:19
Access Security Prompt
03:19
+ Access Overview - Fundamentals of Access Objects
6 lectures 41:11
Understanding the Purpose of Access Tables
08:46
Building Relationships between Access Tables
05:37
Using Access Queries to Select Specific Data
09:15
Building a User Interface with Access Forms
07:34
Reporting on Access Data with Access Reports
05:53
Automate Access Tasks with Macros and VBA
04:06
+ Access Tables - Working with Table Data
4 lectures 17:42
Working in Datasheet View within an Access Table
06:15
Sorting the Datasheet View
03:19
Filtering the Datasheet View with Filter by Selection
03:33
Filter the Datasheet View with Advanced Filter
04:35
+ Access Tables - Creating Tables in Your Access Database
15 lectures 01:09:14
Creating an Access Database
03:42
Designing Access Tables in Design View
10:23
Adding Fields and Defining Common Data Types in an Access Table
05:32
Field Size Property
05:45
Field Caption Property
02:48
Default Value Property
04:08
Required Field Property
01:30
Input Mask Property
09:18
Custom Input Mask
04:52
Working with the Lookup Wizard Data Type
04:29
Edit a Table Field Drop Down
01:54
Adding Field Descriptions
02:00
Setting the Table's Primary Key Field
05:49
Adding Records in the Datasheet View
03:28
+ Access Tables - Microsoft Access Table Exercise
2 lectures 05:11
Table Exercise Introduction
03:11
Building Additional Tables
02:00
+ Access Tables - Working with Access Table Relationships
7 lectures 44:53
Understanding Access Table Relationships
05:37
Creating Access Table Relationships
08:29
Setting Up "Better" Table Relationships
09:20
Setting the Relationship Properties
06:16
Table Relationships Cascade Update/Delete
04:41
Working with Sub Datasheets in Tables
03:06
Creating Table Relationships with the Lookup Wizard
07:24
+ Access Queries - Working with Access Select Queries
13 lectures 47:33
Creating an Access Select Query
06:26
Adding Criteria to an Access Select Query
02:52
Using AND Conditions in an Access Query
03:06
Using OR Conditions in an Access Query
02:40
Another OR Condition
02:11
Sorting Data within an Access Select Query
01:42
Multi-Level Query Sort
03:35
Working with Date Criteria in an Access Select Query
04:01
Using the "Between" Operator
02:00
Access Query Tip -- Using Table Fields within Query Criteria
05:06
Using Wildcards in Query Criteria
05:51
Access Query Tip --- DATA TYPE MISMATCH
05:55
Saving an Access Query
02:08
+ Access Queries - Query Calculated Fields
4 lectures 30:02
Creating a Calculated Field in an Access Query
06:51
Using the MONTH() and MONTHNAME() Functions
08:13
Using the IF() Function in a Query Calculated Field
08:56
Finding the Difference Between Two Dates Using the DateDiff() Function
06:02
+ Access Queries - Summarizing Data in an Access Query
7 lectures 25:05
Working with an Access Total Query
02:12
Grouping and Summarizing Data with a Total Query
06:55
Adding a Calculated Field to a Total Query
04:00
Saving a Total Query
01:29
Total Query Exercise -- Post in the QA Section
02:27
Total Query Example -- Products Table
01:34
Summarizing Data with a Crosstab Query
06:28