Hi all,
I need to build a database to log the results of the audits our managers do on site, I haven't ever built anything like that before & I was wondering of the best way to go about it.
Each audit would have the following fields updated on a table
AuditID (pk)
AuditDate (date/time)
Client (short text)
SiteAddress (short text)
SiteSupervisor (combo box to select from another table with list of supervisors)
ManagerCarryingOutAudit (combo box to select from another table with list of managers)
After the above data has completed whoever is filling in the data will need to fill in the results of the audit taken on site which comprises of 20 questions, each question would have Pass, Fail & N/A as an answer & to make up the audit of upto 100%
Pass = 5
Fail = 0
N/A = 5
As a start for the database would it be better to house the 20 questions in a separate table or have them in them in the main table?
What would be the best way to build the audit result? Moving forward I would like to make the databse track the results by date & by the supervisor who was audited.
Any help would be appriciated
Thanks
I need to build a database to log the results of the audits our managers do on site, I haven't ever built anything like that before & I was wondering of the best way to go about it.
Each audit would have the following fields updated on a table
AuditID (pk)
AuditDate (date/time)
Client (short text)
SiteAddress (short text)
SiteSupervisor (combo box to select from another table with list of supervisors)
ManagerCarryingOutAudit (combo box to select from another table with list of managers)
After the above data has completed whoever is filling in the data will need to fill in the results of the audit taken on site which comprises of 20 questions, each question would have Pass, Fail & N/A as an answer & to make up the audit of upto 100%
Pass = 5
Fail = 0
N/A = 5
As a start for the database would it be better to house the 20 questions in a separate table or have them in them in the main table?
What would be the best way to build the audit result? Moving forward I would like to make the databse track the results by date & by the supervisor who was audited.
Any help would be appriciated
Thanks