Access Masterclass; Level 1 & 2 - Beginner to Intermediate
5.0 (1 rating)
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.
11 students enrolled

Access Masterclass; Level 1 & 2 - Beginner to Intermediate

Learn how to take advantage of Access capabilities, whether you intend to use Access exclusively or along with Excel.
5.0 (1 rating)
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.
11 students enrolled
Created by Ermin Dedic
Last updated 4/2020
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • 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
  • How to work with the Graphical User Interface and the 4 Main Objects (Tables, Reports, Queries and Forms)
  • Be able to understand and apply database principles to ensure data integrity
  • Be able to import Excel spreadsheets into Access via GUI and VBA while applying proper database principles
  • Understand the fundamentals of Access Macros
  • Understand the fundamentals of VBA
Requirements
  • No prior experience is required
Description

'Access Masterclass; Level 1 & 2 - Beginner to Intermediate' is ideal for the beginner to Access or databases and delves into more intermediate topics like VBA and Macros.

You will start by Mastering the Access Graphical User Interface and then you will get introduced to Database Design, Macros, and VBA. We will also show you how to import Excel files via multiple options, including GUI and three examples using VBA.

This course starts by using the Access Graphical User Interface to build tables, reports, queries, and forms. These sections get you comfortable working with the Access Graphical User Interface to create and work with the 4 main objects in Access (Tables, Reports, Queries, Forms).

Access was designed to make it possible to build solid desktop databases by largely using the GUI. This makes development faster and easier, and it is one of the reasons that Access has continued to be popular despite new competition.

Next, we build on this GUI knowledge by showing you the fundamental principles of database design.  The concepts of normalization, relationships, and referential integrity are fundamental to understand if the goal is to eventually develop databases that can be used for serious purposes (ie a small business). 

Next, you will learn how to import Excel files into Access using the GUI while not breaking the rules of database design. You will then do the same but using VBA code. We will show you three different versions, from most simple to most complex but also the most flexible option and one that leads to better user experience.

Finally, you will learn about Macros and how to use them.

There is no reason to wait anymore...Udemy offers a 30-day money back guarantee if you are not happy with the course for any reason.




Who this course is for:
  • Excel users who want to use Excel and Access together but need to learn Access
  • Beginners to databases and Access
Course content
Expand all 93 lectures 06:52:01
+ Introduction
4 lectures 11:33

Just a few tips so you can have the best experience with the course.

Preview 02:51

Most of you enter this course already having some version of Access but in the rare case that this is not so..I explain how you might go about getting a trial.

In The Rare Case Where You Don't Have Access
02:14

All the databases used in course.

All The Databases Used
00:01

Before we really get into understanding how to build tables, reports, and all the other cool things, it is useful to look at some of the Access Options there are that we can set before we get going.

Setting Up Access Options
06:27
+ Everything about Tables
13 lectures 51:58

I introduce you to Tables, which are one of the 4 main objects in Access. Tables are the object that store the data.

Preview 03:51

I discuss editing records, including getting comfortable moving around the records and fields of a table, and adding/deleting records.

Preview 05:57
Sorting in Access
01:32
Filtering in Access
02:24
Find and Replace
02:37
Creating Our First Table, 1
04:13
Creating Our First Table, 2
02:47
Creating Our First Table, 3
01:41
Field Properties 1 (Field size, Format, Input Mask)
07:00
Field Properties 2 (Default Values and Validation Rules)
06:34
Look-ups in Access
07:33
Moving and Adding Fields in Design View
02:37
+ Working with Reports in Access
9 lectures 41:40
Intro to Reports and Report Wizard
07:24
Move, Resize, Align in Reports
07:23
Unbounded Controls in Access
01:38
Bound Controls in Access
02:36
Calculated Controls in Access
01:52
First Control Text Box in Report
10:07
Creating Grand Total Control for Report
04:55
Grouping in Reports
02:27
Conditional Formatting in Reports
03:18
+ Queries (Select Queries)
10 lectures 34:58
Intro to Select Queries
06:44
Sorting In Queries
02:40
Criteria in Queries
03:06
Wildcard Criteria in Queries
02:24
Formulas in Queries
05:20
Calculations in Queries
02:06
Parameter Queries
03:34
Top Records Queries
03:19
Totals Queries
02:15
Crosstab Query
03:30
+ Action Queries
3 lectures 13:13

Update Queries are about altering existing records in a table.

Update
05:13
Make Table
03:11

Append queries in Access are all about adding new records to an existing table.

Append
04:49
+ Forms in Access
10 lectures 36:32
Intro To Forms
01:01
Creating Customer Form
05:20
Alignment in Forms
03:11
Styling Our Form
03:01
Controlling Tab Order
01:51
Transactions Form
01:38
Creating Subform
04:58

Some final touches to our Customer Transactions Form.

Some Final Touches To Our Customer Transactions Form
07:13

I discuss the importance of the Form record source property.

Form Record Source
02:34

I share about 10 tips that will make your database building experience much smoother.

Form Design Tips
05:45
+ Database Design 1 (Becoming a Database Expert from Other Areas)
3 lectures 04:32
Advice for Spreadsheet Experts
01:25
Advice for the End User and Developer
01:35
Advice for Programming Experts
01:32
+ Database Design 2, Illustrating Normalization Practically
3 lectures 06:28
1st Rule for Normalized Tables, Hands-On Illustration
02:43
2nd Rule for Normalized Tables, Hands-On Illustration
01:55
3rd Rule for Normalized Tables, Hands-On Illustration
01:50
+ Database Design 3, Table Design
5 lectures 13:47
Tips for Primary Keys
03:59

I show you how to go about selecting a starting Auto-number of your choice.

Picking A Starting Auto-number
04:29
Is Duplication Sometimes Necessary?
01:38
Non-Normalized to Normalized
02:44
Field Type Consistency
00:57
+ Database Design 4, Relationships and Referential Integrity
7 lectures 22:41
Relationships and Referential Integrity Intro
04:03
One-To-Many Relationships
01:55
Many-to-Many Relationship
04:09
One-To-One Relationship
01:04
Hands-On Referential Integrity Illustration
06:42
Hands-on Cascade Delete Illustration
03:46
Cascade Update
01:02