Microsoft Access: Complete MS Access Mastery for Beginners
4.3 (755 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.
15,046 students enrolled

Microsoft Access: Complete MS Access Mastery for Beginners

Beginning Microsoft Access mastery. Design Access databases from scratch. For Access 2010, Access 2013, and Access 2016.
4.3 (755 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.
15,047 students enrolled
Created by Steve McDonald
Last updated 2/2020
English
English [Auto]
Current price: $113.99 Original price: $174.99 Discount: 35% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 3 articles
  • 5 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
  • At the end of this course, you will be able to create a simple DATABASE in Access from scratch.
  • You will know how to create and modify TABLES in Access.
  • You will know how to create FORMS for enter data into your tables.
  • You will know how to create QUERIES to ask questions of your Access database.
  • You will know how to create REPORTS for sharing and presenting your data in a clear, professional way.
Requirements
  • You just need to have a PC, basic computer skills and an installed copy of Microsoft Access on your computer.
  • You don't need any previous experience with MS Access or Excel.
  • This course starts at the very beginning.
Description

Welcome to the Access 2016 course. 

Thank you so much for joining me. 

  • Do you need to learn Microsoft Access, but feel intimidated or
    overwhelmed by the thought of it?

  • Are you ready to learn a ton of practical, hands on Access skills?

If so, you found the right course!

This course is designed to get you feeling comfortable and confident using Access. It's designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.

Is it the Right Fit?

Will this course be a good fit for you? Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you're ready to fine tune and expand your skills in an easy, stress-free way.

Skills to Impress Your Boss

While its ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or new job that you deserve.

Start at the Very Beginning

We'll start out with a complete tour of Access and it's tools. Then, I'll show you how to open an Access Database and how to use pre-formatted Access templates provided by Microsoft so you can start right away.  

Create a Database from Scratch

  • I'll walk you through creating a complete Access database from scratch. 

  • I'll show you how to create tables and connect those tables to each other using relationships. 

  • I'll show you how to mine your data using queries, how to create forms so users can enter data into your database, and how to create custom reports so you can impress your boss. 

  • I'll also share insights and productivity tips along the way.   

Let's Get Started!

Are you ready to take your productivity and hopefully even your job prospects to the next level? Let's get started with Access 2016.

Click on the Buy Now button or watch one of the Free Preview Lectures and start learning Access today.

Who this course is for:
  • Anyone who needs to learn Microsoft Access, but might be intimidated or feel overwhelmed by it.r
  • This course is for students brand new to Access.
  • This course is also for students who have some experience with Access or Excel and need to learn more about Access.
Course content
Expand all 53 lectures 07:09:35
+ Introduction to Access
3 lectures 31:57

Welcome to Access 2016: Complete Microsoft Access Mastery for Beginners. In this lecture I'll introduce you to some basic database concepts and give you a tour of a Microsoft Access template.

Preview 09:52

In this video I'll take you on a tour of the Microsoft Access dashboard, tools and ribbon.

Preview 10:08

At the end of this lecture, you'll understand the four most basic objects in Microsoft Access: Tables, Queries, Forms and Reports. And you'll understand the role that each of these objects plays in your Access database.

Preview 11:57
+ Tables in Access
4 lectures 39:46

In this lecture I'll walk you through creating your first two tables in Access. Tables area the backbone of a database. They are where all of your data, or information, is stored in Access.

Preview 17:53

Appending data allows you to add data into an existing Access table from another source, such as Excel. In this lecture I'll show you the ins and outs of appending and Excel file into our Access database.

Preview 07:50

In this lecture I'll walk you through importing data from Excel into your Access database. Importing is a quicker, cleaner way to bring in new data if you haven't yet created your table in Access.

Importing Data from Excel into Access
06:48

In this lecture I'll walk your through how to import data from a CSV (comma separate values) file into your Access table. 

Importing Data from a CSV Text File into Access
07:15
+ Database Design in Access
3 lectures 26:15
More Complex Database Design Scenarios
03:53

In this lecture you will learn more about table relationships in Microsoft Access. You'll also learn about the importance of Primary and Foreign keys in creating these relationships.

Primary Keys and Foreign Keys in Relationships
15:04
+ Field Properties in Access Tables
3 lectures 35:41
Size, Format & Input Mask Field Properties
16:04
Default Value, Validation Rules & Indexed Field Properties in Access
15:59
+ Forms in Access
4 lectures 54:02

In this lecture you'll learn how to create a form using the Form Wizard in Access. You'll also learn how to format your labels and text box controls, use the properties to modify your form and how to select objects in Design View.

Create and Format a Form Using the Form Wizard
14:04

At the end of this lecture, you'll be familiar with many of the controls that can be added to your Access form in the design tools tab. You'll be able to add these and configure them to increase the functionality of your Access forms.

Add Controls to Your Form for Better Usability
15:15

In this lecture, you'll learn how to add combo boxes and navigation buttons to your Access forms. This allows you to create a better user experience for anyone entering data into your form. It also allows you to restrict the data entered, using a combo box drop down, so they can only enter data that exists in a specified field in your table.

Add Navigation Buttons and Drop Down (Combo) Boxes to Your Form
16:08
+ Queries in Access
3 lectures 34:49

In this lecture, you'll learn how to create your first Query in Access. You'll also learn how to use Sorting and Filtering in your tables to get quick answers from your data.

Introduction to Queries, Sorting and Filtering
10:42

In this lecture we'll create a Query based on the employees in our table who live in Los Angeles using specific criteria in our Access Query.

Create a Query Using a Single Criteria
07:53

In this lecture, we'll look at lots of examples of how to use Criteria in your Queries to make those Queries more powerful.

Criteria in Queries - Many Examples
16:14
+ Reports in Access
2 lectures 19:07

In this lecture, you'll create a clean, simple employee phone list report.

Introduction to Reports - Create Your First Report
06:10

In this lecture, we'll create two more Reports in Access using different methods.

Create Two More Reports
12:57
+ Options Menu in Access
2 lectures 19:53

In this lecture, you'll learn how to change General and Current Database options in the Access Options Menu. This allows you to customize the look and activity of your Access interface.

Options - General and Current Database Option Tabs
10:12

In this lecture, you'll learn how to change options in all of the remaining tabs in the Options Menu. This will allow you to customize the look and actions of your Access interface.

Options - Datasheet and Other Option Tabs
09:41
+ Exporting Data
1 lecture 05:03

In this lecture, you'll learn the important task of Exporting your Access database object to other files, including PDF, CSV (comma separated values text file), and Excel.

Exporting Tables, Queries & Reports to Text, PDF and Excel
05:03
+ Intro to VBA in Access
5 lectures 28:49

Now we enter the advanced section of the course. It's gonna get a little more challenging from here, but take your time, bear with me through the intro stuff and it will all make sense in the end. This is where your skills will go to the next level in Access!

Preview 01:43
Downloadable Database for Advanced Section
00:21

Introduction to VBA and the VBA window.

Introduction to VBA in Access
04:25

This is where things get serious. We're going to dive into VBA and look at a lot of the features and items involved in writing VBA code.

VBA Setup in Access
15:25

In this lecture you'll learn to debug your VBA code and set up error handling routines within your code.

VBA Debugging in Access
06:55