Cancelled

Design / Teach MS Access that has dynamic changable formulas

I have a database I have designed so far, which is essentially a Laboratory database which lets users enter new tests, which consist of various analytes. The user can group all these analytes into a test, and through a client window they can enter new samples, and pick the tests each sample will have (may be multiple) then in the results page I need help, what I want to be able to happen is for a table to be generated that allows for the results to be entered based on the test that was selected.

In addition to this, in the Sample table, I have a field called parentsample, which allows a child sample to be generated to a parent sample. I would like to get some help to be able to show all calculations of child samples, as a report below the parent sample.

The Main part through, is allowing the database to have the ability to get a user to enter a query in the test, which will be able to be changed for each different test regardless of how many tests there are. What I mean by that is that say for example i have test A, which consists of Time, Weight, Analyte Result, and Surface area. In each test, I enter the forumula and whenever the report is generated, it checks the test to see the query, runs the query which fetches all the individual results, and performs that report. The important this is that one test might do that, but another test might have just Volatile Content, Moisture, Time, Temperature and would need to preform a different calculation on different data which is all contained within the one table (results which contains ResultID, SampleID, Test Name, Test Result, Test Units )

The trick is to allow users to enter it in the test settings table, instead of having to recreate the table each time again and again which is just not really practical.

For example the main test might have a parent product, which has surface area, and child products that contain results, air flow, and units, so it would also need to be able to query child and parent samples to find the appropiate value, but this would normally be a set value, i.e it always happens that there are four child products which need to query the pearent products surface area.

Need help!, Table is half designed but need help with low budget to work out the other part with modifiable calculations etc.

Skills: Microsoft Access, SQL

See more: window design group, user tests, teach for all, product table design, products database design, product database design, part time product design, name flow, i want to design products, how to get a product design, how to find the design, how to find flow, flow design, design table, design checks, air products, access group, test formulas access, access formulas, what is ms sql

About the Employer:
( 33 reviews ) Beaconsfield Upper, Australia

Project ID: #748893

22 freelancers are bidding on average $123 for this job

HussienSharaf

HI, I m the best MS Access, I m professional in creating dynamic SQL and dynamic coding. Plz check PM. Regards, Hussien Sharaf

$70 USD in 2 days
(34 Reviews)
6.8
fedalal2

Hi, I have more 10 years in MS Access (SQL server) I can make it fast. Alex

$100 USD in 1 day
(15 Reviews)
4.8
frehmanpk

Respected Sir, Please see PM for details. Kindest Regards.

$30 USD in 0 days
(15 Reviews)
4.5
SmartGuru

Hello, Using VBA, the solution for dynamic formulas can be provided to you. I would be glad to help you realizing your project. Regards.

$90 USD in 3 days
(7 Reviews)
4.0
ssivanov

I can help you. Contact me via PMB. I have over 10 years experience in MS Access.

$240 USD in 10 days
(0 Reviews)
0.0
falakawan

understood your requirements and will deliver desired product within time and budget being a professional of this field since long

$200 USD in 5 days
(0 Reviews)
0.0
ayep

Hi, I'm interested with your job. I'm an expert in database management system and software development. I've done many projects related to it. With regard to your project, I suggest to build a software (with the data More

$100 USD in 3 days
(0 Reviews)
0.0
kaddusgfl01

Hello, I’ve 15 years experience in the computer jobs. My academic background is master in statistics. I have got OCA, MCP. I’m interested to do online works.

$100 USD in 7 days
(0 Reviews)
0.0
JAGADEESANMUDU

I CAN PROVIDE SOLUTION FOR YOUR REQUIREMENT

$50 USD in 2 days
(0 Reviews)
0.0
yoctoclub

I can do that easily.

$100 USD in 20 days
(0 Reviews)
0.0
kalneel143

Hello , i m working as a software developer in a company and have experience of professional databases. will give u a better option for ur database. I am very interested in developing this project as the skills and th More

$170 USD in 9 days
(0 Reviews)
0.0
sisinuk

Hi there, i am a database programmer and consultant and happy and absolutely keen to deliver you the solution. regards

$100 USD in 1 day
(0 Reviews)
0.0
asonua

Hi, I am Database Designer. Please give me oppertunity.

$200 USD in 7 days
(0 Reviews)
0.0
progrish

I am computer database programmer in a very big company (sales,production,human resources,accounting). I work on SQL Server, .NET, C#, Asp.Net, MS Access (business application). I can do this job. Thank you.

$200 USD in 8 days
(0 Reviews)
0.0
alainalexa

I am very interested in developing this project as the skills and the knowledge needed are matching with my area of expertise.

$200 USD in 5 days
(0 Reviews)
0.0
grzegorz7bylica

Hi. I have three years experience as a developer. Price shows that, just starting to freelancer.

$30 USD in 14 days
(0 Reviews)
0.0
privani

Please check my PM. Thank you

$150 USD in 7 days
(0 Reviews)
0.0
elhachem

I am un expert in Access

$100 USD in 5 days
(0 Reviews)
0.0
Gil95

Hello check pmb

$30 USD in 3 days
(0 Reviews)
0.0
billfan88

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f More

$200 USD in 2 days
(0 Reviews)
0.0