Easy Access POS - Introduction to my Point of Sale System database built with Microsoft Access

In this video, I will introduce you to a new project of mine: the Easy Access POS. For years people have been asking me to build a simple, easy to use, easy to modify Point of Sale system in Access. This video introduces that project. I will talk about the features it's going to have, and what's coming up in future lessons.

TOPICS:
Planning the Database
Discussing Features to be Built
Groups & People (Family & Students)
Products & Categories
Discounts, Adjustments, Tax, Tip
Unbound Modal Popup Forms
Barcode Scanner Capable
Avoiding Multi-User Problems
Touch-Screen Friendly
Payment & Payment Types
Credit Cards, Cash
Popup Keypad for Numeric Entry
Calculate Change
Voiding Sales
Multiple Locations
Manager Menu
Edit Lists, System Settings
Edit Orders & Payments
Sales Charts & Graphs
List of Groups with Open Balances
Mail Statements
Detailed Sales Reporting
Possible Future Upgrades

[bradlevan]

Absolute GEM I can across on YouTube. These tutorials are fantastic! Did you ever solve the “signature” add-on? I think this would be invaluable in a lot of businesses

[mailjunk]

are there any subsequent videos on this where it is completed and placed into production?

[dejmascurryhouse]

Hello there, how hard will it be to add a Order taking by Phone and entering in the POS and sending a copy to the Kitchen display and once the Item is ready they click Order ready for pickup and then convert that order for payment to be collected from the customer.

[khanqureshi]

I actually included expiry date in the products table and then put a condition on the sales form where if a customer pick an item that is expired, the system will not process the sales with a reminder message. However if the same product comes from two different suppliers, the expiry date are not the same and Giving a different code as per expiry date is really a mess. Is there a better way to do this?


Thanks

[itsyagurlrxch]

Hi, this video is awesome!! Is there more videos concerning the POS system? I checked on your website and I couldn't find any! I watch your video about CustomerID but how can I create a list of product or how can I create a subsequent order by clicking like select a group, select a person and get to this interface.

[polcyl]

Hi can you demonstrate what if the products are sold by weight? Just like in the supermarkets where the weighing scale prints a custom barcode/label. thanks.

[paddiedelaney]

Did you build till system..would love to have as most don't have deposit option and payments off..can pay for.