Access 2021 Full Course Tutorial (6+ Hours)

Access 2021 Full Course Tutorial (6+ Hours)

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

Introduction 0:03
Database Objects and the Access Interface 3:30
Creating New Databases 34:52
Entering Data into Tables 1:02:53
Relationships 1:38:15
Queries, Forms, and Reports 2:16:03
Query Reports and Complex Queries 3:06:18
Advanced Reports, Automating Queries, and Using Query Wizards 3:37:21
Action Queries 3:56:11
Advanced Forms and Automation 4:23:13
Designing Macros to Automating Database Tasks 5:04:30
Access Visual Basic for Complex Automation 5:27:16
Database Security and Options 5:43:29
Conclusion 6:06:23

#microsoftaccess #access

(C) 2023 Learnit, Inc.

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

[kzsjqcs]

I do not know how to thank you for this wonderful, easy and tidy academic Thank you from the bottom of my heart.

[qoskdjw]

I am in the midst of your course and just wanted to say how much it has helped me to understand Access. It has been a wonderful experience. You are an excellent instructor.

[mohamedmokdad]

So many thanks for this MS Access tutorial. Very helpful, clear and detailed in its presentation. I learned a lot from it.

[tangwanephraim]

Best course on access i have seen on YouTube

[LTrres]

Thank you so much, your expert knowledge in Access makes it essay for me to understand the tasks, your explanations are wonderful. Thanks again God bless.

[robertneave]

For the SUBSCRIPT OUT OF RANGE error when creating "tblCustomers" at 1:13:15, simply keep moving in the course. Right after this problem occurs, the course teaches how to work around this problem at 1:14:25 - 1:17:40 while teaching how to import source data into a new table. For now, go ahead and delete your current "tblCustomers" table (Right Click, Delete) - you're going to make a new one. Use the steps taught at 1:14:25 - 1:17:40 to create a new "tblCustomers" table. Next, go back to 49:18 - 56:19 to recapture how we formatted the Field Properties in Design View. Modify your new "tblCustomers" Field Properties to match the old one that was deleted.

[johnr]

Subscript out of range error is shown because the data type in the Excel file and the access database is not the same. Import the data into a new table and edit accordingly.

[mengmakara]

This is a wonderful course. Thank you!

[amanhaman]

Thanks a lot for the effort you put into this. I've been working in excel but was asked to build a simple db for a brother's elementary school so I had to take this refresher course.
I've made one observation that is perhaps because I'm working in Access 2016. When the password code is attached to the load event, after entering no/wrong password, the form loads anyway after showing the dialogue boxes.
To fix this, I attached the code to the Form Open event instead and when the right password isn't entered, right before "exit sub", I added "Cancel = true" and that worked. I hope it helps someone else.

[kobusjhg]

Hi Trish, I am now on 1:57. I did type the CustomerID numbers. I was just wondering if I have to do this without help, I am sure you are using the CustomerID numbers from the Customers Table. As a point of clarity, I have noticed that although there are 16 Customers not all CustomerID numbers were used. What could be the reason for that?

[azoregturbo]

Hi! at 1:13:15 when I want to import the Customers I get an error message saying Subscript out of range. What could be the issue?

[JuliaAubert-wbcz]

Wow where was this video two months ago for my exam. Very detailed 👌

[zainshah]

Very informative video about MS Access, I need to learn it. Thanks 👍

[wattjock]

I am up to the end of this wonderful lesson (thank you very much!) and...

@5:20:51 ~ I don't know if anyone else ran up on this, however; I found that I needed to add an Else Statement to the IF Macro in order for the Employee cbo to be Visible if the Active control were checked.

If [Active]=False Then
SetValue Item=[Employee].[Visible] = No
Else
SetValue Item=[Employee].[Visible] = Yes
End If

[thohuynhmos]

Thanks a lot :) Your videos are so helpful to me

[oursteve]

Excellent course, well presented by knowledgeable tutor

[ypn]

Good afternoon. For example, I have 100 entries in the "table". A question:
1) How to create an automatic numbering in the table, starting from number 001 (this field with the number will be a key)
2) If, for example, I delete line 63, then the numbering should be updated (auto -missing).

[kobusjhg]

Good Day, Could you kindly tell me how you get your mouse cursor to make the arrows. It is very useful.

[oscarcampos]

I created a data base and I tried to enter a new record and I couldn’t. I got the this error “Cannot add record(s); join key of table ‘MemberInfoTbl’ not in recordset.” I went to my table and I noticed the primary and foreign key I originally established were deleted. I closed the table and re-open them and the keys showed up. Can you assist?

[weasamalaa]

would you please tell me how relationship is done between employee and customer table, however employeeid is number and employee in customer table is text ?!!