MS ACCESS: BOOKKEEPING DATABASE for REPAIR SHOP

The database will have the following functions:
A. TO RECORD EACH WORKING DAY:
1. Daily income made by each worker, include:
a. Credit card
b. Cash
c. Tip
d. Misc Income
2. Daily Discount Coupon received
3. Daily part and supply cost
B. SHOP EXPENSES:
1. Rent
2. Electricity
3. Water
4. Advertising
5. Repair
6. Parts
7. Supplies
8. Misc 1
9. Misc 2
10. Misc 3
C. REPORTS TO MAKE:
1. First Semi-monthly gross/net income made by each worker
2. Second Semi-monthly gross/net income made by each worker
3. Employee 1099 Yearly Report
4. Yearly shop gross /net income
NOTES:
1. MENU with each function needed
2. ALL tables, queries, and forms can be modified when needed
3. Suggestions are welcome.
4. Will discuss in detail when work is assigned.