Microsoft Access Beginner Full 3 Hour Tutorial Database Planning, Customer Table, Queries, Forms
HTML-код
- Опубликовано: 1 авг 2024
- A NEW VERSION of this course is available, completely re-recorded in 2021 for Access 2019 and 365 Subscribers. Watch here: • Microsoft Access Begin...
This course has been available on RUclips for a few years now and as of March 2020 has over ONE MILLION VIEWS. But, it's broken up into a dozen smaller videos (one for each lesson). A lot of people have asked me if I could put them all together into one video. That's what this is. When I started my RUclips channel back in 2004, there was a restriction of 10 minutes for a video. That's no longer the case. So... enjoy.. and when you're ready to get LEVEL TWO of this course for just $1 visit my web site at 599cd.com/X1dollar
00. Introduction (00:00)
01. Database Terminology (09:58)
02. Planning Your Database (23:47)
03. The Access Interface (35:40)
04. Customer Table, Part 1 (48:37)
05. Customer Table, Part 2 (1:05:48)
06. Entering Data, Part 1 (1:24:37)
07. Entering Data, Part 2 (1:42:52)
08. Sorting & Filtering (1:58:19)
09. Customer Queries (2:09:00)
10. Customer Form (2:29:16)
11. Customer Reports (2:47:07)
12. Review (3:09:48)
This course is for the novice user who has little or no experience with Microsoft Access. We will begin by learning about databases in general, some important database terminology, the progression from paper filing systems to electronic databases, and the benefits of using a database.
Next, you'll learn the importance of planning your database before you build it. You'll learn how to determine what tables your database will need, and what fields to place in which tables. We will then take some time to go over the Access development interface, including the Ribbon menu, the parts of the screen, the Navigation Pane, etc.
We will learn how to build our first table. We'll construct a table for a company to store customer data. You will learn how to build your table in design view. You'll learn field names, descriptions, and most of the different data types. You'll learn whether to use text or number fields. We'll also discuss using AutoNumbers to create identifiers (IDs) for all of the records in a table. This is called a Primary Key field.
We'll learn how to enter data, edit data, resize columns, and rearrange fields. You'll learn some rules for storing your data - such as only typing in the digits of a phone number. You'll see how to use the Date Picker. You'll also see how to use the Zoom window.
You will learn why no data is better than bad data. You'll see how to delete records, and we'll talk about where the missing AutoNumbers went. You'll learn about the Access Security Warning that you see whenever you download a database from somewhere else. We'll talk about dirty records, saving layout changes, and moving a column in datasheet view.
Next we'll learn how to sort and filter our records. You'll see how to perform a single-column sort. You'll learn the difference between text, numeric, and date sorts. You'll remove the sort. Then, we'll see how to filter records. If the boss only wants to see customers from New York, you'll know how to apply that filter to display the correct records. You'll learn how to print a table.
Sorting and filtering are OK, but you can't rely on them for daily use. You can design queries to present your data in whatever filtered or sorted manner you want, and then save those queries for later use. You'll learn how to create a query from scratch using the query designer. You'll see how to add fields to your query, perform a sort, and add criteria to your query. We'll discuss multi-column sorts (left-to-right). You'll learn how to save multiple queries that each perform slightly different functions.
Forms are useful if other people need to work with your database because you can present to them only the data they need to see - and lock everything else. You will learn how to build forms to show a single record, multiple records (continuous forms), and a split form to show both. You'll learn about labels and text boxes, how to resize them, and how to save your form. We'll discuss editing data in your form, using record selectors to delete records, and how to use navigation buttons to move around.
Reports are good for presenting data to people who aren't using your database - whether its printed, sent via email, or given as a PDF file (all of which we'll talk about in class). You'll learn how to create a simple customer report, how to modify the report title, how to use Print Preview, the Zoom controls, how to change the paper size and margins, and how to switch between layout view and report view. You'll also learn how to use the Report Wizard and create customer mailing labels.
ACCESS BEGINNER LEVEL 2: 599CD.com/XZ5BBJ
FULL ACCESS COURSE LIST: 599CD.com/XHR4Y9
ACCESS RESOURCES:
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
www.microsoft.com/en-us/micro...
I really like this tutorial. No advance stuff, no talking too much, right amount of humor and very detailed teaching. Thank you!
Welcome
Thank you for all the time you spent to prepare and give a clear 3 hours Access tutorial that covers exactly the need to start work with Access. Wonderful work and very helpful 😊👍
You're very welcome!
Very helpful! I already started watching (and will continue soon this coming vacation) the chunked vids.
This makes the lesson easier to search on. Thanks a bunch! Bless you, Sir! More power andots of love, from here in the Philippines!
Glad it was helpful!
Thanks so much for this lesson. Took up Access lesson some years back and couldn't get a thing even with an instructor handling me 1-on-1.
This video has really been immensely helpful, now that I need to incorporate Access into my personal work.
You're very welcome!
A very comprehensive tutorial and it's giving me a firm understanding of how things work. It's one thing to know how to set up a database but to understand what's going on is far more important. Thank you.
You're very welcome!
A TREMENDOUS base to learn how to use this program! I see when you get to larger databases how Access is SO much better to use than Excel!
THANK YOU for starting this off! Working on the skills I learned here before I jump in to the next lesson!
Glad it was helpful!
Excellent training. Step by step. It has been many years since I programmed in Access, and things have changed tons in the software. So this was extremely helpful to refresh me. Thank you
welcome
El mejor Turorial de Access que he visto. Gracias. Bien planeado, directo, facil de digerir
Muchas gracias. Agradezco las amables palabras.
This is the most helpful and clear tutorial for access I have ever encountered. Thank you so much.
You're very welcome!
This has been the best Access Tutorial ever and I'm planning to take all of your remaining courses. Thanks and can them coming
Glad you like them!
Rick is a very good tutor 😀 Honestly I would say you are brilliant in explaining a beginner.I am very happy.Thank you Rick 😀
You are very welcome
Very clear instruction Allows for those who have not used the program in a while relearn the Barny basics.
Glad you like.
Thank you for all that you do, sir. You are very articulate and explain everything with great details. Your work is greatly appreciated!
I appreciate that!
The clearest access tutorial for me. Though it takes 3 hours, I was able to absorb most of it in one sitting/setting. Thank you
Glad it helped! I do have a shorter version that doesn't go into as much detail, but the 3-hour one is my favorite.
@@599CD Sir its really a classic access vedio......With a lot of love from India...
@@599CD I ok lng it to the bank 🏧🏧🏧😅🏧🏧🏧😅
This is awesome. Thank you for putting this together.
My pleasure!
Thank You very much, it is real useful and easy to follow
You are welcome!
Thanks for this tutorial,i love it.
You're welcome 😊
Very informative and well presented. I am also equally impressed that one of your customers - like me - is a Big Rush Fan😁. Carry on with these superb tutorials please, they are great.
I've been to every Rush concert since Roll The Bones. Love them!
The best Access tutorial I have ever had.....I reserve my gratitude to you Sir.....With a lot of love from Kerala, India.....
You are most welcome
@@599CD Thank you for your response.... I would like to bring to your kind attention a problem l faced...I today watched at a stretch your 3+ hour vedio of Access for beginners. It solved my years long desire of learning Access. But U were telling that, after the biginners level, there would be an Expert level vedio which l unfortunately could not find even after searching several times amongst the vedios u have uploaded....
Could you pls send the quick link for those...
Expert level
Advance level...
Developer level....
Thank you...
With a lot of love from India....
Thank you....
Very clear explanation. I didn't have a clue of MS Access, but your lessons made it so interesting to me, that I take it so seriously and follow your classes
Awesome.
@@599CD I have asked my American friend if she can pay the 1 dollar for the level 2 on behalf of me as I am in India. She doesn't know how she can do it. Can you please tell me where she can pay it
Hello Sir,
Thanks for the way you have increased my knowledge of Ms. Excel and Access; God bless you. I am Cephus Johann Krangar, and I write from Monrovia, Liberia, West Africa. I strongly believe that your teachings (tone, pace, accent and superiority over the lessons) are all I need to become a computer genius. Please, could you as well provide lessons on Quickbooks?
I look forward to hearing from you soon.
Best Regards,
Cephus
Thanks for the compliments. I taught a QuickBooks class way back in 2002. Can't say that I have plans to do another one. 599cd.com/QB101
I love this tutorial, but he funniest thing is that I've been living in CO since '95, but grew up in WNY, and I know all those addresses you use quite well! LOL
Haha. Yep. I've been living in South Florida since 2013, so I can definitely tell all the tutorials I recorded BEFORE and AFTER that point. :)
Excellent tutorial.
Many thanks!
Very helpful. Thankyou.
You're welcome!
Thank you for creating this video sir ^_^ the explanations are very clear (easy to understand). I'm thinking of joining your class soon ^_^ Thank you so much.
Sweet. You're very welcome.
Really appreciate your effort
Thanks a lot
Thank you very much Sir ,learned alot from this video really appreciate.😊
You are most welcome
Great training video
Thank you!
Thank you.
You're welcome!
The best...... may GOD bless u
Thanks
Very helpful
Glad you think so!
Thank you so much
Welcome
Wow that was REALLY Really really GOOD
Glad you enjoyed! :)
Good job
Thanks
Very helpful, thank you. I have a problem with one of the reports, how do i add the file name on the printed report?
The file name of what? The Access ACCDB file?
Good evening Sir. Great video instruction. I'm looking to build a Access database that can keep track of our projects at work and be able to log the time spent on each project by techs using the clock in and out. Could you suggest any of your videos that may help me build that? I have built the timeclock but just cant figure out how to integrate it. Thanks
599cd.com/Timesheet
599cd.com/TimeClock
Tq, its helpful.
Next, would you make some tutorial of connecting access database with barcode scanner, many thanks
Way ahead of you: 599cd.com/Barcode
Richard, I love your work and dedication. Thank you, Sir. Please keep up the excellent work. One thing...the resolution too poor here. Literally gives me a headache when I blow up it to watch on my big screen. Can you please reupload at a minimum of 720p? Preferable up to 4K? Thank you.
Yeah, I feel ya. This video is about 10 years old. All of my new stuff is in 720p. You can find the updated version of this here: 599cd.com/ACB1
You are the G.O.A.T
Thanks. :)
Hi Richard! Is this tutorial applicable for the windows 10 access 2020 version ? You explain really well, I’m a complete beginner... I enjoyed watching the tutorial and learnt a lot already! Thank you so much 😊
Most of my newer lessons are valid from Access 2007 until 2019 (there is no 2020 version). There have been some changes, but most of them aren't geared towards beginners, so you'll be just fine.
Thank you Richard 👍😊
Brilliant video and teaching!! This has probably been asked..
Have you ever built a form with queries?
Is it better to write forms directly from tables..or.. First build queries and then build your forms.
Why im asking is because ..in your other videos you say "you don't want anyone to touch your tables" so is it safe to create your forms with tables directly..or do i first create queries..and the create forms qith the queries?
Much appreciated!!
You can build a form off of a query if you want, but your forms should always be based off one a SINGLE TABLE. If you need to bring in other information for display purposes, that's fine. But don't try to join two tables together and then be able to EDIT records from both of those tables in the same form. Use a form with a subform. One of my members recently asked a similar question. I've got a video coming up on this soon.
Great Class, Thank you. I want to create a CRM (Contact Relationship Management) Database and then add on campaigns for my Business. I am a Realtor, Can you help me learn that too? Look forward to hearing from you,Gail
Sure... I'd recommend continuing on with Level 2... 599cd.com/ACB2
Hi, when in 'table' layout, creating record rows/data input, is it possible for Access 10 to detect and auto type matching record data that has been previously inputted? Example, previously inputted 'United States' would auto type (into row cell) from the first typed letter 'U' (and additional letters [ni..] if needed for detection against similar words) for convenience and speed of data input?
If this can be done, how is it possible please??
Not easily, no. You could use a combo box, but then you have to pre-populate the values. You could use an AfterUpdate event to add new items to that combo box table, but then we're back to what I originally said: not easily. LOL
Dear Sir, it helps me a lots thank you and please show me purchase sales plus and minus store management.
No idea what you mean.
Dear Sir, I want to know how to make sum for receiving, issuing and the net balance in stock. please send me the link kindly
599cd.com/Inventory
@@599CD Thank you sir May God bless you.
Hey Rich ! Is it possible to create a hash from an input string and store it in a table. Thanks
Sure, I suppose. :)
Excellent tutorials
I notice in one of your tutorials. Foreign Key automatically appears on new record even before you enter data.
Which video to you cover that?
599cd.com/Relationships
Hi, do you have a tutorial for making an ER diagram of a database made in MS access?
Nope. Sorry. I never really got into all that database theory stuff. My knowledge of Access is all practical - from building real-world databases for companies over the past 30 years. Not much need for ER diagrams there. Maybe one of these days I'll read a "real" book on database theory. :)
Speaking of database I am nor day nor beast, I am nor good nor evil, I am Earth and I am nature, I am me. It took me years and years of experience and self realization until I have found out who I am or partly of things that I am. You can encode that to your database.
Uhm... OK... ???
Thank you, please help How to autoinsert new field in access table based on criteria?
Append Query? I don't know what you mean. 599cd.com/Append
Hi. Can you help me please. I need to create a Course name and its Primary key in a row but I also need to insert MULTIPLE Subjects into this row. How to do that????
You'll need a separate related table. 599cd.com/Relationships
Can I change the font size to 11 in the zoom box permanently?
When you change the font settings in the Zoom box they should remain permanent.
Good day, could I have questions that I must face when I write exams: for Access
I'm sure you could.
Hi i want to make a database in the information of students and when i print a report it will automatically print whatever form i print with a different name please help me .
What do you mean by "print whatever form I print?" I need more specifics. Post them here: 599cd.com/AF
very clear and helpful for me as a beginner. hi sir may i ask a free copy of microsoft access 2010. thankyou & God bless
You mean the software itself? I don't provide that. Go to microsoft.com
If you're looking for my older tutorial that covers 2007, 2010, and 2013, go here: 599cd.com/AC2013B1
Dear Mr Richard, I have an access data base split in two parts back end and front end, i want to run my front end file from any computer or mobile via internet browser, I have study some ideas on net, for example share point or publish a data base but can not achieve success, can you help me by create a video about this. Regards, Muhammad Sarfraz from Pakistan.
See 599cd.com/AccessOnline
i am no good for now in access, but i am learning , can anyone help me how to show my members info with their types of loan and loan amount. thank you.
599cd.com/Amort
How can we get DISTINCT COUNT in MS Access thru query? Can you help me?
599cd.com/Aggregate
2021 sept from Uganda but I can't manage to sit 3 hrs so am learning in phases ,but thanx alot
That's the beauty of video... watch as much as you can... pause... get dinner... come back later. :)
Dear sir, I would like to learn by you and I’m a beginner how can I join?
Click the JOIN button or go to 599cd.com/TH
HOW to bring ICON onthe Status Bar?
You can change the application icon in the database settings.
table .. same in excel n access
pivot/query ... same in excel n access👍
A CROSSTAB query is like a Pivot in Excel. 599cd.com/Crosstab
thnx
crosstab query 👍
I whant to see this video in hindi language. So what should I do. Can you help me sir.
Please 🙏
Well, I have no time nor desire to learn Hindi, so you'll have to find someone to interpret it for you. Good luck. :)
Where can i find the bigginer level 3 because I completely watched this video
599cd.com/ACB3
@@599CD Thank you sir
I have messed something up in our database - can anyone help?
I don't provide consulting, but you can try: 599cd.com/AccessDev
how do i download the video please?
599cd.com/ACB1L - you'll find a download link
u should have used forms to fill data in tables ... lesson 6 .
i guess ..
I'm the developer. It's OK if I work with the tables. Your END USERS should stick to forms.
@@599CD ... realised that , a few seconds later in d vid 😅
Hope that, after you go to heaven, all your premium videos will be available in youtube (free); wishing your journey to heaven early. Ms access is wonderful for single-user-personal-use; no language needs to be learnt, for tiny projects.
Did you just hope that I die soon? Man, that's harsh.
kristans weekly yearly bday 10th bashhh
LOL
Access DB Beginner
Welcome
To be honest. The way you explain is good but after every sentence you say I will cover or I will explain this in the future 🙄🙄🙄🙄 . People are telling that do not put today's task or work to tomorrow.!!!!! Really not good !!!!
I'm letting people know that something they might be wondering about WILL be covered in a future lesson. I can't cover everything at once. Space and time do not work that way. You can't cover ALL of Calculus in one hour-long session, right? This is a BEGINNER tutorial. See this: 599cd.com/FutureLesson