Завершен

Build me a MS Access database

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

Навыки: Microsoft Access, Excel, Программирование баз данных, Ввод данных, Управление базами данных

Показать больше: build executable access database, access ms access database manually, attendance ms access database, backup restore ms access database vb net windows application, cheap ms access database design, code store text form vb project ms access database, connect google map ms access database vb, convert ms access database exe, convert ms access database program, convert ms access database standalone software, convert ms access database stand application, convert ms access database work web server service, covert ms access database exe file, create login page dreamweaver coldfusion ms access database, create ms access database, crystal report asp net ms access database, data decrypted ms access database, decrypt ms access database, build ms access database

О работодателе:
( 1 отзыв ) United Kingdom

ID проекта: #32259059

Поручен:

safdar1117

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 Больше

£100 GBP за 15 дней(-я)
(1 отзыв)
0.0

16 фрилансеров(-а) готовы выполнить эту работу в среднем за £173

VladimirLilenko

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 Больше

£100 GBP за 3 дней(-я)
(242 отзывов(-а))
7.0
AccountantArman

"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 Больше

£200 GBP за 1 день
(130 отзывов(-а))
6.1
liveexperts123

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 Больше

£250 GBP за 3 дней(-я)
(7 отзывов(-а))
5.6
(76 отзывов(-а))
5.9
(28 отзывов(-а))
5.5
(7 отзывов(-а))
3.6
Zohaib748

Hi There...! Note : I give you 25% off on my all services. So grabs this special limite discount offer. Let’s get to the Project. I came to know that your Looking a developer which have rich knowledge about web dev Больше

£20 GBP за 1 день
(4 отзывов(-а))
3.7
(3 отзывов(-а))
2.3
starostinoleh

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.

£150 GBP за 5 дней(-я)
(2 отзывов(-а))
1.3
usmanfreelancar6

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, Больше

£250 GBP за 10 дней(-я)
(1 отзыв)
0.6
saadsoftech

HI Sir. I am expert in Access/Excel and can built database application and data automation. I have 8 years experience in database development.

£220 GBP за 19 дней(-я)
(1 отзыв)
0.4
TFComplex

Hi, Greetings from Zuhair Muhammad. I'm interested in doing your work so finally would like to start work now. ' I'm ready for an interview and feel free if you have any queries and contact me anytime 24*7 will be avai Больше

£250 GBP за 3 дней(-я)
(0 отзывов(-а))
0.0
Moeinsalari

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 Больше

£160 GBP за 5 дней(-я)
(0 отзывов(-а))
0.0
RomanKor1012

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 Больше

£200 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
asfiyas

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.

£200 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0