Solved

Create a Point of Sale Form/Database in Access

Posted on 2014-04-01
2
11,951 Views
Last Modified: 2014-04-02
 
I need some help designing a Point of Sales form/database in MS Access 2010 for a customer.  Any idea of how the form should work and look is greatly appreciated.
 
I need a form that will start off blank (no entries) other than the form header. It needs to allow input of data on line #1  based on input from the cashier/scanner.  The form could possibly have 15 or more lines based on how many different items the customer buys (1 line per item).  As a line is entered I need to draw the PRODUCTCODE, NAME, LIST PRICE, and current OH Qty for the item  from my PRODUCTS tables.  I will SUBTRACT the quantity purchased from the OH Qty to come up with the NEW OH Qty.  This NEW OH Qty needs to go back into the PRODUCTS table and become the current OH Qty (if I have 10 and sold 2 the next time I sell that item my OH Qty should be 8) once the transaction is complete. The quantity purchased multiplied by the ITEM COST will be the TOTAL for that line.  When this information is complete the form goes to line #2 and continues adding lines until all items have been entered.  When all lines are entered the cashier will hit the PAY button and:
 
1.        Ask how the customer wants to pay (continue and take the money/credit card, etc.)
2.       Save all of the line entries information for future reports (I do not have a table for this yet, not even sure how)
 
I need to track each item sold for future reports.  All individual customer transactions need to be saved for reporting the total sales of each and every item by day, week, month, and year. Here I need to be able to retrieve how many of each item was sold and what the total money collected per item was (i.e. 10xMizo Drinks for a total of $25)
 
When the money is collected and all is saved I need to open a blank form just as if I started for the next customer.

Any examples, code and pictures will make it easier for me.
 
0
Comment
Question by:juricta
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 350 total points
ID: 39971897
That's a pretty tall order for a web-based Q&A forum :)

There are some Templates here: http://access.microsofttemplates.org/template/business-templates

One of those might be a good starting point for you. The Northwinds template that ships with Access might be worth looking at as well. It essentially does most of what you're after, so with minor modifications you might be able to get that to work for you.

I would also caution you against tracking inventory in the method you describe. Unless you have very, very tight control over what goes in and goes out (and you won't, trust me) you should instead record "transactions" in a table designed for that purpose. Every inflow or outflow of inventory should be tracked in that table, and you can then generate your on-hand quantities with a query.
0
 

Author Closing Comment

by:juricta
ID: 39972222
Thanks for the input.  I did look at the NW database and it could work with minor tweaks.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now