Question 1

In field names,object names,and filenames,uppercase letters are used to distinguish the first letter of a new word in ________ notation.

Accepted Answer

The answer of In field names,object names,and filenames,uppercase letters are...

Question 2

The data type of a field determines the type of operations that can be performed on that field.

Accepted Answer

The data type of a field determines the type of operations that can be performed on that field. For example, a numerical field can be added, subtracted, multiplied or divided but a textual field cannot be.

Question 3

The Run command appears as a red exclamation point in Design view.

Accepted Answer

The Run command appears as a red exclamation point in Design view when the form or report contains errors that prevent it from running.

Question 4

Using a field that contains a year of birth and a field that contains the current year to determine the age of a person listed in a database is called ________.

Accepted Answer

The answer of Using a field that contains a year...

Question 5

If a worksheet in an Excel workbook was named,Access uses the worksheet name as the database name.

Accepted Answer

Access does not use the worksheet name as the database name. Access is a separate database management system and requires its own database file with a unique name.

Question 6

A query is a question asked about the data in a database.

Accepted Answer

A query is a question asked about the data in a database, therefore the statement is true.

Question 7

When you add two or more tables to a query,you must manually create new join lines.

Accepted Answer

Most database management systems automatically create join lines based on existing relationships or primary/foreign key constraints when tables are added to a query.

Question 8

An unchanging value is called a(n)________.

Accepted Answer

The answer of An unchanging value is called a(n)________....

Question 9

Multitable queries take advantage of table relationships in a database.

Accepted Answer

Multitable queries can access data from multiple tables by utilizing the relationships between them. This makes it possible to retrieve and combine data from different tables to answer more complex questions.

Question 10

All Excel spreadsheets are ready to import into an Access database.

Accepted Answer

While Access can import Excel spreadsheets, it is not guaranteed that all spreadsheets will be compatible and require some adjustments before importing. Additionally, importing may not be the best solution depending on the complexity and size of the spreadsheet.

Question 11

A relationship cannot be established between two tables unless a primary key has been set in the first table.

Accepted Answer

A primary key in a table is necessary to uniquely identify each row, and hence to create relationships with other tables.

Question 12

A(n)________ produces a value from an expression or function that uses one or more fields in a database.

Accepted Answer

The answer of A(n)________ produces a value from an expression...

Question 13

Calculated fields are frequently created with ________ data.

Accepted Answer

The answer of Calculated fields are frequently created with ________...

Question 14

If you choose Append a copy of the records to the table as an option for incoming data,the data will be added to an existing table.

Accepted Answer

If you choose to append a copy of the records to the table as an option for incoming data, the data will be added to an existing table, thus the statement is true.

Question 15

The Simple Query Wizard displays a series of dialog boxes that guide users through the query design process.

Accepted Answer

The Simple Query Wizard is designed to guide users through the process of creating a basic select query in Microsoft Access. It presents a series of dialog boxes that prompt users for the necessary information, such as the fields to include in the output, the tables to query, and any criteria or sorting options.

Question 16

In most cases,it is advisable to enforce referential integrity in databases with related tables.

Accepted Answer

Enforcing referential integrity helps to maintain data accuracy and consistency by preventing invalid data from being entered into related tables.

Question 17

A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.

Accepted Answer

A one-to-many relationship is established when a single record in the first table (where the primary key is located) is associated with multiple records in the second table (where the foreign key is located). The foreign key in the second table matches the primary key in the first table, not the other way around.

Question 18

Access requires a primary key for every table.

Accepted Answer

Access does not require every table to have a primary key, but it is highly recommended for data integrity and relationship purposes.

Question 19

Comparison operators include *,?,and [ ].

Accepted Answer

Comparison operators include <, >, <=, >=, ==, and !=. The symbols listed in the statement (*, ?, and []) are actually wildcards used in regular expressions.

Question 20

The Is Null expression is used to find blank fields.

Accepted Answer

The Is Null expression is used to search for blank fields or fields with no data in them.

Quiz 14: Tables and Queries in Relational Databases: Designing Databases and Extracting Data