Holly Harper
Quiz by , created more than 1 year ago

Access 2 final review

4
0
0
Holly Harper
Created by Holly Harper almost 4 years ago
Close

Access 2

Access 2

Question 1 of 10

1

Which of the following contains a unique value for each record?

Select one of the following:

  • primary key

  • lookup field

  • input mask

  • metadata

Explanation

Question 2 of 10

1

Which of the following wildcard characters does Access use in validation rules to match any single character, which also includes numbers?

Select one of the following:

  • ?

  • *

  • #

  • $

Explanation

Question 3 of 10

1

What must you do if you make any changes to the relationships between tables?

Select one of the following:

  • print them

  • save them

  • copy them

  • delete them

Explanation

Question 4 of 10

1

Which of the following displays a drop-down list in both table view and form view when the field's arrow is clicked?

Select one of the following:

  • Lookup field

  • Text box

  • Input mask

  • Combo box

Explanation

Question 5 of 10

1

Which of the following displays a list of data values from which the user can choose?

Select one of the following:

  • Lookup field

  • Text box

  • Input mask

  • Record validation

Explanation

Question 6 of 10

1

In Access, what are field validation rules called?

Select one of the following:

  • input masks

  • expressions

  • metadata

  • foreign keys

Explanation

Question 7 of 10

1

Which of the following input mask characters requires a user to enter a letter?

Select one of the following:

  • 0

  • L

  • #

  • 9

Explanation

Question 8 of 10

1

Which of the following print options bypasses the Print dialog box?

Select one of the following:

  • Quick Print

  • Print

  • Print Preview

  • Send to Printer

Explanation

Question 9 of 10

1

Which of the following field validation rules requires the user to enter a value that is less than 5?

Select one of the following:

  • <5

  • <> 0

  • 'M' or 'F'

  • Not Null

Explanation

Question 10 of 10

1

What is a primary key called that is made up of more than one field?

Select one of the following:

  • primary key

  • foreign key

  • concatenated key

  • combined key

Explanation

Previous
Next