Access Section 2 – Flashcards

What happens when you reduce the size of a field in an Access table that already has data entered in it?

When you enter a description for the fields in your table, the descriptive text appears ____ when you are adding records to a datasheet or form.

The default value for a Short Text data type is ____ characters.

What should you do if you need to make structural changes to a table that has a relationship with another table?

Delete more than one field in a table by using this feature to select multiple fields and delete all of them in one operation.

When two tables are joined on each table's primary key field, the join is known as a ____ relationship.

With a table in Design View, you can move a field by

This property stores descriptive titles for fields and is useful if you abbreviate a field name or want to show spaces between words in a compound field name.

Which of the following characteristics do the Memo, Date/Time, Currency, and Yes/No data types have in common?

Suppose Access prevents you from entering a value in the foreign key field of a related table because that value does not exist in the primary key field of the primary table. Access has just enforced a concept known as

What is the maximum character length of a field name?

When a field in a table is deleted, it

When two tables are joined, you can view the records of the related table from within the primary table datasheet by displaying a

How is creating a table in Design view different from creating a table in Datasheet view?

In a one-to-many relationship, a common field is used to join tables. On the "one" side of the relationship, the field is called the ____, while on the "many" side of the relationship, it is called the ____.

How do you start the Input Mask Wizard?

A ____ field is used when you want to restrict the data entered into the field to a list of values.

On which tab will you find the button used to add fields to a table?

To restrict the values in a Lookup table to just those values contained in the drop-down list, change the setting in the

Which of the following input mask codes requires the field to contain an entry, and the entry must be a letter, A through Z?

Access is called a relational database management system because of the relationships that can be established among

Design view is used to ____ a table.

A(n) ____ displays a pattern in the datasheet or form indicating how data is to be entered into the field.

You want to ensure that a matching record exists in the primary table when you add a record to the related table. What step should you take?

The two field properties associated with validating field entries are

What happens when you define a validation rule for a field that already contains data?

_____ are used to control the behavior or interactivity of the field in database objects.