Build me a MS Access database

Job ID: 32259059

Budget: £20 – £250 GBP

Our performance manager enters weekly data into a MS Excel spreadsheet for three convenience stores (cost centres). Once completed, the spreadsheet is distributed to other managers by email.

The spreadsheet has manual inputs, and the spreadsheet calculates other values.

I would like to be able to enter all previous year values in one list to save entering manually each week and the database store the new enetered weekly values for use next year.

Required: To be able to produce a weekly report similar to the spreadsheet.

Details of Variables for the Project - see below list

Date – weekly criteria
SALES £
Sales £ (This year) – MANUAL INPUT
Sales £ (Last year) - MANUAL INPUT
% sales difference – CALCULATED
Ranking between stores – CALCULATED - best= 1, worst=3

Number of Sales
Number of Sales (This year) - MANUAL INPUT
Number of Sales (Last Year) - MANUAL INPUT
% Number of sales differences – CALCULATED
Ranking between stores – CALCULATED - best= 1, worst=3

Clearance & Wastage TY
Clearance & Wastage TY (This Year) - MANUAL INPUT
Clearance & Wastage TY (Last Year) - MANUAL INPUT
% Clearance TY v LY differences – CALCULATED
Clearance & Wastage as % of Sales - CALCULATED
Ranking between stores – CALCULATED - best= 1, worst=3

Gross Profit Margins
Margin (This Year) - MANUAL INPUT
Margin (Last Year) - MANUAL INPUT
Margin Difference – CALCULATED
Ranking between stores – CALCULATED - best= 1, worst=3

Basket Spend
Basket Spend (This Year) - MANUAL INPUT
Basket Spend (Last Year) - MANUAL INPUT
Basket Spend Difference – CALCULATED
Ranking between stores – CALCULATED - best= 1, worst=3

Happy or Not
Happy or Not - MANUAL INPUT

Various other elements
Voids Quantity – MANUAL INPUT
Voids Value £ – MANUAL INPUT

Service Refunds Quantity – MANUAL INPUT
Service Refunds Value £ - MANUAL INPUT

Store Refunds Quantity – MANUAL INPUT
Store Refunds – MANUAL INPUT

Till Shortages – MANUAL INPUT
Total of UA* transactions £ - CALCULATED

*Unaccountable transactions