|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Access 303 Welcome to Access 303. Total running time is 77 minutes. Lessons
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 303, you will learn advanced techniques in Microsoft Access such as building an order list query and form, using the DoCmd.OpenForm command with VBA, and handling double-click events to open related records. We will discuss when it's appropriate to store duplicate data in your tables, how to set up separate billing and shipping fields, and explore important form events like OnDblClick and AfterUpdate. You'll also learn about creating your own subroutines, public versus private subs, and calling subroutines from other forms. This is lesson 303.TranscriptWelcome to Microsoft Access 303, Access Developer Level 3, brought to you by accesslearningzone.com. I am your instructor, Richard Rost.In today's class, we have a lot of different objectives to cover. We are going to build an order list query and an order list form so you can see a list of all of our orders. We will be able to double-click on one of the orders to open up the order, or double-click on the customer to open up that customer. We are going to learn more with the DoCmd.OpenForm command, which will allow us to open forms using our VB code. We have seen that in the previous class, and we are going to do more with it in this class. We are going to learn when it is prudent to have duplicate data in our tables. We are going to create duplicate address data in our order form. You will see why. We are going to allow the user to save different bill-to and ship-to fields, for example. We are going to learn about the OnDblClick event and the AfterUpdate event, which are form field events. We are going to see how and why you want to create your own subroutines. We will learn about public versus private subroutines and calling subs on other forms. For example, you are on the customer form and you want to call a sub on the order form. We will see how to do that. This class follows Microsoft Access 302. You should have taken all the classes from 101 up to 302 before this class, or at the very least 301 and 302, if you are an advanced Access user. In this class, we will be using Microsoft Access XP and Windows XP. However, the lessons are valid for just about every version of Access. The sample database files used in today's class can be found at accesslearningzone.com/access/303. If you installed this video series from the program off our website or off CD, you can also find it in the help folder under your program files. You will, of course, benefit by doing the examples yourself. I recommend that you build this database yourself from scratch, starting with Access 101. But if not, you can get the PREV Access 303 database, which is the one that is after 302, and do today's examples working off of that database. QuizQ1. What is one of the main objectives covered in Access 303?A. Building an order list query and an order list form B. Learning Microsoft Excel formatting C. Creating PowerPoint presentations D. Managing email accounts Q2. What command will you learn to use more extensively in this class? A. DoCmd.SendObject B. DoCmd.DoMenuItem C. DoCmd.OpenForm D. DoCmd.Close Q3. Why might you want to have duplicate data in your tables, according to this class? A. To improve table relationships B. To allow different bill-to and ship-to fields to be saved C. To reduce database size D. To make backup copies only Q4. What form field events will you learn about in this class? A. OnClick and OnKeyPress B. OnMouseMove and OnLoad C. OnDblClick and AfterUpdate D. OnOpen and OnClose Q5. What is the difference between public and private subroutines discussed in this class? A. Public subs can be called from other forms, private subs cannot B. Private subs can be called from everywhere, public cannot C. Both are accessible everywhere in Access D. They are only used in macros Q6. What should a student do for best results with the course examples? A. Only watch the videos B. Practice by building the database from scratch, starting with Access 101 C. Use Microsoft Word to create forms D. Skip to Access 303 without earlier courses Q7. Where can the sample database files be found for Access 303? A. Nowhere, they are not available B. In the help folder under your program files or at accesslearningzone.com C. Only in printed textbooks D. Only via email request Q8. Which versions of Microsoft Access are these lessons applicable to? A. Only Microsoft Access XP B. Only Microsoft Access 2010 C. Just the newest version D. Just about every version of Access Answers: 1-A; 2-C; 3-B; 4-C; 5-A; 6-B; 7-B; 8-D 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 covers the material in Microsoft Access 303, Access Developer Level 3. I'm Richard Rost, your instructor.In this class, we are going to cover several important topics to help you develop your Access database skills further. We'll start by building an order list query and an order list form so you can easily view all the orders in your system. I will show you how to set up the form so you can double-click on an order to open its details, or double-click on a customer to open that customer's record. We'll take a deeper look at the DoCmd.OpenForm command, which lets us open forms using VBA code. This will expand on what you learned in the previous class, giving you even more control over how your forms interact. Another important concept we will discuss is when it makes sense to include duplicate data in your tables. For example, in the order form, we will set up duplicate address fields, such as separate bill-to and ship-to addresses, to handle practical situations where this is necessary. You will also learn about form field events, specifically the OnDblClick and AfterUpdate events, and how to set up your own subroutines to make your code more organized and efficient. We'll cover the difference between public and private subroutines and demonstrate how to call subroutines on different forms. For instance, you might be working on the customer form and need to run a subroutine that's defined in the order form. I'll show you how to accomplish that. This class follows Microsoft Access 302, so you should have completed all the prior courses from Access 101 through 302, or at least 301 and 302 if you already have advanced experience with Access. For this course, I use Microsoft Access XP and Windows XP, but the lessons are applicable to nearly all versions of Access. The sample database files that go along with today's class are available on my website under access 303. If you bought or downloaded this video series from my website or from a CD, you can also find these files in the help folder within your program files. You'll learn best by working through the examples yourself. I recommend you build the database from scratch, starting with Access 101. However, if you prefer, you can download the PREV Access 303 database, which is the version right after 302, and follow along using that. 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 ListBuilding an order list queryCreating an order list form Using DoCmd.OpenForm in VBA code Allowing double-click to open order forms Allowing double-click to open customer forms Handling duplicate data in tables Creating separate bill-to and ship-to address fields Using the OnDblClick event in forms Using the AfterUpdate event in forms Creating custom subroutines in VBA Public versus private subroutines in VBA Calling subroutines on other forms |
||
|
| |||
