Hello and welcome to my first post,
I work at a VERY small (almost underground) mini casino/game-room. We only have 30 video slots and deal in all cash. We have been using an Excel Workbook and entering data twice a day at shift end (AM/PM) and matching the attendants written records with machine records to determine accuracy of the attendant and if there is any possible theft.
I wanted to make a database that would keep a running total of the MASTER and PERIOD numbers Per Employee (for records and vendor purposes) and I would like the floor attendants to have a simple form that they can fill out which populates those records for use.
I have been copying all the MASTER IN's and MASTER OUT's by hand and then entering them into the Excel database but human error is often costly
I am going to try to upload a copy of the Excel Workbook We've been using and the Database I've started. PLEASE any and all suggestions are welcome, And appreciated
In the Excel workbook the Period figure is calculated by subtracting the Prior from the Current and for each Shift the first Current, Prior, and Period are the In's and the second are the Out's and "Fish" is a high volume game from a different vendor we like to tally separately. The far Left column of calculations is pretty self explanatory...well..."Pulls" is the amount of cash they had to pull out of the machines throughout the shift to keep up with the tickets they had to payout. (All pays are hand-pays. When I say small game-room I mean smaahhhlll. Don't think Vegas, think more like trailer on a lonely Texas highway)
I'm pretty sure I've added too many table to the database because they are redundant?? I think
It's been years since I took the MS certification tests and I've been trying to watch videos to freshen up on Access to no avail
I know its possible to have the Database open right to a login then a form Where they just have to fill in the Starting Bank, Pulls, Period_in&Period_Out per Machine, Matches (oh yeah, we match each customer the first $5 they spend) ,Expenses, and payroll and get a Report with pertinent info. I'd Like to thank you in advance for any help you can.gameroom_access.zipgameroom_excel.zip