|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Access Developer 14 Access Developer 14 covers The Easy Access POS, Lessons 1-5. Lots of people have asked me to build an easy-to-use and easy-to-customize POS system in Access. Access Developer 14 covers just that. We will begin building something that I call the Easy Access POS. This will be a full-featured Point of Sale system that is built completely in Microsoft Access that you will be able to customize to your needs. Whether or not you need a POS system, the techniques and concepts covered in these lessons are a must for any Access developer. ResourcesTopics Covered
In Lesson 1 we will begin by learning about the database we're going to be building: The Easy Access POS. We'll talk about the features it will have, see the layout of the screens, and discuss possible future upgrades. Lots of you have asked me to spend more time on planning and laying out databases ahead of time. Here you go!
In Lesson 2 we will review the comments from Lesson 1, go over some changes, and begin building the tables for the POS database.
In Lesson 3 we are continuing with building the tables for our POS database.
In Lesson 4 we we will start building the Order Form, adding the Category, Product, and Option Lists.
Important NotePlease note that this lesson covers only the initial design of the POS system. I had intended to continue it in upcoming lessons; however, it remains unfinished. I do have plans to create a seminar or provide a template to complete this database in the future. Presently, the lesson is not finalized. If you decide to purchase this lesson, you will receive an overview of how to design and construct a POS system using Microsoft Access. Please be aware that it is not a finished product at this time. Enroll TodayEnroll now so that you can watch these lessons, learn with us, post questions, and more.
Questions?Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.
IntroIn this lesson you will learn how to start building an Easy Access Point of Sale (POS) system using Microsoft Access. We will discuss planning the database structure, determining relevant tables and fields, and exploring relationships between data. I will walk you through prototyping the system, building tables, entering sample data, and setting up a basic order entry form with product categories and options. We'll also create a form for selecting groups and people, which is useful for scenarios like school cafeterias or restaurant reward programs. This lesson uses Microsoft Access 2019, but most recent versions will work.TranscriptWelcome to Microsoft Access Developer Level 14 brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.Access Developer 14 includes the first five lessons in the Easy Access PLS, that's point of sale system. So whether you are one of my developer students watching all the classes in order or you are interested in just the Access PLS system, this is the right lesson for you. For several years now people have been asking me to build a POS system in Access. There is nothing really available on the market right now for POS systems that are built in Microsoft Access that you can customize and that are reasonably priced. For my developer students, you are going to get a lot of new techniques that I'll be covering in this series. But for those of you who are interested in just the POS, you can pick up those lessons by themselves. This is also the first time that I've recorded videos for a new class and posted them online as they are being recorded, which has given the students the opportunity to post feedback and ask questions between lessons. I can either answer them on the website or include those answers in the next set of videos. Even though Developer 14 is finished, because I always record the introduction slide last, you can still get in on developing the POS system because Developer 15, as of right now, it's July 2020, has not been recorded yet. So you can still get involved in the real-time database development. We will talk about exactly what is covered in just a few minutes, but I am using Microsoft Access 2019 with Office 365. You should be okay with pretty much any version of Microsoft Access, I would say from 2007 on. Now, if you are one of my developer students and you are following along, I do suggest Developer 13 before this one. If you are one of the students taking this as just the POS seminar, of course, you should have a good working knowledge of Microsoft Access, preferably including some VBA and some SQL. What does today's class include? First, we're going to talk about the database structure. One bit of feedback that I have gotten over the past couple of years is that my students want to see more development of the database before we start building the database. What does it look like on paper? How do I put all my fields together and my tables? How does everything relate together? We are going to spend a good amount of time doing that. About half an hour of the first lesson is just going to be talking about what fields to include, how the tables work together, relationships, and so on. You're going to see me prototype the database. I've built a lot of screens up here in PowerPoint that are going to show you how things are going to look when it's done. As you can see, these are just simple diagrams. Then we'll start actually building the tables. I'm going to spend a good hour building the tables, going through all the fields, explaining why I'm doing things the way that I am, and giving you a more in-depth understanding of how these things go together. Not just how to build the table, but why I do things a certain way. We'll fill in a bunch of sample data and see how things are going to work. Then we'll get started actually building the order form where we can pick a product category that lists the products in each category. Each product can have different options. Here you can see burgers. We've got the kids' burger, and then a list of options: add bacon, add lettuce, add a toy, cook well, and so on. In the next class, we are going to talk about multi-select list boxes, which we haven't done yet. That will allow you to pick multiple options on that option list. Finally, in today's class, we're going to build a form to allow you to pick a group and then a person in that group. This is handy if you are doing billing. For example, if you are a cafeteria that does school lunches for students, you can have your list of groups be the family, and the list of people would be the students. If you are a restaurant, you might not want to have groups or people, or you can get information from them and put them in for reward programs. However you want to handle it. A lot of places just do all-cash options. That's fine too. This will be completely configurable. I'll show you all kinds of different ways to do things. Remember, if you have any questions about the material posted in class, just scroll down to the bottom of the page that you are watching the video on the website. You will see that each one of the lessons has its own separate forum where you can post questions about that particular class. However, if you've got general questions about Access that do not necessarily fall under this lesson, you can go to the Access forums. There is a link, and you can post all of your questions there. Click on the link below the video to get started with lesson one. QuizQ1. What is the main topic of Access Developer Level 14?A. Creating reports in Access B. Building a point of sale (POS) system in Microsoft Access C. Designing websites with Access integration D. Learning Excel data analysis with Access Q2. Who is the intended audience for Access Developer 14? A. Only advanced Access developers with 10+ years experience B. Anyone interested in building or customizing a POS system in Access C. Only college students studying databases D. Access users with no prior database experience Q3. What is unique about the way the lessons for Access Developer 14 were posted? A. All lessons were released only after completion B. Videos were posted online as they were recorded, allowing for real-time feedback and questions C. Lessons were live-streamed only D. Lessons came in eBook format only Q4. Which version of Microsoft Access does the instructor recommend for following along? A. Only Access 2019 B. Only Access 365 C. Any version from Access 2007 and newer D. Only Access 2010 Q5. Before starting Access Developer 14, what does the instructor recommend for students? A. Watching Excel PivotTable lessons B. Completing Developer 13 if they are following the developer course path C. Skipping all previous lessons D. Not worrying about VBA or SQL knowledge Q6. What is one of the main focuses in the first lesson of this class? A. Writing detailed VBA scripts for reports B. Analyzing query optimization with SQL Server C. Understanding and designing the database structure before building it D. Deploying Access on the web Q7. What type of sample business examples does the instructor mention regarding group and person selection in the POS system? A. Retail stores selling electronics B. Cafeterias organizing students for billing C. Bookkeeping for construction projects D. Scheduling medical appointments Q8. What database object will the instructor spend approximately an hour building in this class? A. Reports B. Macros C. Tables D. Forms Q9. What feature to be covered in the next class was specifically mentioned as not yet discussed in previous lessons? A. Drop-down combo boxes B. Multi-select list boxes C. Report printing D. Calculated fields in queries Q10. How does the instructor suggest students ask questions related to a particular lesson? A. Email only B. Posting in the general Access forum C. Using the lesson's dedicated forum on the website D. Direct messaging on social media Answers: 1-B; 2-B; 3-B; 4-C; 5-B; 6-C; 7-B; 8-C; 9-B; 10-C 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 Developer Level 14, and I am your instructor, Richard Rost.This lesson includes the first five sessions in the Easy Access Point of Sale (PLS) system. Whether you have been following the entire developer series in order or you are primarily interested in building a POS system in Access, this will be valuable material for you. For quite a while, people have been requesting a point of sale system built in Microsoft Access. There are not many options available that offer the same level of customization or affordable pricing, so I decided to create one that everyone can use and adapt as they see fit. Developer students will discover several new techniques in this series, but if you want to focus only on creating the POS system, you can purchase just those specific lessons as well. This is also the first time I am producing and uploading new class lessons as I record them, which allows students to interact and provide feedback or ask questions between lessons. I can respond either directly on the website or incorporate those answers into the upcoming videos. Even though Developer 14 is now complete, I always finish the introduction last. Developer 15 has not yet been recorded as of July 2020, so you still have a chance to be involved with this series and see the real-time development process. I will go over the topics covered in detail soon, but I am working in Microsoft Access 2019 with Office 365. However, just about any version from Access 2007 forward should work fine for what I am teaching. If you are one of my developer students following the series, I do recommend that you complete Developer 13 beforehand. If you are here for just the POS seminar, you should already have a good working knowledge of Access, and ideally some familiarity with VBA and SQL. Now, as for what we cover in this class: we begin by discussing the database structure. Feedback from previous courses showed that many students wanted to see more about designing the database before any actual building started. So, I devote a lot of time to planning the structure on paper, discussing which fields belong in which tables, and how relationships work. You will see me prototype the database step by step, and I have prepared several PowerPoint diagrams to illustrate how screens and relationships will look when finished. After that planning, we get into actually building the tables. I spend considerable time going through every field, explaining the reasons behind my choices so that you do not just learn how to make a table, but also understand why it is built that way. With the tables in place, we will fill in some sample data and see how the structure behaves in practice. Then we begin creating the order form, starting with the ability to pick a product category and see the products listed in each one. Products can have different options. For example, with burgers, there might be choices like add bacon, lettuce, a toy, or specify how it is cooked. In the next class, we will cover multi-select list boxes, which will let you choose several options from that list at once. That is a topic we have not addressed yet in this series. For the last main project in this lesson, we will build a form to pick a group and then a person in that group. This is helpful for places that do things like school lunches, where a group might be a family and the people are students. If you are running a restaurant, you may skip groups and people or you might want to capture that information for things like rewards programs. It is flexible so you can use it however you choose, including just a simple all-cash option that many businesses use. Throughout the class, I will show you various ways to adapt the system to your needs. If you have questions about the specific material in a lesson, simply go to the bottom of the video page on my website and you will find a dedicated forum for each lesson where you can post your questions. For more general questions about Access that do not fit into the current topic, you can also visit the main Access forums on the site. 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 ListDatabase structure planning for POS systemsDesigning tables and fields for POS applications Establishing table relationships in Access Prototyping database layout with diagrams Building tables for POS components Populating tables with sample data Constructing the order form for product selection Implementing category and product option selection Building forms for group and person selection Configuring billing and group options in POS forms |
||||||||||||||||||||||
|
| |||
| Keywords: access developer 14 easy access pos Easy Access POS Planning Features Groups People Products Categories Discounts Adjustments Tax Tip Unbound Modal Popup Forms Barcode Scanner Avoiding Multi-User Touch-Screen Friendly Payment Types Credit Cards Cash Popup Page Tag: whatsnew PermaLink Microsoft Access Developer 14 |
