Hi All,
I'm brand new to Access and am hoping that someone can guide me to where to start. I conduct audits and record findings on forms. The audits are independent of one another and I have 3 teammates that I would want be able to utilze a database to record findings. We all have the same questions but the teammates would be specific independent users.
Can someone please give me advice of where I should start? I'm listing some examples of the questions from my 2 forms below.
Thank you in advance for humoring my newbie basic questions, but this project is overwhelming and I don't know where to start.
The secondary purpose of this database is to track my metrics based on these questions.
The first form is where we record findings:
Free Text Field Requirements examples:
Auditor Name
Project #
Department
Date Range Audited
OR
Information request fields:
Date:
Name of Person that Information was requested from:
Type of Information Requested
Some Questions on the form have a drop down menu:
Audit Type:
Risk Based
For Cause
or
Project Status:
Open
Closed
On Hold
There is also the field work section that has
QuestionXXXX
Check box of Yes, No, NA
Free text for findings (this free text box is on each question)
The second form is based on employee interviews:
Some of the questions I can do via a drop down menu.
Example:
What is your role on this project?
Choices are:
Manager
Finance
Data
Others require free text responses.
Examples of Free Text:
Audit #
Department
Interviewee Name
Interviewee Title
Then there are some that we have as a drop down menu as first choice then free text :
Example
Does your department keep copies of XXXX?
Choices
Yes
No
Unable to Answer Question
Sub Questions
Free text required
If yes, where are they located?
If Unable to Answer Question, Explain
I'm brand new to Access and am hoping that someone can guide me to where to start. I conduct audits and record findings on forms. The audits are independent of one another and I have 3 teammates that I would want be able to utilze a database to record findings. We all have the same questions but the teammates would be specific independent users.
Can someone please give me advice of where I should start? I'm listing some examples of the questions from my 2 forms below.
Thank you in advance for humoring my newbie basic questions, but this project is overwhelming and I don't know where to start.
The secondary purpose of this database is to track my metrics based on these questions.
The first form is where we record findings:
Free Text Field Requirements examples:
Auditor Name
Project #
Department
Date Range Audited
OR
Information request fields:
Date:
Name of Person that Information was requested from:
Type of Information Requested
Some Questions on the form have a drop down menu:
Audit Type:
Risk Based
For Cause
or
Project Status:
Open
Closed
On Hold
There is also the field work section that has
QuestionXXXX
Check box of Yes, No, NA
Free text for findings (this free text box is on each question)
The second form is based on employee interviews:
Some of the questions I can do via a drop down menu.
Example:
What is your role on this project?
Choices are:
Manager
Finance
Data
Others require free text responses.
Examples of Free Text:
Audit #
Department
Interviewee Name
Interviewee Title
Then there are some that we have as a drop down menu as first choice then free text :
Example
Does your department keep copies of XXXX?
Choices
Yes
No
Unable to Answer Question
Sub Questions
Free text required
If yes, where are they located?
If Unable to Answer Question, Explain