|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Access Developer 23 Lessons Welcome to Access Developer 23. Total running time is 94 minutes plus 184 minutes of FREE bonus material. Lessons
Database FilesResources
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 this lesson, you will learn how to manage rental inventory and order processing in Microsoft Access. We will talk about scanning rental items in and out, adding and using serial numbers or barcodes, and building a full order entry system with a printable invoice. You'll also see how to create an order list, add product selection features, and track inventory with a product history table. We cover critical tasks like copying customer address data, controlling order shipment status, and locking shipped orders to prevent changes. This is Access Developer Level 23.TranscriptWelcome to Microsoft Access Developer Level 23 brought to you by AccessLearningZone.com. I am your instructor, Richard Rost. In today's class, we are working more with record sets.Today we are going to cover scanning in and out rental items, building an order entry system with a printable invoice, and tracking inventory. I will be using Access 365, which is roughly close to Access 2019. Everything I cover in today's class should be good going back to, I am going to say, 2007. This class follows Access Developer 22. I strongly recommend you watch that class first. And of course, all of my previous classes from the beginner, expert, advanced, and developer series, especially 16 and on, where we start covering record sets. If you have any questions regarding the material covered in today's class, just scroll down to the bottom of the page that you are on and post them there. Also, take a minute to read through any of the other questions that have been posted as your question may have already been answered. Make sure you click on the big red subscribe button to get notified if any other questions or comments are posted for this class. If you have any questions that are not about the material covered in today's class, feel free to post them in the Access forum on that website. Now, let's take a closer look at what is covered in Developer 23. In lesson one, we are going to build a form to do rental inventory. This is where you have either books, videos, tools, or a library - whatever you have rental inventory needs to track. You have a specific item like a book. You have a list of customers. The customers will check out those items. They are due back in on a specific date. You check it out, check it in. You have to lock the customer field, lock the buttons. Do all kinds of things. We will scan in and out rental items in lesson one. In lesson two, we are going to take our rental inventory database and add serial numbers to the items. These serial numbers can be whatever you want. You can print out barcode labels if you choose to and you can put those on your items. Then we will scan those out by scanning in the barcode number or the serial number. Then we will be able to scan them back in batches. So if a whole bunch of books come back, you can just go scan, scan, scan, scan into a text box, hit the process records, and then our record set will loop through all of the items. It will check them, make sure they were out, check some other rules, and then scan them back in. In lesson three, we are going to build a simple order entry system, including an order entry form with a subform and a printable invoice. In lesson four, we are going to continue with the order entry system. We are going to build an order list form so we can see all the orders in the system. We are going to copy the customer's address information to the order when the order is placed. That way, you have a history of where that order was shipped to. We are also going to add a product selection box so you can pick a product from a list, hit add, and it adds it to the order. You do not have to type in the order information and the pricing and all that stuff. In lesson five, we are actually going to track inventory out in our system. We will create a product history table so we can audit the transactions. Every time product goes out, I want to know about it. We will add "is shipped" to each order, so I know if this order has been shipped or not. We do not want to ship the same order twice. We will lock down that order once it has been shipped, so they cannot change any of the details or delete it. Then we will make our ship order button. We will check to make sure the order has been paid first and that it has not already been shipped. We will run through all of the items first with a record set and make sure we have enough quantity to ship all the products on this order. If so, we will ship it and tell the user the order has shipped successfully. Then we will remove those products from the inventory. QuizQ1. What is the primary focus of Microsoft Access Developer Level 23?A. Learning basic database design principles B. Working with record sets, rental inventory, order entry, and inventory tracking C. Writing advanced SQL queries only D. Designing table relationships for the first time Q2. Which version of Access is showcased in this class? A. Access 2003 B. Access 2019/365 C. Access 2000 D. Access 2013 Q3. What feature is added to rental items in lesson two? A. Customer reviews B. Serial numbers and barcode scanning C. Rental insurance calculation D. Late fee tracking Q4. What is the advantage of adding barcode labels to rental items? A. It allows price calculations B. Enables quick scanning in and out of items C. Sends automatic emails to customers D. Automatically renews rentals Q5. In the order entry system built in lesson three, what functionality is included? A. Shipping management only B. Order entry form with a subform and a printable invoice C. Emailing customers about their orders D. Customer loyalty points tracking Q6. What enhancement is made to orders in lesson four? A. Orders can have video tutorials linked B. Product selection box and copying customer addresses to the order C. Multi-language support for orders D. Automatic reordering suggestions Q7. Why does the order entry system copy customer address information to the order when placed? A. So that orders can be printed in bulk B. To preserve the shipping history as it was at the time of the order C. For calculating shipping fees D. To integrate with a third-party shipping provider Q8. What key functionality is added in lesson five regarding inventory? A. Importing inventory data from Excel only B. Creating a product history table for auditing transactions C. Generating monthly sales reports only D. Automating returns processing Q9. What is the purpose of adding an "is shipped" field to each order? A. To enable order deletion after shipment B. To prevent shipping the same order twice and lock it after shipment C. To allow customers to track their package online D. To calculate the shipping cost automatically Q10. Before shipping an order, what does the system check? A. If the customer has a newsletter subscription B. If the order has been paid and not already shipped C. If shipping labels are available D. If the order is linked to a promotion Q11. How does the system ensure enough inventory for an order? A. It estimates shipping times B. It runs through all items with a record set to make sure there is enough quantity C. It contacts suppliers automatically D. It allows negative quantity in stock Answers: 1-B; 2-B; 3-B; 4-B; 5-B; 6-B; 7-B; 8-B; 9-B; 10-B; 11-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 focuses on Microsoft Access Developer Level 23. My name is Richard Rost, and in this lesson, we will advance our work with record sets.In this class, I'll be showing you how to scan rental items in and out, build an order entry system that includes a printable invoice, and manage inventory tracking. I'm using Access 365 for these demonstrations, which is very similar to Access 2019, and all the techniques I teach today should work back to Access 2007. This course builds directly on material from Developer Level 22, so I highly recommend reviewing that class first. It is also helpful to be familiar with my earlier courses, particularly Developer Level 16 and onward, since those start to dive into record set programming. If you have questions about anything in today's class, you can scroll to the bottom of the course page and leave your comments there. I also suggest reading other students' questions, since your concerns might have already been addressed. Be sure to subscribe using the large red button, so you are notified if any updates or new questions are posted for this course. For questions that are not directly related to today's material, please use the Access forum on my website. Here's a summary of what we will cover in Developer 23. To start off, in lesson one, we will design a form for managing rental inventory. This is suited for businesses that rent out items such as books, tools, or movies. The purpose is to keep track of individual items, customers, due dates, check-out and check-in status, and enforce proper locking of fields and controls. The main focus will be on managing the process of scanning items in and out for rental. Next, in lesson two, we will enhance our rental system by adding serial numbers to the inventory items. These serial numbers can be printed as barcodes if you wish and attached to your rental items. When renting items out or checking them back in, you can use these barcodes for quick scanning, making batch returns much faster and more efficient. We'll set up a process where multiple items can be returned by entering or scanning their numbers into a text box and processing them all at once. The record set for this lesson will cycle through the entries, verify their rental status, check any rules we set up, and update their return status accordingly. In lesson three, we will shift to building a simple order entry system. This includes creating an order form, a subform to handle multiple order items, and generating a printable invoice for each order. For lesson four, development of the order entry system continues. I will show you how to create an order list form for viewing all orders, and teach you how to copy the customer's address information into the order at the time it is placed. This allows you to keep track of the shipping address history. We will also add a product selection feature that lets you pick a product from a list and add it to the order, eliminating manual data entry for product information and pricing. In lesson five, we will focus on inventory tracking as orders are processed. We will introduce a product history table to audit every inventory transaction. Each time an item leaves inventory, details will be recorded. We'll add an "is shipped" status for every order to ensure no order is shipped more than once, locking the order record after shipment to prevent further changes or deletion. The shipping process will include validations: confirming that payment has been received and that the order has not already been shipped. We will check product quantities, and if there is enough stock, the shipment will be processed and inventory levels will be adjusted accordingly. 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 a rental inventory tracking formScanning rental items in and out Locking form fields and buttons for check out/in Adding serial numbers and barcodes to rental items Processing batch check-ins using barcode scanning Validating rental items during batch check-ins Building a simple order entry system Creating an order entry form with subform Generating printable invoices Developing an order list form Copying customer address to new orders Adding product selection to orders Tracking inventory on shipped orders Creating a product history audit table Adding shipped status to orders Locking orders after shipping Validating payment and shipping status before order fulfillment Checking inventory quantity before shipping Processing order shipments and updating inventory |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: access developer 23 lessons PermaLink How To Track Rental Inventory, Scan Barcodes, and Build Order Entry Systems in Microsoft Access |
