Access Database form design

Completed Posted 6 months ago Paid on delivery
Completed Paid on delivery

I have two tables.

Machines, this contains information about each machine i have.

Consumables, A list of everything that can go in all machines.

I need a form creating where i can select a machine and then allocate a consumable to that machine.

e.g. [login to view URL] = 2, Uses [login to view URL] 3,6,12.

This should also store the information of 'Frequency' how often does this Consumable need changing and Measure that is needed to fill the machine. (Daily,Weekly,Monthly,Yearly)

Ideally, unless suggested elsewise, This would be a form with two subforms. 1st showing all available Machines. When one is selected, it will filter a second subform to show all the consumables allocated to that machine.

I would then also like a report, This report should show how much each machine will cost on a yearly basis from each of its consumables.

e.g.

Machine Name, Consumable1,Consumable2,Consumable3 with their associated costs.

Microsoft Access SQL Database Programming

Project ID: #37432179

About the project

21 proposals Remote project Active 6 mos ago

Awarded to:

VladimirLilenko

Hello! I'm a Databases Developer, Access, Excel and VBA expert more than ten 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 shor More

£20 GBP in 1 day
(239 Reviews)
7.1

21 freelancers are bidding on average £27 for this job

jonathanpradas

As an experienced MS Access Developer, I propose to create a comprehensive solution for your machine and consumables management needs. The system will consist of a user-friendly form with two subforms, allowing seamles More

£15 GBP in 7 days
(70 Reviews)
5.9
AbdulBasitAli045

Dear Client. When it comes to your project, i am expert. I will provide you 100% satisfaction work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accurately and More

£45 GBP in 2 days
(88 Reviews)
5.6
mobimubasir

Hello. I read your requirement and also check attachment i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

£20 GBP in 1 day
(18 Reviews)
4.9
vipulpithiya1448

I understand that you are looking for someone to create a form design where you can select a machine and allocate a consumable to it. I am confident that my wide array of technical expertise, along with my services off More

£15 GBP in 7 days
(4 Reviews)
2.3
dumitrutitus2

✔️Hi there✔️ I have read your proposal carefully and I am very interested in your project Access Database form design. I have 5 years of experience in Laravel, PHP, SQL, MySQL, HTML5, CSS3, JavaScript, and JQuery. Kind More

£10 GBP in 5 days
(0 Reviews)
0.0
ndambukiboniface

Dear Client, Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Client, I take More

£20 GBP in 1 day
(0 Reviews)
0.0
AnaJohnson20

Hello, Chris H.. How are you? As a software developer, I am very confident in your project, Access Database form design. I have rich experienced in Microsoft Access, Database Programming and SQL. So I am very interes More

£20 GBP in 5 days
(0 Reviews)
0.0
aqeelabbas786kha

As an experienced full-stack developer, I'll design a dynamic form with two subforms using a technology stack like PHP and MySQL. The first subform will display available machines, and upon selection, the second subfor More

£50 GBP in 7 days
(0 Reviews)
0.0
lynxminx27

Hello Chris H., this is Maria from Philippines who is a excellent mathematician with overall 5 years of experience in software development with Microsoft Access, SQL and Database Programming. I am able to start your p More

£24 GBP in 1 day
(0 Reviews)
0.0
dxnguyen811

Hello there, I had built a complete inventory & recipes management system using Access before, so I believe I should have the necessary experience to complete this project. Looking at the requirement and the sample da More

£15 GBP in 1 day
(0 Reviews)
0.0