Question 1

________ view shows the structure of the table with the fields and their definitions.

Accepted Answer

The answer of ________ view shows the structure of the...

Question 2

A many-to-many relationship is a relationship between tables in which one record in one table has many matching records in a second table,and one record in the related table has many matching records in the first table.

Accepted Answer

This is the definition of a many-to-many relationship in database design.

Question 3

________ view shows the values of the data within the table.

Accepted Answer

The answer of ________ view shows the values of the...

Question 4

A(n)________ is an association between tables based on common fields.

Accepted Answer

The answer of A(n)________ is an association between tables based...

Question 5

A(n)________ is a person,place,item,or event that you want to keep data about.

Accepted Answer

The answer of A(n)________ is a person,place,item,or event that you...

Question 6

Redundancy occurs when data is repeated several times in a database.

Accepted Answer

Redundancy in a database can lead to data inconsistency and increase storage requirements. Normalization is the process of removing redundancy and improving the efficiency of a database.

Question 7

Access allows you to import a smaller portion of a worksheet,known as a(n)________,into a table.

Accepted Answer

The answer of Access allows you to import a smaller...

Question 8

Excel ________ are frequently imported as field names.

Accepted Answer

The answer of Excel ________ are frequently imported as field...

Question 9

________ define the kind of data that can be entered into a field,such as numbers,text,or dates.

Accepted Answer

The answer of ________ define the kind of data that...

Question 10

A(n)________ is a character such as a tab or comma that separates the fields.

Accepted Answer

The answer of A(n)________ is a character such as a...

Question 11

Normalization is the process of minimizing the duplication of information in a relational database through effective database design.

Accepted Answer

Normalization is indeed the process of organizing data in a database to eliminate redundancy and improve data integrity. This is achieved by dividing larger tables into smaller and more specific ones, establishing relationships between them using foreign keys, and applying certain rules to ensure that each table contains only unique data. The ultimate goal is to make the database more efficient, flexible, and easier to maintain.

Question 12

Redundancy is a database concept that ensures that relationships between tables remain consistent.

Accepted Answer

Redundancy refers to the duplication of data in a database, while referential integrity ensures that relationships between tables remain consistent.

Question 13

The ________ data type is used for keys.

Accepted Answer

The answer of The ________ data type is used for...

Question 14

________ fields can store up to 1 gigabyte of characters,of which you can display 65,535 characters in a control on a form or report.

Accepted Answer

The answer of ________ fields can store up to 1...

Question 15

If you select Cascade Update Related Fields when you define a relationship,then when the primary key of a record in the one side table changes,Access automatically changes the foreign keys in all related records.

Accepted Answer

When you select Cascade Update Related Fields, Access automatically updates the foreign keys in all related records if the primary key of a record in the one side table changes.

Question 16

A(n)________ is information about the entity.

Accepted Answer

The answer of A(n)________ is information about the entity....

Question 17

A junction table breaks down the many-to-many relationship into two one-to-many relationships.

Accepted Answer

The answer of A junction table breaks down the many-to-many...

Question 18

________ fields have an upper limit of 255 characters.

Accepted Answer

The answer of ________ fields have an upper limit of...

Question 19

If your data has a unique identifier that is a natural part of your data,you can use the field as a natural primary key.

Accepted Answer

If your data already has a unique identifier that is a natural part of the data (such as a social security number for individuals or a product ID for products), then it is appropriate to use that as the primary key for the database table. This is because using a natural key ensures uniqueness and avoids redundant data.

Question 20

A(n)________ means that when you open the item,you open it in its original application such as Excel.

Accepted Answer

The answer of A(n)________ means that when you open the...

Quiz 2: Workshop 2: Tables, Keys, and Relationships