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 1

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 2

Multiple Choice

Review LaterAdd Note

Review Later

A relationship between Access tables that is a relationship between one record in the first table and zero,one,or many records in the second table,and at least one record in the second table matches at most one record in the first table,is defined as a ____ relationship.

A) One-to-One
B) One-to-Many
C) One-to-Most
D) Many-to-One

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

Discuss at least three advantages of including a primary key in a table.

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

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._________________________

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

All fields in a database should be contained in one table. _________________________

A database management system is a useful tool only if it meets which of the following criteria?

Which data type would be the best logical data type for a field named PaidDate?

List six guidelines for designing databases.

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Identify the letter of the choice that best matches the phrase or definition. -An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____.

Identify the letter of the choice that best matches the phrase or definition. -The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

In the Database Design grid,press the Enter key to move from one property to the next property._________________________