Access 2

Description

Access 2 final review
Holly Harper
Quiz by Holly Harper, updated more than 1 year ago
Holly Harper
Created by Holly Harper over 3 years ago
2
0

Resource summary

Question 1

Question
Which of the following contains a unique value for each record?
Answer
  • primary key
  • lookup field
  • input mask
  • metadata

Question 2

Question
Which of the following wildcard characters does Access use in validation rules to match any single character, which also includes numbers?
Answer
  • ?
  • *
  • #
  • $

Question 3

Question
What must you do if you make any changes to the relationships between tables?
Answer
  • print them
  • save them
  • copy them
  • delete them

Question 4

Question
Which of the following displays a drop-down list in both table view and form view when the field's arrow is clicked?
Answer
  • Lookup field
  • Text box
  • Input mask
  • Combo box

Question 5

Question
Which of the following displays a list of data values from which the user can choose?
Answer
  • Lookup field
  • Text box
  • Input mask
  • Record validation

Question 6

Question
In Access, what are field validation rules called?
Answer
  • input masks
  • expressions
  • metadata
  • foreign keys

Question 7

Question
Which of the following input mask characters requires a user to enter a letter?
Answer
  • 0
  • L
  • #
  • 9

Question 8

Question
Which of the following print options bypasses the Print dialog box?
Answer
  • Quick Print
  • Print
  • Print Preview
  • Send to Printer

Question 9

Question
Which of the following field validation rules requires the user to enter a value that is less than 5?
Answer
  • <5
  • <> 0
  • 'M' or 'F'
  • Not Null

Question 10

Question
What is a primary key called that is made up of more than one field?
Answer
  • primary key
  • foreign key
  • concatenated key
  • combined key
Show full summary Hide full summary

Similar