Database Project – Survey
Purpose:
With a partner, create a survey, for class members to fill in, and analyze the data
in the survey. A survey is usually on one topic (ex: music, movies, sports, etc.)
Criteria:
Your project must contain:
At least 8 questions translating into 8 fields
20 records not all kids in the class need to fill out the survey
1 form so that you have a user friendly interface from which people can
respond to your survey
8 charts showing the results for each question (done in Excel). Simply copy
& paste your survey table in Access to Excel and make the charts in Excel!
Summary summarize the findings of your report (done in Word in report
format of course!)
Steps:
1. Plan In Word type the survey topic you have chosen. Brainstorm and then type
the 8 questions that you are going to use in your survey along with the range of
responses (i.e. Do you eat in the cafeteria? Always Sometimes Rarely Never
2. Print your plan and get your teacher to sign it before going to the next step in
Access.
3. Create a database for your survey. Please see the survey tutorial!
4. Hand in the following:
Appropriate title page
Your plan
A printed table with data
A print out of your form
A print out of the 8 charts
Your summary
Evaluation:
Thinking & Inquiry
Plan
Communication
Data Entry spelling & grammar
Data visibility
Colour schemes, formatting, etc.
Application
Performing the required tasks correctly and accurately
Survey Tutorial
1. If you want to follow this example, create a Blank Database named Survey
2. To create a new table, on the main menu, click Insert -> Table and in the
New Table dialog box, double-click Design View
3. Set the first field name to QuestionID and its Data Type to AutoNumber
4. Right-click it and click Primary Key
5. Set the second Field Name to Question1
6. Press Tab, type L and press F6
7. In the first page of the Lookup Wizard, click the bottom radio button and click
Next
8. Click the box under Col1, type At home and press the down arrow key
9. Complete the list as follows:
10. Click Next and click Finish
11. In the lower section of the table, click Caption and type:
Where do you mostly use Microsoft Access?
12. Under Question1 in the top section of the table, set the next Field Name to
Question2 and set its Data Type to Lookup Wizard
13.Click the bottom radio
button and complete the list under Col1 as follows:
14. Click Next and click Finish
15. In the lower section of the table, click Caption and type:
What version of Microsoft Access are you currently mostly using?
16.Save the table as Questions and switch
it to Datasheet View
17. To test it, perform a few surveys (examples below)
18. Close the table
Form Creation
After initiating the table, you would then create a form or a Data Access Page. This is where
you would have to be creative. Because the form or the DAP is the object you would present to
the users, it must be as explicit, indicative, and clear as possible.
Practical Learning: Creating the Form
1. In the Tables section of the Database Window, click the Survey table
2. On the Database window, click the arrow of the New Object button and click AutoForm
3. Save the form as Questions
4. Design the form as follows:
5. Switch it to Form View to see the result
6. Close the form