Lesson 4 Access

To rename a table or other database object, you do which of the following?

Close It

Which of the following is not a field property?

Column Template

Properties

Controls the appearance or behavior characteristics for objects and related parts like fields and controls

Dennis needs to format his sales amount column to show dollar signs. Which format would he use?

Currency

Nick wants to make notes for future users of his database so they will properly use the field names and types. Where would he make these notes?

Description

Which of the following is not a way to validate data?

Filtering

Dennis needs to format the numbers in his database to three decimal places. Which number format would he use?

Fixed

Linda wants to ensure birth dates are entered as MM/DD/YYYY. Which field property will be used?

Format

Dillan wants to ensure social security numbers are entered in a proper format. Which field property will be used?

Input Mask

Which field property requires users to enter data in a specific format?

Input mask

Amanda wants to ensure there are only two characters for the state abbreviation. What should she do?

Limit field size

Which type of field enables a user to select from a list of values when updating the contents of a field?

Lookup

Which type of field allows you to select more than one choice from a list?

Multi valued

Nick needs to specify two characters for the student ID field. What area of Design View would he access to specify this?

Properties

Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?

Provide a caption

What are the rules that a user should follow when entering data into a table?

Validation

An expression that limits the values that can be entered in the field

Validation Rule

The text in the error message that appears when users violate a validation rule

Validation Text

String that contains no characters & is used to indicate that you know no value exist

Zero - Length string

Multi-valued lookup field

A field that allows you to select more than one value from a list

Quick Start Field

A predefined set of characteristics and properties that describe a field, including a field name, a date type, and a number of other field properties.

Input Mask

A set of placeholder characters that forces users to enter data in a specific format