In Progress

Create a basic accounting Access database.

Create a basic Access Database that accounts for the following:Notes For accounting Relational Database



Data entry;

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:

Data Dashboard:

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

Functional Output

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)

Skills: Database Administration, Database Programming, Excel, Microsoft Access, SQL

See more: create car booking access database, create executable file access database, create xml feed access database, ms access accounting software source code, access 2016 accounting template, access database examples, how to make accounting software in ms access pdf, modeling and designing accounting systems using access to build a database pdf, ms access accounting ledger database, free microsoft access accounting templates, microsoft access templates, create word document access database form, create standalone executable access database, visual basic 2008 access database server, visual basic codes access database, visual basic import access database, create word doc access database, visual basic 2008 access database project, create order form access database, create visual basic executable access database

About the Employer:
( 3 reviews ) Limassol, Cyprus

Project ID: #19088034

Awarded to:


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.

€100 EUR in 1 day
(98 Reviews)

18 freelancers are bidding on average €279 for this job


Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possibl More

€250 EUR in 5 days
(136 Reviews)

Hi there As per our understanding we are sharing few of our work to you .................. Accounting System(australia) demo demo123 [login to view URL] Accounting System(AUE) More

€1388 EUR in 20 days
(4 Reviews)

Hi, Client. Nice to meet you. I'm very confident on your project because I have a lot of experiences on this IT field I'm a full stack developer who can handle all of mobile app/web application and backend. I'm ver More

€155 EUR in 3 days
(2 Reviews)

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!

€98 EUR in 3 days
(8 Reviews)

Dear Sir, Madam, I am proficient in accounting, finance and bookkeeping, I am a CPA equivalent in my country and worked for several national and multinational companies. My preferred work tool was MS ACCESS, I develo More

€111 EUR in 5 days
(6 Reviews)

Hello sir, Greetings of the day....... Your digital products aren’t just pieces of code. They are your business, your brand, and your future wrapped together into a special package of value for your customers. We More

€155 EUR in 3 days
(2 Reviews)

hi i can create the data base as per your project description in 6 days: Notes For accounting Relational Database Transactions Suppliers Data entry; Data Entry Page: 1. Transaction Type (select cash or More

€250 EUR in 6 days
(8 Reviews)

hello,how are you.i read your bid carefully. i am database expert and have full experience for 12 years. database management is my top skill and i can build your project by using that skills. i can provide most qual More

€100 EUR in 3 days
(2 Reviews)

I'm a software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft te More

€250 EUR in 2 days
(1 Review)

Give me the opportunity to do the work. Please contact me over mail or massage. I will reply soon. I will try my best.

€111 EUR in 3 days
(0 Reviews)

I'm a professional database programmer and accounting software i made apps for descktop and web for accounting. also im a pofficanal in access db so i can complete the project profficanally. contact me for any details More

€311 EUR in 30 days
(1 Review)

Hi: I am a BI Expert & also have handled huge databases If you would like to visualize your data in Tableau, POwer BI, Qlik with handy filters which shall allow you to take quick decisions, I shall be happy to he More

€277 EUR in 10 days
(0 Reviews)

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

€222 EUR in 3 days
(0 Reviews)

Hi There Once we will do final technical discussion then sure i will provide you developer document We would appreciate if you could come up in message box,in respect to the project, so that we can discuss the wor More

€833 EUR in 25 days
(0 Reviews)

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.

€30 EUR in 3 days
(0 Reviews)

Am a web developer and UX designer , my ambitious and digital skills makes me stronger in that field, and i could do that job for you.

€155 EUR in 3 days
(0 Reviews)

I'm an experienced professional in this project and I have gone through your post and I will have it done as specified

€222 EUR in 14 days
(0 Reviews)