Data Manipulation  «Prev  Next»

Access Field - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. Which of the following should be stored in a field with the text data type?
Please select all the correct answers.
  A. Zip codes
  B. Part numbers such as X4-32F
  C. Employee numbers such as 44-322 and 545-321
  D. Item prices such as $4.95

2. You create a table to hold information about invoices that you send. The table contains the following fields: Company billed, Project, Time Worked, Invoice Date, and Invoice NumberWhich fields could be the primary key?
Please select all the correct answers.
  A. Company billed
  B. A new AutoNumber field
  C. Invoice date
  D. Invoice number

3. If you need to move a field to another place in the datasheet you can
Please select the best answer.
  A. Delete the field and paste it into its new position
  B. Select field, click and drag the column to its new position and release
  C. Right-click on the column in the new position and choose Insert Column
  D. Double-click on the field name and drag the column to its new position.

4. To edit a hyperlink you need to
Please select all the correct answers.
  A. Select the part you need to edit and type over it
  B. Right-click and choose Hyperlink>Edit Hyperlink
  C. Double-click the hyperlink, then edit it
  D. Tab to the hyperlink field and press F2

5. An Input Mask Wizard can be used when you want to control data entry in which of the following ways?
Please select all the correct answers.
  A. Make sure that the data entered matches a certain pattern
  B. Make sure that a value is bigger or smaller than some threshold value
  C. Make sure that a certain number of letters or numbers are entered
  D. Make sure that the data matches one of a number of pre-approved values (i.e. small, medium, large)