Art Exhibitions
Index
Links
Home
Feedback
Last
Next
Community Tute 16 - Participant Tracker
1. Start Access then select 'New' from the 'File' menu.
2. Select blank database and press
'OK'.
3. Access is now creating a new
database file (.mdb), set the file name
to 'ParticipantTracker.mdb'.
4. Blank database view, no tables
created yet. To create a new table, hit the 'New' button while the
'Tables' tab is
selected.
5. Select 'Design View' form the
list to go straight into design mode of the
table.
6. Create the following field
names by typing the names in the table as shown in the view below. Choose the
data types by using the drop list in the 'Data Type' column (default type is
Text).
7. Save the table as
'Participants' and press
'OK'.
8. Microsoft Access will prompt
you to choose a primary key, select 'Yes' as this will be the id that we will
track the participants of the questionnaire through the different tables.
9. Create a new table (as above) and save the table as the 'Mailing List'. Close the
table.
10. Choose no as we are using this
table to enter the tracking id that we created in the 'Participants'
table.
11. Create a new table, this one is used to hold the responses from the questionnaire.
12. Save the table
as 'Progress Phase 1'.
13. Switch off the default values
in the number field (delete that highlighted '0'), close and save changes.
14. No we will use the same table
design for each of the different questionnaire phases, so save this table as
'Progress Phase
2'.
15. As
above.
16. Save as 'baseline' this time.
17. The contacts table will be
similar in design to the 'Mailing List' so open the 'Mailing List' table in
design mode and save the table as
Contacts.
18. As
above.
19. Save the 'Progress Phase 2'
table as 'Progress Phase
3'
20. Save the 'Progress Phase 3'
table as 'Progress Phase
4'.
Copyright © 1999 R&D Robotics Pty Ltd, All rights reserved.
Any copyright subsisting in the above code and or literary works including source files vests with R&D Robotics Pty Ltd. ACN 086 345 137
Last
Next