Question 1

The Enforce Referential Integrity box should normally be checked.

Accepted Answer

Enforcing Referential Integrity ensures that data between related tables remains consistent and accurate by preventing the creation of records in a table that have no matching records in a related table. It is recommended to check the Enforce Referential Integrity box while creating relationships in a database to ensure the consistency and accuracy of data. This setting enforces the existence of matching values between related tables, preventing the creation of orphaned records or data inconsistencies.

Question 2

Although you can link to external data, it is not recommended.

Accepted Answer

Linking to external data is a common and often recommended practice in various fields such as web development, data analysis, and software engineering, as it allows for the use of up-to-date information, sharing of resources, and collaboration without duplicating data.

Question 3

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

Accepted Answer

The answer of One way to fix the problem that...

Question 4

A person's age is often a field used in table design.

Accepted Answer

The answer of A person's age is often a field...

Question 5

You can easily ________ your data by using a multitable query.

Accepted Answer

The answer of You can easily ________ your data by...

Question 6

Access does not require that every table has a primary key.

Accepted Answer

In Microsoft Access, while it is highly recommended to have a primary key for each table to ensure each record is uniquely identified, it is not a strict requirement for table creation.

Question 7

For security purposes you want to have data redundancy in your tables.

Accepted Answer

Data redundancy typically refers to the unnecessary duplication of data within a database, which can lead to inconsistencies and increased storage costs, rather than enhancing security. For security purposes, techniques like encryption, access controls, and backups are more relevant.

Question 8

A database designer needs to be concerned about what fields might be needed rather than file size.

Accepted Answer

The answer of A database designer needs to be concerned...

Question 9

The primary key can only be a single field.

Accepted Answer

The primary key can be a combination of multiple fields, making it a composite key.

Question 10

You can only have one primary key in a table, but you can have several foreign keys.

Accepted Answer

This statement is true. A primary key is a column or set of columns that uniquely identifies each row in a table, whereas a foreign key is a column or set of columns in one table that refers to the primary key in another table. A table can have multiple foreign keys that link to different tables, but it can only have one primary key. A table can only have one primary key, but it can have multiple foreign keys that reference the primary key of other tables.

Question 11

________ queries allow you to take full advantage of table relationships.

Accepted Answer

The answer of ________ queries allow you to take full...

Question 12

Access provides a wizard for easily importing Excel data into Access.

Accepted Answer

Access provides a wizard that guides users through importing Excel data into Access, making the process easy and straightforward. Access does provide a wizard for importing Excel data, making it easy to bring data from an Excel spreadsheet into an Access database.

Question 13

A good way to know what fields you will need is to think of what reports you might need later.

Accepted Answer

By considering the reports that you will need in the future, you can better anticipate what data fields you will need to collect and include in your database. Thinking of what reports you might need later can help determine what fields you will need in order to generate those reports.

Question 14

The ________ sign should be put around dates so that Access knows they are dates.

Accepted Answer

The answer of The ________ sign should be put around...

Question 15

Access requires that common fields be named exactly the same.

Accepted Answer

In Access, common fields between tables do not need to be named exactly the same for relationships or queries to work, as long as the field types are compatible and properly linked or referenced.

Question 16

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Accepted Answer

Establishing relationships between tables allows you to combine fields from multiple tables in order to create a query or report that pulls data from multiple sources. This can be particularly useful in data analysis or reporting scenarios where information from multiple tables needs to be combined in order to gain insights or make decisions. Establishing relationships between tables allows you to link related data and retrieve information from multiple tables in a single query or report. This makes it easier to analyze and present data from different perspectives or for different purposes.

Question 17

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add another ________ that does have common fields with both existing tables.

Accepted Answer

The answer of One way to fix the problem that...

Question 18

Although you can create calculated fields in a query, most prefer to add them the table instead.

Accepted Answer

Calculated fields are typically added in queries rather than directly in tables because queries allow for more flexibility and dynamic calculations based on the current data in the table. Adding calculated fields directly to tables can lead to data redundancy and increased complexity in database management.

Question 19

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

Accepted Answer

Since an AutoNumber field type is automatically generated and unique for each new record added, there is no need to update related fields when the primary key changes. Therefore, the Cascade Update Related Fields checkbox becomes irrelevant. The Cascade Update Related Fields checkbox only applies when the primary key field is not an AutoNumber type.

Question 20

There might be times when you want to add the same field to a query several times.

Accepted Answer

This is possible in some cases, such as when you want to display multiple values of a field, or group by a field and also display it in the output. However, it is not always necessary or recommended to include duplicate fields in a query. This can be necessary if you want to group or sort the data based on different criteria or apply different filters on the same field.

Quiz 2: Tables and Queries in Relational Databases

The Enforce Referential Integrity box should normally be checked.

Although you can link to external data, it is not recommended.

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

A person's age is often a field used in table design.

You can easily ________ your data by using a multitable query.

Access does not require that every table has a primary key.

For security purposes you want to have data redundancy in your tables.

A database designer needs to be concerned about what fields might be needed rather than file size.

The primary key can only be a single field.

You can only have one primary key in a table, but you can have several foreign keys.

________ queries allow you to take full advantage of table relationships.

Access provides a wizard for easily importing Excel data into Access.

A good way to know what fields you will need is to think of what reports you might need later.

The ________ sign should be put around dates so that Access knows they are dates.

Access requires that common fields be named exactly the same.

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add another ________ that does have common fields with both existing tables.

Although you can create calculated fields in a query, most prefer to add them the table instead.

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

There might be times when you want to add the same field to a query several times.