Đã hoàn thành

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

Kĩ năng: Microsoft Access, Excel, Lập trình cơ sở dữ liệu, Nhập liệu, Quản trị cơ sở dữ liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) United Kingdom

ID dự án: #32259059

Được trao cho:

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 Thêm

£100 GBP trong 15 ngày
(1 Nhận xét)
0.0

16 freelancer chào giá trung bình£173 cho công việc này

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 Thêm

£100 GBP trong 3 ngày
(242 Nhận xét)
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 Thêm

£200 GBP trong 1 ngày
(130 Nhận xét)
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 Thêm

£250 GBP trong 3 ngày
(7 Nhận xét)
5.6
(76 Nhận xét)
5.9
(28 Nhận xét)
5.5
(7 Nhận xét)
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 Thêm

£20 GBP trong 1 ngày
(4 Nhận xét)
3.7
(3 Nhận xét)
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 trong 5 ngày
(2 Nhận xét)
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, Thêm

£250 GBP trong 10 ngày
(1 Nhận xét)
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 trong 19 ngày
(1 Nhận xét)
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 Thêm

£250 GBP trong 3 ngày
(0 Nhận xét)
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 Thêm

£160 GBP trong 5 ngày
(0 Nhận xét)
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 Thêm

£200 GBP trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0