G
Guest
I am well aware that I am in need of some training/learning. I have a basic
understanding of databases and hope that it doesn't make me more dangerous
than I should be.
Currently, our management performs audits of our production areas. This
audit is nothing more than a form created in excel, printed out, and the
results of the audit written on the form. (Some users have requested the
excel file to which they input their results after the audit and save their
electronic files. This means they have numerous copies of the same file
stored on the network.)
What I am trying to achieve is the creation of a database that will mimic
the excel form, yet have results able to be analyzed by querying the database
as opposed to manually thumbing through the hardcopies of audits (and
electronic files).
The audit contains 20 questions with a Yes, No, Not Reviewed, Comments, and
Completed as items to be completed, for each question.
In addition, several other pieces of information need to be completed such
as Name, Date, Process Area, Shift, etc.
Basically, the information that is completed on the form is what I would
like to recreate via a database and then be able to pull reports based upon
select criteria (Number of times there is a "No" selected for a given
question, number of times there is a "No" selected total, etc.)
If someone could at least offer some input to point me in the correct
direction it would be most appreciated. In the meantime, I will continue to
try to read what I can on Access.
Thank you!
understanding of databases and hope that it doesn't make me more dangerous
than I should be.
Currently, our management performs audits of our production areas. This
audit is nothing more than a form created in excel, printed out, and the
results of the audit written on the form. (Some users have requested the
excel file to which they input their results after the audit and save their
electronic files. This means they have numerous copies of the same file
stored on the network.)
What I am trying to achieve is the creation of a database that will mimic
the excel form, yet have results able to be analyzed by querying the database
as opposed to manually thumbing through the hardcopies of audits (and
electronic files).
The audit contains 20 questions with a Yes, No, Not Reviewed, Comments, and
Completed as items to be completed, for each question.
In addition, several other pieces of information need to be completed such
as Name, Date, Process Area, Shift, etc.
Basically, the information that is completed on the form is what I would
like to recreate via a database and then be able to pull reports based upon
select criteria (Number of times there is a "No" selected for a given
question, number of times there is a "No" selected total, etc.)
If someone could at least offer some input to point me in the correct
direction it would be most appreciated. In the meantime, I will continue to
try to read what I can on Access.
Thank you!