Access 2021 Beginner Tutorial

Access 2021 Beginner Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Beginners through experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Access.

What it is: Access is Microsoft’s relational database application used to organize and store data. Access also has reporting capabilities.

What you'll learn: We start with navigating a completed database while exploring the concept of relational databases and the objects they contain. We’ll move on to learning the Access interface, so you can become comfortable in the working environment. Then, we dive into how to plan, design, and create database tables. We’ll continue by importing table data from Excel, as well as manually entering table data. Sorting and filtering techniques will be explored before we move on to exploring table relationships, the key to a successful relational database. We will create database queries, forms, and reports. We’ll spend time on learning how table relationships affect queries, how to automate queries, and how to create action queries. Our advanced training starts with Advanced Report and Form Design techniques. We will learn how to create switchboards, write macros, and use Access Visual Basic for Applications (VBA) for complex automation. We will end by covering database security and customization options.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:03
Database Basics 2:03
Introduction to Database Objects and the Access Interface 4:01
Accessing the Northwind Template 7:13
Exploring the Login and Homes Forms 10:23
Navigation Pane Default View and Datasheet and Design Views for Tables 13:11
Exploring Datasheet View, Design View, and SQL View for Query Objects 16:29
Exploring Form View, Layout View, and Design View for Form Objects 19:50
Exploring Report View, Layout View, Design View, and Print Preview for Report Objects 21:28
Running Macros and Exploring Design View 24:01
Examining VBA Code 26:16
Access Ribbon and Status Bar 27:23
Exploring the Relationships Window and Closing the Database 31:07
Introduction to Creating New Databases 35:23
Creating Blank Databases 41:41
Switching Default Table to Design View and Renaming the Primary Key Field 43:05
Adding Remaining Fields to the Customers Table 46:38
Field Descriptions, Format and Text Limit, and Input Mask 49:49
Using the Caption Field Property 56:52
Creating New Tables in Design View 58:43
Introduction to Entering Data into Tables 1:03:24
Manually Entering Table Data 1:03:55
Importing from Excel - Appending to Existing Table - Employees 1:06:39
Importing from Excel - Appending with Different Data Types Error - Customers 1:10:58
Importing from Excel - Adding Data into A New Table - Categories 1:14:55
Importing from Excel - Adding Data into New Tables 1:18:10
Reviewing Data Types and Field Properties for Imported Tables - Products 1:19:58
Reviewing Data Types and Field Properties for Imported Tables - Orders 1:25:01
Order Details Table - Discussing Composite Key Fields 1:27:59
Setting a Composite Key - Order Details 1:30:02
Sorting Table Data 1:32:56
Inclusive Filtering, Exclusive Filtering, and Filtering by Form 1:34:38
Introduction to Relationships 1:38:46
Adding Tables to the Relationships Window and Organizing Them 1:41:22
Common Fields Between Tables 1:45:02
Creating a One-To-Many Relationship Between Customers and Employees Tables 1:45:28
Creating Relationship Errors 1:49:59
Resolving Data Type Errors and Repopulating Table Fields 1:52:28
Manually Repopulating Table Fields 1:57:41
Creating Lookup Fields in a Table 1:58:42
Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error 2:01:17
Resolving a Data Type Error and Repopulating Table Fields 2:05:55
Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship 2:09:54
Database Basics Recap 2:14:44
Conclusion 2:16:27

#microsoftaccess #access

(C) 2022 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[Amba_Aradam]

To all those who get an error message with Subscript out of range - instead of importing it into the table you created beforehand, choose the option "Import the source data into a new table in the current database". Then, tick the option "First Row Contains Column Headings", do not import the CompanyID column and instead let access add its own primary key (later you can rename it to CompanyID in the table design view). All you need to do next is to rearrange the data types the way she did it before - so format phone number, hyperlink and so on. It's a shame that the authors despite creating such a great tutorial limit themselves to sending us all to their website, even though it's so easy to fix.

[dwhite]

I have watched quite a few of these Access training videos and this, I can tell you is the very best so far. Clear, accurate, no flim flam and no "umm-ing" or "ar-ing". Very very good. Many thanks

[captainkeyboard]

This show is right up my niche! A few months ago, I upgraded from Access 2019 to Access 2021. Microsoft Access 2002 was the first database program I used as a part of Microsoft Office XP Professional, since I had my first microcomputer in 2002. This is a reason I chose to stay with a Windows computer, instead of using the Apple Macintosh computer. In 2017, I bought a new and a Dell computer. I "leaped" to Microsoft Office 2016 Professional; then Microsoft Office 365 Professional, then Microsoft 365 Professional, then Microsoft Office 2019, and finally Office 2021 Professional. Your tutorial is a godsend!

[nickbrown.wsm]

ERROR 2
Ran into the "Subscript out of range" error at 1:13:37 in the Access 2021 Beginner Tutorial? Here's a workaround that helped me move forward:
Instead of importing the entire sheet at once, try copying one column at a time from the Excel file named "Import into Access" and pasting directly into the corresponding column in Datasheet View in Access.
If you encounter a problem when copping the phone Column over here is the fix I found works for me:
1. Pop into Design View
2. Click anywhere on the phone Field Name
3. Down the bottom in Field Properties select input musk then move right across till you see three dots like … and click on it
4. Click on Phone Number under Input Mask: then click the edit List box.
You should make the following corrections

Description: Phone Number
Input Mask: [phone]
Placeolder: _
Sample Data: [phone]
Mask Type: Text/Unbound

Click close and finish. Return to Design View say yes to save on the way.
Now it should work.

[nickbrown.wsm]

ERROR 1.
Ran into the "Subscript out of range" error at 1:13:37 in the Access 2021 Beginner Tutorial? Here's a workaround with the help of Ai in ChatGpt, we was able to move forward:

Instead of importing the entire sheet at once, try copying one column at a time from the Excel file named "Import into Access" and pasting directly into the corresponding column in Datasheet View in Access.

If you encounter a green error triangle in cells within the Excel 'Zip' column, it may indicate a potential issue. For example, I had to change the value in cell G7 from '02720' to '12720' to correct the format.

After making the necessary corrections in Excel, double-click each cell with a green triangle to address any errors. This step ensures that the data is clean and ready for import.

Once all errors are resolved, copy the corrected column from Excel and paste it into the 'Zip' column of the 'tblCustomers' table in Access's Datasheet View.

Hope this helps anyone who might be stuck on the same issue. Happy learning!

[adwinstead]

Love your course and the way you explain things precise and calmly. Awesome!!

[SennaCrow]

I have to my having to find small fixes because my MS Access didn't do a few things the same, I'm having a much easier time understanding this video than any of the others so far on MS Access. I've tried and given up several times over a couple decades, lol. It's starting to make more sense now.

[kossiviaglee]

This is amazing! Please, DO NOT STOP! Thanks!

[flatlander]

Outstanding course. I wish I had this when I started learning Access back in the 80's. I will complete all sections for sure. The only thing you might include in the beginning is how to adjust the different visual change settings like fonts, size, color, how to tile vertically and horizontally. You are an excellent trainer. 🙂

[mallemoses]

I really appreciate your video on the access database for beginners, I have learnt alot... thankyou!

[ermiasfeleke]

click on the magnet, and from there you can adjust how the tracks snap onto the grid. if you want it to be each 1/4 of a bar, click "line"

[victorwestmann]

1:21:07 what application are you using, instructor, to have this more options to arrange your window? This is super wicked!
Thank you for the complete, step-by-step, and with amazing didactics course!

[marceljunioregondi]

, Have not watched the whole tutorial but what caught my eye was the dark theme. Can I do the same on access 2019?
A query what are the updates on this from the one we went through with Dan McAllister.

[sabermmirza]

it was great thanks for sharing, i hope i can get more details about Many to Many Relationship in future videos of this course

[dancerfanatic]

Very good tutorial, thank you Trish. I would like to learn more about Listbox with multiple selection and multilevel with multi-column listboxes to pass data between each other. Example I have 300 Customers with a daily order, I need to put in a listbox those Customers and choose which ones I need to reprint their orders, of course with options like double click the customer to pass between listboxes. Thank you very much.

[AckahErzane]

Very educative, easy to understand..
I will recommend this page to anyone interested in learning ms access

[bartsantiagovo]

em muon goi loi cam on chan thanh nhat den voi ban, chuc ban suc khoe

[hnfbgzp]

I have also got the error "Subscript out of range" error at 1:13:37 in the Access 2021 Beginner Tutorial, could someone explain why we are getting a different errors? Thank you in advance

[popopopo]

When I tried to import the Excel data to tblCustomers, the final step for importing says”Subscript out of range” at 1:13:37. I was stopped there. Would you pls advise further? Thanks a lot. I appreciate it.

[elizabethiradukunda]

When i try to import the customer data i get subscript out of range -
update i resolved the issue.. save the file re opened it and i was able to import with the "ërror"