Microsoft Access allows you to create user-friendly forms to gather data from users. Access forms are based on the tables within the database, so it is important to use a table designed to gather the kind of information for which you are looking. It is also necessary to format your table fields to grab the data you need so you don't have to adjust or modify the information later.
- Skill level:
Other People Are Reading
Open Access 2007 and select the "Office" button. Select "New" and then "Blank Database." In the right task pane, type a name for your database and click "Create." The database opens to a new table in the data sheet view.
Click the "View" tab and select "Design View." In the field name row, type the first question of your survey. Change the data type to reflect the type of response you are expecting. For example, if you are asking for the user's name, change the data type to "Text." If you are asking a question about a date, change the data type to "Date/Time."
Customise each data type by editing the lower field properties. Here, you can format your fields by adding an input mask for the data. For example, if you are requesting the phone number, change the input mask to "Phone Number." This automatically programs the format to display the area code in parenthesis and insert a hyphen between the next three digits and the last four digits of the phone number.
Edit the field properties of questions that require a user to select a choice from a provided list. Click the "Lookup" tab in the field properties of the question. Change the "Display Control" drop-down list to "List Box." Edit the "Row Source Type" drop-down list to show "Values List." Click the ellipses in the "Record Source Box" and add the values for your customised list. For example, if you are asking the user to select her office location, enter the different office location in the "Record Source Box."
Save the changes to your survey by clicking the "Save" icon on the Quick Access Toolbar. Type the name of your survey in the "Field Name" section and click "OK."
Transform this survey into a form by clicking the "Form" icon on the "Create" tab. Your survey is now ready for data entry in the form view.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for