FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Building a Database and Defining Table Relationships

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The common field between two tables in the Relationship window is indicated by a(n) ____.

A) key icon
B) field name
C) join line
D) infinity symbol

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Field names in a table may only be changed in Design view.  _________________________

____ is the default name for a new table in an Access database.

Identify the letter of the choice that best matches the phrase or definition.

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.  _________________________

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

Which data type allows the designer to define the Field Size property?

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.  _________________________

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

Identify the letter of the choice that best matches the phrase or definition.

List six guidelines for designing databases.

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

The data type that allows both sequential and random numbering is the ____ data type.

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

Identify the letter of the choice that best matches the phrase or definition.