|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Access Beginner 2 Lessons Welcome to Access Beginner 2. Total running time is 1 hour, 45 minutes. Lessons
Database Files
Course Notes
What's Next?Links
Resources
Questions?Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you! Subscribe for UpdatesIf you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
IntroIn lesson 1 of Microsoft Access Beginner Level 2, we will learn how to download the sample database from Access Beginner 1, handle security warnings, set up trusted locations, and create desktop shortcuts. Lesson 2 covers rebuilding and customizing customer forms, working with controls, and changing colors. In lesson 3, we continue with form design, exploring object sizing and the differences between grid dots and grid lines, plus more on themes. Lesson 4 introduces table relationships, primary and foreign keys, setting up an appointment table, and using default values and date functions. Lesson 5 focuses on building an appointment form, creating combo boxes with wizards, and adding command buttons.TranscriptWelcome to Microsoft Access Beginner Level 2 brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.This is Level 2 of my Beginner's Guide to Microsoft Access Database Design. This class follows Access Beginner Level 1, which I strongly recommend you watch first before continuing with this class. Access Beginner Level 1 is absolutely free. You can find it on my website right there. It is also on my YouTube channel. It is about four hours long and covers all the basics and the fundamentals that you should know before watching today's class. As I always say, my lessons are meant to be followed one after the other, so please do not skip levels. This class is recorded with Access 365, roughly equivalent to Microsoft Access 2019. However, if you are using Access 2016, you should be fine as well. If you are using an older version of Access, come to my website and get the version that is for you. The classes are broken up into Beginner, Expert, Advanced, and Developer. This is Level 2 of the Beginner Series. I recommend you sit back, relax, watch each video once through, and pay attention to details. Then watch the video again and build the database with me. Do not just grab the copies off my website, which you can download, but it is better if you build them yourself. Keep an open mind and watch the video again if you have to. The material is not that hard to learn. That light bulb will go off. You will get it. Trust me. Avoid building serious projects until you get to at least Expert Level 2, because you are going to learn a lot of things between now and then. Build the class database, build a hobby database if you collect baseball cards or whatever. Do it for fun. Use Access for fun. You will get there. OK, let's take a look at exactly what we are going to cover in today's class. In lesson one, we are going to get started for the day by downloading the sample database from my website that we built in Access Beginner 1. We will talk about a security warning that you get if you run an unfamiliar database. We will show you how to set up a trusted location on your computer or on your network so you can put databases in there and not have to deal with that security warning. I will show you how to set up a desktop shortcut to your database, and we will go over a quick review of what we covered in Level 1. In lesson two, we will be working with Form Design. We are going to rebuild the customer form that we started in Access Level 1. We will learn how to add, move, and resize controls, align and size objects, and we will change the foreground and background colors. In lesson three, we are going to be continuing with Form Design. We will be focusing on more form-adding. I will show you how to size objects to the grid. We will talk about grid lines versus grid dots. I get the email all the time from people. Some people see the grid lines, some people see the grid dots, and I will show you how to switch between them. Then we will do a lot more with working with colors and with themes. In lesson four, we are going to get a brief introduction to relationships in our database. We will learn why we want to use relationships, the different types of relationships, the difference between primary and foreign keys, we will set up an appointment table, and learn about default values and the date and now functions. In lesson five, we are going to build an appointment form very similar to the customer form that we built in the last class. We will make a customer combo box using the combo box wizard so we can pick a customer from a drop-down list of customers for the appointment. Then we will learn about the command button wizard so we can make a button to open up the form and show just appointments for the customer that we are on. There is a lot of cool stuff in lesson five. QuizQ1. What does the instructor recommend you do before starting Access Beginner Level 2?A. Watch any video you want B. Begin building your own serious projects C. Take Access Beginner Level 1 first D. Skip to Advanced Level directly Q2. Which version of Microsoft Access is this tutorial recorded with? A. Access 2010 B. Access 2016 C. Access 365 D. Access XP Q3. What is the recommended way to learn according to the instructor? A. Skip ahead to developer topics B. Watch the whole series in one sitting C. Watch each video, then build the database yourself D. Only download completed databases from the website Q4. According to the class outline, what will you learn to set up regarding database safety? A. Automatic backups B. Security warning handling and trusted locations C. Cloud synchronization D. Data encryption techniques Q5. In lesson two, what is the main focus while working with forms? A. Writing VBA code B. Building reports C. Adding, moving, and resizing controls and working with colors D. Importing data from Excel Q6. What will you learn about grid lines and grid dots? A. How to write macros for them B. How to switch between them in form design C. How to remove all grid guides from Access D. How to print grids on your reports Q7. What is introduced in lesson four? A. Importing external data B. Relationships between tables C. Advanced SQL queries D. Automation with macros Q8. What is the difference between a primary key and a foreign key as mentioned? A. Primary key identifies the table, foreign key is for security B. Primary key is always a number, foreign key is always text C. Primary key uniquely identifies records, foreign key creates relationships D. There is no difference Q9. In lesson five, which control will you use to select a customer for an appointment? A. Checkbox B. List box C. Combo box D. Option button Q10. What does the command button wizard help accomplish in lesson five? A. Create a report of all customers B. Open a form to show just appointments for the current customer C. Automatically backup the database D. Change the theme of the database Answers: 1-C; 2-C; 3-C; 4-B; 5-C; 6-B; 7-B; 8-C; 9-C; 10-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone is Microsoft Access Beginner Level 2. I'm your instructor, Richard Rost.This is the second level of my Beginner's Guide to Microsoft Access Database Design. It is important that you begin with Access Beginner Level 1 before proceeding with this class. The first level is completely free and available on both my website and YouTube channel. It runs about four hours and introduces all the basic concepts necessary before starting today's material. I design these lessons to be taken in order, one after the other, so please do not skip any steps. The material in this class is demonstrated using Access 365, which is similar to Access 2019. If you are using Access 2016, you should have no issues following along. If your version is even older, visit my website to find a class that matches your program. The curriculum is divided into Beginner, Expert, Advanced, and Developer levels. This course is the second installment of the Beginner series. My recommendation is to watch each lesson all the way through once, paying close attention to the details. After that, watch it again while building the database alongside the instruction. Although you can download the database files from my website, building them yourself is far more beneficial for your learning. If you feel stuck, keep an open mind and rewatch any parts of the lesson you need to. The material is not too difficult, and with practice, it will start to make sense. Stay patient and you will master it. Hold off on attempting serious database projects until you reach at least Expert Level 2. You will gain many useful skills as you progress further. For now, focus on the class database or create a fun, personal project such as a collection or hobby database. Enjoy the process and let Access be a fun learning experience. Here is what we are going to cover in today's course: In the first lesson, we start by downloading the sample database we built in Access Beginner 1 from my website. We'll address the security warning that appears when you open a database from an unfamiliar source and show you how to designate a trusted location either on your computer or your network to avoid this warning. You will also learn how to create a desktop shortcut for your database, along with a quick review of the topics from Level 1. The second lesson moves into working with Form Design. We will recreate the customer form from Access Level 1. You will learn how to add, move, resize, align, and match the sizes of controls, as well as customize the foreground and background colors. In the third lesson, we continue with more form design concepts. This includes aligning objects to the grid, clarifying the difference between grid lines and grid dots, and instructions for toggling between these two view options. We'll continue to experiment with color customization and working with themes. The fourth lesson introduces the concept of relationships in your database. We will discuss why relationships are important, explore the various types, clarify the distinction between primary and foreign keys, set up an appointments table, and explain default values along with the Date and Now functions. Lesson five involves building an appointment form very similar to the customer form from the previous class. You will make use of a combo box wizard to create a dropdown list of customers. This allows you to select a customer for each appointment. Additionally, you will learn to use the command button wizard to create a button that opens the form and filters it to display only appointments for the current customer. There is a wealth of useful content in this section. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListDownloading the sample database from Beginner Level 1Dealing with Access security warnings Setting up a trusted location in Access Creating a desktop shortcut to a database Review of Access Beginner Level 1 concepts Rebuilding the customer form in Form Design Adding, moving, and resizing controls on forms Aligning and sizing objects on forms Changing foreground and background colors on forms Sizing objects to the grid in Form Design Switching between grid lines and grid dots Using colors and themes in form design Introduction to table relationships in Access Understanding primary and foreign keys Creating an appointment table Setting default values in tables Using Date and Now functions in tables Building an appointment form Adding a customer combo box with the combo box wizard Creating a command button to filter appointments by customer |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: access beginner 2 lessons PermaLink How To Design Forms Set Up Relationships And Build Appointment Forms In Microsoft Access Beginner 2 |
