Build me a MS Access database
£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
ID проекта: #32259059
О проекте
Поручен:
HI there! I read your project detail and understood your requirement. As this is weekly report of store performance, and you want to enter all previous year values in one list to save entering manually each week and Больше
16 фрилансеров(-а) готовы выполнить эту работу в среднем за £173
Hello! I'm a Databases Developer, Access, Excel and VBA expert more than eight years. I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the sh Больше
"Sir, I can create you this data base with the help of macros in excel. eacha nd everything will be automatic and you will jsut be required to press a button to save a entry, enter the entry number to recall it or edit Больше
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Больше
When it comes to excel, I'm the go-to person. I'm fast, efficient, and hardworking. I promise perfetion in every way. I can start now, and get you exactly what you expect in no time.
Hello, I hope you are doing fine. I read it and we have an accounting experience can also do the data entry process for you to add data in MS Access. Please come over chat s that we can discuss it over chat. Regards, Больше
HI Sir. I am expert in Access/Excel and can built database application and data automation. I have 8 years experience in database development.
Dear, i can do with ms access 2019 , but better solution is develop window or web application for your manager with user management . They have access to report section and user can enter data to the application. Ms ac Больше
Hello I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am a senior developer and I have 15+ years in this field. Now I am very interesting your job and Больше
Ability to multitask effectively. Strong written and verbal communication skills. Ability to perform repetitive tasks with a high degree of accuracy. Comfortable working independently with minimal supervision.
