Create a basic Access Database that accounts for the following:Notes For accounting Relational Database
Data Entry Page:
1. Transaction Type (select cash or card).
2. Date of transaction.
3. Supplier Name (Auto lookup from previous entries allowing new entries to. Be saved. To the list).
4. Description (Auto lookup from previous categories with new added).
5. Accounting department (Able to add departments snd change details starting departments Captain, Chef, Chief Stew, Chief Mate, Deck). Default Department to be chef
6. Amount Onto Account (transactions In really only to cover withdrawals on card to be brought onto cash account or for cash to be added to account via other means)
7. Amount from account (out).
8. Select transaction currency (If TL no change if Euros then exchange at the exchange rate entered)
8. Exchange Rate.
9. Remarks - Space to allow for written
The database should have all transactions storred automatically in both Euros and TL
Create a query based dashboard that summarises the following information:
1. Totals - By Month against crew number
2. Total Cash spend against each month
3. Total Card Spend against each month
4. Sub totals by description by month and week CREW FOOD and GUEST FOOD (these should be in Euros and Turkish Lira)
5. Sub totals by all other descriptions by month
6. Running Total
7. Cash at bank
8. Cash carried forward from previous month
A button and mechanism on the dashboard allowing the selection of any given month or week and then to export the resulting information to excel in the following format.
Excel - Macro based Excel workbook output for any requested month three pages:
1. Page 1 all transactions
2. Page 2 all cash transactions for the specified period
3. Page 3All card transactions for the specified period
Excel output columns
Reference - Serial Number concatenated with department
Transaction type - Cash or Card
Date - Date of transaction
Supplier Details - Nam elf supplier on receipt or invoice
Description - (transaction description)
Crew - Department responsible for transaction
In Amount paid into account (cash only) (Turkish Lira)
Out amount - Amount paid out of the account cash and card transactions. (Turkish Lira)
hi, i will start your work now .I’m interested in this job. I can do it properly. You Can Select me for Quality and Cheap Cost. We can discuss more over the message. I hope a positive answer from you.
18 freelancers are bidding on average €279 for this job
Hi, Hope you doing well. I read your accounting database project description and very confident to handle this project perfectly Let's have a discussion, negotiate costing, timeline and then we proceed Thanks!
hi there thanks for the response i have seen the details my expert team will create this access databse open project message board for communication best regards anwar
I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I hope your kind response.