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. 

Resources

• Full Course Lessons Page
• Course Topic Outline

Topics Covered

• Easy Access POS Part 1
• Planning the Point of Sale System
• Advanced Design Preparation
• Detailed List of Features
• Building the Tables, Relationships
• Barcode Scanner Considerations
• Main Order Entry Form
• Category, Product List Boxes
• Group, Person Forms

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.

In Lesson 5 we will build the form that allows us to select a Group and then the Person from that group to be saved on the Order Form.

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions?

Please post any questions or comments below.