Microsoft Access Beginner Level 2 Complete FULL Course. Form Design. Intro to Relationships. More!
HTML-код
- Опубликовано: 6 авг 2024
- This is my complete Microsoft Access Beginner Level 2 course. It runs 1 hour and 45 minutes. This course follows Level 1 which you can find fore free on my website and my RUclips channel.
LEVEL ONE:
599cd.com/ACB1
• Microsoft Access Begin...
If you are interested in Level Three, that can be purchased directly from my website for just US $1 here:
LEVEL THREE:
Access Beginner 3: 599cd.com/ACB3L
LEVEL TWO TOPICS
00. Introduction (00:00)
01. Getting Started (04:08)
02. Form Design 1 (13:09)
03. Form Design 2 (26:00)
04. Intro to Relationships (38:52)
05. Appointment Form (54:45)
06. Q&A From Students (1:15:10)
07. Review & What's Next (1:40:22)
In Lesson 1, we will download the sample database from Level 1. We'll learn about the security warning and what it means that "active content has been disabled." We will set up a Trusted Location on our computer to put our database files in, and then make a shortcut to our database on the Desktop. We'll go over a quick review of the topics covered in Level 1.
In Lesson 2, we will begin rebuilding the customer form we started in Level 1. We will learn how to add, remove, and resize controls. We'll see how to align and size objects relative to each other. We'll see how to modify the foreground (font) and background colors.
In Lesson 3, we will continue working with form design. We'll focus on additional kinds of form formatting. We'll learn the difference between the grid lines and grid dots, and how to change between them. We'll learn how to size objects to the grid. We'll work with some additional object properties like colors, outlines, and fonts. We'll learn about Themes.
In Lesson 4, we will get an introduction to relationships, one of the most important features of an Access database. We will learn what relationships are, why we want to use them, and about the different types of relationships. We'll learn about primary and foreign keys. We'll build a table to track appointments for each customer. We'll learn how to set default values using the Now and Date functions.
In Lesson 5, we will continue working with relationships. We'll build an appointment form. We'll learn how to build a relational combo box so we can pick a customer from a list of customers. We'll make a command button so that we can open the appointment form and see just the appointments for the selected customer.
Finally, we'll take some time to go over popular questions that I've been asked over the past 20 years of teaching this course. We'll discuss customizing the Ribbon and the Quick Access Toolbar. What's the problem if you can't see text as you are typing into a form? How to print a form in design view. How to get your AutoNumbers to start higher than 1. What's a combo box that's always open? What is the maximum size of an Access database, and the max number of fields per table. Can you run Access on a Mac? How to restore a deleted textbox. What's the green triangle that shows up on your fields in design mode. What is a #Name? error? How to deal with "unrecognized database format" errors. Can you change the background color of a checkbox? How to put data from multiple tables on a form. What are the thumbtacks on the file list for? What's an LACCDB file?
LINKS:
Full Beginner 1 Course: 599cd.com/ACB1
Get Beginner Level 3 here: 599cd.com/ACB3
TechHelp Video Series: 599cd.com/TechHelp
TechHelp Free Templates: 599cd.com/THFree
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access tutorial, ms access, access 2016, access 2019, access 2021, access 365, #msaccess, #microsoftaccess, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, access beginner 2 form design, intro to relationships, combo box, appointments
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![Jordan Adetunji - KEHLANI REMIX (feat. Kehlani) [Official Video]](http://i.ytimg.com/vi/EeJ8n5PxFGE/mqdefault.jpg)
Biggest fan from Sierra Leone-West Africa. You deserve reserved of our appreciation. Thumbs up
i was watching one other course about Access on youtube , at first the course was going good and understood everything
but at some moment the tutor went off on the relationships and IDs and two tables in the same time lol I was confused and still didnt understand why we even need more than one table, the explanation was more complcated than the subject itself, but man the moment I scrolled down I found your video , everything is well explained and I repeated some of the things I already learned but your teaching , experience and the real life examples you give made the past 8 hours fly .
your biggest fan from Morocco much Much respect and I mean it .
It's been great to relearn Microsoft Access 2010 with you ! In my ICT days, I designed a database for consumables, as I was responsible for ordering, maintain correct stock level, not under or over, "sales" as in providing the the users with consumables.It was easy to queries and reports, say monthly cost per department. Database was far from perfect, but I had fun creating it, made my day easier. The "sales price" I never worked out, unfortunately. I used paper and pen, when handing out consumables, I used "the oldest price" from my list, and ticked one less :)
Nice!
For the record, I love this class. The flow is easy; the lessons are designed for anyone to follow. I have used Access before, but I have never designed one. So, I am enjoying learning to design a database.
Thank you.
You're very welcome!
Thanks Mr. am grasping something really have passion in programing, hope will get there.
Excellent ! Brushing off my Access 2010 skills, it's been a long while. Super easy to follow along course, good pace. I'm aware 2010 version is old, but it's all I really need.
Glad it was helpful!
That's the version I've been using since it came out and it's bought and paid for many times over. No yearly fee
After completed your beginner 1 class , I felt so blessed that now I really know much better now when creating database with Ms Access 2010..Thank you very,very much..May God dearly richly bless you for your tutorial class..
You are most welcome
Thank you for your help. Your teaching is quite recommending. God bless.
Welcome
U made it simple man ur subscribers are well deserved
Thanks.
You are a good teacher.
Thank you! 😃
Thank you. When you level 3 will be posted. I found it so helpful.
When Level 2 gets enough Likes
totally agree with u mate! im kind of a newbie to soft producing here, well tNice tutorials video helps a lot and gives mo motivation to create
Great to hear!
Great Stuff😊😊😊
Thank you
Now I can say "Hello World" using MS-Access. Thank you a lot, direct from Brasil.
I love your tutorials they are a brain opener. I have been looking for beginners lesson 3 full course but I have not been able to find it. Please help.
599cd.com/ACB3
If you see something saying I hit the dislike button please ignore it (I caught it by accident)
Your videos are brilliant! Very helpful and well delivered
Glad you like them!
Hello Richard, I've been watching tons of your videos and I appreciate the time and effort you put into teaching us Microsoft Access. Your video helped me so much that I am now one of your supporters. Now I builted my DataBase. Here's my problem, I have an order Table and Client Table, and a report. The report has an order number, the quantity from the order table, etc, and the client from the client Table. when I print the report it prints the Client number and not the name of the client. I would appreciate pointing me to the right video. Thanks, Stephan
Sounds like you just need to join them together in a query first. Have you watched my invoicing video? 599cd.com/Invoicing
Keep going you are amazing 😍 when will be the next video
Not sure yet
Hi Richard! I use Access from Microsoft 365, and I noticed that when I open up the forms in Form View, the boundary that you set is not there, so the whole page is light blue, unlike what you showed in the video that outside the form boundary is gray. Is there a setting I should change to achieve the look shown in the video, with form boundary showing in the Form View?
599cd.com/OverlappingWindows
What's the best book for Access you can recommend ? I like Bibles, I'm just after something which covers everything, with screenshots and examples.
599cd.com/QQ
hello, my Access teacher, i have problem in the part of making the appointments button, i am using Access 2007, my problem in setting the wizard in the appointment button in matching the primary key of CustomerF to AppointmentF, in the column of CustomerF no items are shown, so my appointment button is just show the Appointment form what should I do?
I really can't picture what you're talking about without seeing it so why don't you post this on the forums on my website since you remember and include some screenshots so we can see what's going on there 599cd.com/AF
@@599CD its now okay, i just done troubleshooting it, its on the version problem, now i am using office 365, thank you teacher
How do I create a Unique Identifier that is not an AutoNumber and make it my Primary Key?
599cd.com/QQ
How do you add multiple customers ID on the second form without inputting each one multiple?
I don't understand what you mean
Thanks for tNice tutorials content. It was the first soft soft video I've seen that didn't assu I knew my way around all of the functions.
Welcome
Interesting although long video
It's the whole course in one video. People seem to prefer that over the individual lessons.
How do you use 2 table interfaces at the same time? braking my brain !
Huh?
My new project is, a database for Microsoft Flightsimulator 2020, aircrafts, airports, sceneries, add-ons !
Sweet
Using word description as a field name is not a good practice because Description is also Reserved Word....
Yeah... I've been meaning to make a video about this. There are "no no bad" reserved words, and then there are "kinda meh" reserved words. Words like Date are "no no bad" words because Access will almost always think you mean the Date() function. Yes, Description is technically a reserved word, but it's a property, so you can get away with using it as a field name 99% of the time without issues.
When u first used a phone in ur life it probably was complicated too.
No... pretty sure I got that right away. :)
too
Huh?