Question 1

You can edit or delete a relationship once it has been created in the Relationships window.

Accepted Answer

It is possible to edit or delete a relationship once it has been created in the Relationships window.

Question 2

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Accepted Answer

In a one-to-many relationship, the "one" side often uses the primary key as the unique identifier, which is then referenced by a foreign key in the table on the "many" side to establish the relationship.

Question 3

A common place to use an Input Mask property would be for a Phone Number field.

Accepted Answer

Input Mask property can be used to ensure that users enter phone numbers in a consistent format such as (123) 456-7890.

Question 4

A subdatasheet is used to examine field properties.

Accepted Answer

A subdatasheet is used to display related records from another table or query within a datasheet view, not to examine field properties.

Question 5

The Validation Rule property is not used with Text or Date/Time fields.

Accepted Answer

The Validation Rule property can be used with Text or Date/Time fields in order to restrict what values are allowed in the field.

Question 6

The Field Size property is not available for Currency fields.

Accepted Answer

The Field Size property is not available for Currency fields.

Question 7

When a Caption property is not entered, the field name is used to label the field.

Accepted Answer

If the Caption property is not entered for a field, then the field name will be used as the label for the field.

Question 8

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

Accepted Answer

Referential integrity specifically ensures that relationships between tables remain consistent, such as ensuring that a foreign key in one table always refers to an existing primary key in another table. It does not guarantee the accuracy of the data itself within those fields.

Question 9

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Accepted Answer

The Attachment data type in Access allows you to store multiple files per record, including documents and images, and is more versatile and efficient than the older OLE Object data type, which was primarily used for embedding or linking to OLE objects from other applications.

Question 10

To tie the information from one table to another in an Access relational database, a(n)____ must be common to each table.
A)Record
B)Field
C)Object
D)Property

Accepted Answer

A field must be common to each table in a relational database to establish a relationship between them, typically through a primary key in one table and a foreign key in another.

Question 11

Each field must be given an associated field description.

Accepted Answer

Field descriptions are helpful for documentation and clarity but are not strictly required for all systems or applications. Fields can be created and used without associated descriptions, depending on the context and requirements.

Question 12

The Enforce Referential Integrity button is found on the Database toolbar.

Accepted Answer

The Enforce Referential Integrity option is typically found in the relationship settings of a database management system, not on a toolbar.

Question 13

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Accepted Answer

Referential integrity does not allow the deletion of a record from the "one" table if it has matching records in the "many" table. This is to ensure that data is not lost and relationships between the tables are maintained.

Question 14

Which of the following is a clue that a database needs to be redesigned?
A)Key fields are defined for each table.
B)One-to-many relationships are defined for each table.
C)There are multiple tables in the database.
D)There is redundant data in one or more tables.

Accepted Answer

Redundant data in one or more tables is a clear indication that a database needs to be redesigned. This is because redundant data can lead to data inconsistencies and increase the risk of errors while updating or deleting records. It also increases the storage space required for the database. Key fields and one-to-many relationships are important aspects of database design, but they do not necessarily indicate the need for a redesign. Having multiple tables is typical in a database design and is not a sign of a problem.

Question 15

A field that contains unique information for each record is called a(n)____ field.
A)Text
B)Data
C)Linking
D)Primary key

Accepted Answer

A primary key field contains unique information for each record, ensuring that each entry in a database table can be uniquely identified.

Question 16

Which of the following is NOT a good candidate for a key field for a Customer table?
A)Last Name
B)Customer Number
C)Employee Identification Number
D)Customer ID

Accepted Answer

Last Name is not unique and can be shared by multiple customers, making it unsuitable as a key field.

Question 17

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Accepted Answer

Changing the Decimal Places property only affects how the data is displayed, it does not actually change the stored data. The stored data remains unchanged regardless of the Decimal Places setting.

Question 18

A relational database can best be described as a collection of related ____ designed to minimize redundant data.
A)Indexes
B)Tables
C)Links
D)Properties

Accepted Answer

Tables are the basic building blocks of a relational database. They are used to store data in a structured way, and they can be related to each other through foreign keys. This helps to minimize redundant data, as the same data does not need to be stored in multiple tables.

Question 19

Use the Format property for a Date/Time field to display the date 1/17/2010 as January 17, 2010.

Accepted Answer

The Format property in a Date/Time field can be set to display dates in various formats, including "mmmm dd, yyyy," which would display 1/17/2010 as January 17, 2010.

Question 20

Which of the following is NOT a principle of relational database design?
A)Design each table to contain fields that describe only one subject.
B)Identify a primary key field or key field combination for each table.
C)Data should be entered before table relationships are built.
D)Build one-to-many relationships between the tables of your database using a field common to each table.

Accepted Answer

The principle of entering data before building table relationships is not a principle of relational database design. Instead, identifying a primary key, designing each table to contain fields for only one subject, and building one-to-many relationships between tables using a common field are key principles of relational database design.

Quiz 5: Modifying the Database Structure Question

You can edit or delete a relationship once it has been created in the Relationships window.

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

A common place to use an Input Mask property would be for a Phone Number field.

A subdatasheet is used to examine field properties.

The Validation Rule property is not used with Text or Date/Time fields.

The Field Size property is not available for Currency fields.

When a Caption property is not entered, the field name is used to label the field.

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

To tie the information from one table to another in an Access relational database, a(n) ____ must be common to each table.

Each field must be given an associated field description.

The Enforce Referential Integrity button is found on the Database toolbar.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Which of the following is a clue that a database needs to be redesigned?

A field that contains unique information for each record is called a(n) ____ field.

Which of the following is NOT a good candidate for a key field for a Customer table?

Changing the Decimal Places property for a field does not change the actual data stored in the field.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Use the Format property for a Date/Time field to display the date 1/17/2010 as January 17, 2010.

Which of the following is NOT a principle of relational database design?