POS Cash Register Application with MS Access as the Back-end
$250-750 USD
Paid on delivery
I am seeking a programmer to create a cash register POS application that uses MS Access as a back end. This will be a POS application, not a business management application. This application will NOT be used to run reports, print barcodes, purchasing, accounting, inventory management, review sales data, etc. All of those functions and many others will be performed in the MS Access database using forms, queries, reports, etc. This application will be a POS to conduct transactions and store data into the MS Access database. All applications, files, work including company name, logo, users, features, etc. must be completely flexible, configurable, and able to be modified easily by myself in the future. This application must support only one POS to start with, but should be designed to support additional POS terminals in the future. This application will be written in VBA, and should have a clear, user-friendly, attractive GUI with the look and feel similar to a real cash register.
The cash register POS application requirements are as follows:
• Support barcode scanner, cash drawer, receipt printer, credit card scanner, LCD touch screen
• Support customer display such as a light pole or LCD screen, and keyboard (although this will be a backup; the primary interface will be a touch-screen)
• Support the calculation of withholding tax such as VAT
• Support printing customer receipts from receipt printer. Printed items included should be able to be configured.
• Support printing of official business VAT receipts on A4. Printed items included should be able to be configured.
• Support lookup all product data such as barcode numbers, descriptions, prices, etc. from an MS Access 2010 database stored on a LAN
• Support storing all transaction data via LAN into an MS Access 2010 database
• Support login of different user levels; staff, manager, owner with multiple user names for each user level
• Support data recovery and auto-restore-on-resume for emergency situation such as loss of power
• Support product returns, refunds, discounts, canceled orders, open orders with partial payment, coupon codes
• Support payments such as cash, credit card, store credit, check, Paypal, bank transfer, gift certificate, etc.
• Support list of ongoing open orders
• Support reconcile cash drawer and reset daily totals to zero
• Support multiple product quantity, subtotal, cash tendered amount, cash change amount, and No Sale function
• Support data input and output via LAN from predefined parameters for future expansion of features
• Support date, time, company logo, transaction data, etc. on receipts
• Support loan at the beginning of the shift
• Support configuration file backup
• Support employee time and attendance
• Support assigning new transaction number and old transaction modify/recall/review/reprint
• Support new customer data and assign number
• Support shipping cost and shipping cost calculation (formula to calculate shipping cost based upon MS Access Database data)
• Support POS identification number
• Support new employee training mode
I prefer to work closely with only one person that can help me with the progression of the complete business database; this means this project and subsequent projects as well. My business is currently operating with manual, separate methods, i.e. Excel for inventory, files and folders for documents, Casio cash register, handwritten customer orders, etc. Eventually the goal is to transform all aspects of the business into one MS Access database. This must be done slowly, piece-by-piece. The process will necessarily require close and constant communication with questions from both sides. The more questions, the better. I can afford to be a bit flexible with time. All files and applications, VBA code, etc. must be well documented, commented, and explained in accompanying .txt files if necessary so I can understand everything clearly and modify it as needed at a later time.
Thank you.
Jeff Beach
Project ID: #12934443
About the project
24 freelancers are bidding on average $653 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I ha More
I have already done POS in VB6 with ms access as backed. i can send you a demo version if you like to see. I have also done but without print option in VB.net but my SQL as backend. I can show that through teamviewer More
All sounds good but why would you use MSAccess to store data and on Lan :O Why not save it on the cloud or in MSSQL?
Dear sir i am experience in software development i have expertise in C# i can develop complete software for you according to your requirements and will update you daily with work on skype kindly visit my profile and co More
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More
In the bid amount , I can provide the website version , android application , ios application . I am available on all days.
