A
Andy
I need to design a database that will allow for some assistance with audits.
I am considering the following, but would appreciate any help and guidance
from you all!
My first stage is to design a form that will allow the user to input data as
is recorded in some notes as well as the same data fields that should have
been entered. Once entered, this data then needs to be run through some
software (via some SQL script with .exe prompts to ensure it's as automated
as possible). The data will then hopefully be outputted on a report,
summarising the data that was held within the notes and the data that should
have been recorded (including output fields from the software).
I am therefore considering designing the database as follows.
Create two tables (one for the notes data and one for the actual data).
A form is created allowing user input that will dump this data into the two
tables.
These two tables are then exported and run through the software and two new
tables created including the relevant software output fields.
I then need to write a report to show all data fields (one set for the data
held within the notes and one set for the acutal data and the corresponding
outputs from the software).
Looking for guidance/advice and how best to design. Appreciate it all sounds
a bit vague, but happy to answer questions that people have!!!
Many thanks
I am considering the following, but would appreciate any help and guidance
from you all!
My first stage is to design a form that will allow the user to input data as
is recorded in some notes as well as the same data fields that should have
been entered. Once entered, this data then needs to be run through some
software (via some SQL script with .exe prompts to ensure it's as automated
as possible). The data will then hopefully be outputted on a report,
summarising the data that was held within the notes and the data that should
have been recorded (including output fields from the software).
I am therefore considering designing the database as follows.
Create two tables (one for the notes data and one for the actual data).
A form is created allowing user input that will dump this data into the two
tables.
These two tables are then exported and run through the software and two new
tables created including the relevant software output fields.
I then need to write a report to show all data fields (one set for the data
held within the notes and one set for the acutal data and the corresponding
outputs from the software).
Looking for guidance/advice and how best to design. Appreciate it all sounds
a bit vague, but happy to answer questions that people have!!!
Many thanks