Access 2021 Full Course Tutorial (6+ Hours)
Vložit
- čas přidán 12. 09. 2024
- Access 2021 Full Course Tutorial (6+ Hours)
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime...
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:
www.learnitany...
For Private Group Trainings please visit:
www.learnit.co...
Manuals: bit.ly/30xZb59
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.
Exercise Files: learnitanytime.com/p/exercise-files-access-2021-full-course-tutorial
Hello, please can you help me out on how to correct the error of "Subscript out of range " ?
This occurred at the final stage of importing customer record in the tblCustomers..
@@AckahErzane Read my comment.
Thank you Trish for putting efforts to make things easy to understand!! It is helpful :-)
😮😊 8:44
9:27 9:29
I do not know how to thank you for this wonderful, easy and tidy academic work...... Thank you from the bottom of my heart.
Thank you for your continued support Ezz!
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.
Awesome tip!
Except that you can't change CustomerID to AutoNumber
I know I could find answer to this problem on the comment section. Many thanks!
@@raquelamarins2249 1:25:26 explains how to fix AutoNumber
I experienced same issue just now. I'm just starting in the course. Thanks.
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.
Wow, thank you!
So many thanks for this MS Access tutorial. Very helpful, clear and detailed in its presentation. I learned a lot from it.
You are welcome!
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.
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
Thanks for the great tip!
Wow where was this video two months ago for my exam. Very detailed 👌
Hope it helps!
Best course on access i have seen on CZcams
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.
Thank you for the notes and we are glad you learned so much!
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.
You are very welcome!
This is a wonderful course. Thank you!
You are welcome!
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).
Hello Yevgeniy! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining Any free community to join?
thanks very much for this great help through this video.................
Glad it helped
many thanks to you, it is a great course
You are welcome!
This is a wonderful course. Thank you!
You are very welcome!
3:56 I remember you made a change in the query and it reflected in the table, like you changed last name to Foresst and it also changed in table......now you're saying that those were just select queries and didn't change table
Dear Trish. I can't thank you enough for this genius course. it really helped me alot . but i'm having this issue in Module 5 Lesson 5 when I enter the incorrect password, and ok , it takes me into the emplyoyee form and does not take me out of the form, so if you please could you give me a hand on that.
Thanks a lot :) Your videos are so helpful to me
You are welcome!
Really well explained. Thank you
Glad it was helpful!
Excellent course, well presented by knowledgeable tutor
Glad you liked it!
Thanks alot for useful video
You are welcome
5:48 Didn't understand the concept of FE and BE database...the access to the tables that we need to give to end users is in FE or BE?
If in FE then, then how will the further development or changes will be done by DBA in the FE since it's uneditable (you said further development to be done on FE DB)
At 2:09 Why we converted the data into category id as numbers first and then names of category, when originally it was showing names good?
Thanks for the lesson
Our pleasure!
Very informative video about MS Access, I need to learn it. Thanks 👍
You are welcome!
5:40 Can we create 2 different VBA codes or event on the same form?
Here, I think multiple conditions VBA got replaced by single condition VBA, right?
Module 4 issue with qryCustomerByName not pulling the Jazzy Jazz Cafe may have something to do with the Active & Employee fields being blank- does the same with Milton’s Restaurant and Eastern Eardrums, regardless of whether you enter a partial or full name - doesn’t make sense, but that is the common denominator 🤔
Correct the query shows only the companies where employee field is populated. You can confirm this by removing full name column.
@@Saad-Sadiq Thank you for the response. Per my response, I was able to figure this out. However, the trainer (Trish Connor-Cato) indicated in the video that she did not know why it did not pull the Jazzy Jazz Cafe when the partial company name was queried… which is concerning when someone, like myself, is attempting to learn a program and the instructor cannot explain or correct when unexpected results &/or errors are encountered.
4:06:49 We don't save the changes in case of update?
Then did the change reflect in the query?
5:27 what did you press to save the record and have the new blank form displayed again?
Keep it up 👍
We will!
Good Day, Could you kindly tell me how you get your mouse cursor to make the arrows. It is very useful.
That is Zoomit! A free program
@@LearnitTraining Thank you very much. Currently I am enjoying your tutorial. Have you got something similar for MySql or Sql perhaps?
You're an amazing teacher! I can't believe this is free.
Thank you! 😃
In actual use how do we write the VBA code or even retain it in mind?
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?
During my practice, I got to importing the customers record into the table, on my final click(Finish), I got an error which states that 'Subscript out of range'
How do I correct this?
Hello Krist! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Same with me...did you found the solution?
1:55 we could change the data type from shot text to number, even if the table had data, why it didn't give the error this like we got an error in previous sections where we added new field, assigned required data type and deleted the original field?
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?
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?
Hello Oscar! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I have recently found this tutorial and found it very well documented, but I do have an issue in Module 5 Lesson 5 the vba code to the employee form, I have done this several time and when I enter the incorrect password, and ok , it takes me into the emplyoyee form any and does not take me out of the form, I have download all the exercise files 5 times, and have run with no debug box, just wrong password and back to employee form ???? thoughts, ideas??
Hello Alan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Hello @alan9171 ! I'm having the same problem here ! Have you found a solution ? Thanks a lot
Same problem. did anyone found a solution ?
thank you very much.
You are very welcome!
Hello deyer happy New year 🎉
Happy New Year!
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 ?!!
Hello weasam alaa! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Excellent mam
Thanks!
how can i import emails from outlook with the attachment?
Hello Zsuzsko! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
I am Readying watching in 6 hours 3 hours Just now 3 hours Tomorrow
We hope you learn a lot!
Well done
Thanks!
Hi! When I try to import data into the "tblCustomers" table, I get a "Subscript out of range" message dialog box? I only get the option to click "OK" and I'm back at the Import Spreadsheet Wizard final screen again...😞 Help!!..Thanks!
Same error as I'm currently facing..
I'm currently doing manual data entry of that section, but I wish LearnIt will help us out
Brilliant
Thank you!
You do not really give some assistance. You only reply when you get a compliment, not when I for one has a problem/error in your course
Hello Kobus! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@@LearnitTraining Thank You
@@LearnitTraining No help from there either
I have restarted this course about 6 times to make sure that I have not done something wrong. I keep on getting the same error as soon as I do the lookup. I decided to go back, re-create tblOrders and tblCustomers and not do the step where I put the numbers on the data sheet manually, but change the CustomerID on tblOrders to NUMBER and not SHORT TEXT. I did not do the lookup, but the Customer names still did not show on tblOrders Data sheet. I noticed a down arrow on each record and if noticed if I open it, I can select the Customer names one -by -one. This worked perfectly, I have all the Customer Names in tblOrders.
The only problem I see so far is that there is 16 records with Customer Names in, but from record 17 to record 30 is blank records. I do not want to delete these blank records, because it might delete them forever and start the next record with 31.
The only reason this is easy to follow along is because it was made recently.
Thanks
Check out Dan McAllister's 2016 Access tutorials from LearnIt Training. I had no problems going through every module step by step.
@@thomastommy9864I have done Dan's 4 video series and trust me, it's the best access tutorial u can find in the entire world. Am also here to get a tip or two of which am really grateful for coz they're free. God bless learnit institution
❤
❤
in this class they think that one can do anything on our own. thats not true.
03:03 Report in design view is okay, but how to put current date and time on the report header?