Access Specialized POS Cash Tracking

Specialized Point of Sale (POS) type Access db. I have setup most of the initial tables required based upon longer term expanded project end result information I desire. All code to be provided to me for review prior to implementation with explanation to me of questioned code if I need. I reserve All rights without exception to all code, forms tables etc of final project and sub-projects shall at all times be my property.

Specialized POS entails design of a tracking system for a small 5-10 video slot machine Cash Tracking system (slots are called LVL Machines). The Company can have more than 1 location. Each location only has 1 employee on duty that is responsible for the Cash Drawer (the EmployeeShift). The Owner/Supervisor/Manager is the only ones with access to LVL Machine Money and is responsible for "Pulling" those machines, Replenishing EmployeeShift clerk with funds from "Pulls" or from the ManagerSafe and "Dropping" remainder of "Pulled" funds not returned to EmployeeShift to the ManagerSafe.

Looking for suggested changes to my current tables/queries also when/where needed. I am attaching an Excel 2007 file with current structures to assist understanding.

1)Create secure Login

2)Create queries, forms and reports to capture the following data:

a)an input form and table(s) of all Govt data tracking system totals data for each and every LVL machine for any moment in which money is pulled out of any particular or all machines (Machines can be "pulled" all at once or can choose which ones got "pulled" - Require form to setup input for all machines on 1 form. Ie: if location has 3 machines then employee imputing does NOT select from a drop down which machine they're inputting. The form MUST list machine 1,2 and 3 when initializing.

b)a Currency Count tracking input form and table for each denomination counted linked to the i)EmployeeShift when pulled; ii)SupervisorShift that pulled and counted money

c)a EmployeeShift End of Shift Currency Count table, queries and form(s) to Count Currency Denominations for each currency Holding spot (i)Temp Shift Crossover Till; (ii)Cash Drawer; (iii)ClerkSafe

d)a Supervisor MachinePull Currency Returned to Shift Employee table and form for each denomination linked to SupervisorShift and EmployeeShift

e)a ManagerSafe Money Drop table to the Manager safe of MachinePull money not returned to EmployeeShift in d) above

f)a ManagerSafe Money Drop returned to EmployeeShift for when Supervisor needs to pull money back from Manager Safe to replenish EmployeeShift Cash Drawer.

g)Reconciliation form that takes the EmployeeShift's starting cash and reconciles it for Supervisor MachinePull replenished + ManagerSafe Drop added back to ShiftEmployee Cash drawer + Money Added back to ShiftEmployee till from ATM - Misc Cash Paid Outs +/- EmployeeShift Over/Short

h)Misc Cash Paid Outs Forms

i)A Reconciliation (automated) for the Supervisor "MachinePull". Machine's may or may not be "pulled" every day. Thus for each machine "Pulled" it will be i)current day's moment of Pull "AmtIn" per Machine data from Govt Agency real-time reporting system (manual input to this db) ADD ii) any prior day(s) end of day Govt system totals for any machine "Pulled" LESS iii) last pull date's Govt system total as of time of immediately preceding "Pull" for any machine currently "pulled".

3)Create Table, Forms and Code to email selected data Report to off site Owner and Accountant or others setup in a info distribution table

4)If Possible create a nonpublic iPhone app to view selected data to be determined (separate project but you need to know while designing tables, queries, forms)

Apple Safari Microsoft Access

Numer ID Projektu: #1365306

O projekcie