Question 1

Calculated fields are frequently created with ________ data.

Accepted Answer

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

Question 2

Multitable queries take advantage of table relationships in a database.

Accepted Answer

Multitable queries use the relationships between tables in a database to retrieve data from multiple tables at once. This allows for more complex and meaningful data analysis.

Question 3

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

Accepted Answer

Although Access can import Excel spreadsheets, not all spreadsheets may be suitable for import, as their contents may not fit into an Access database structure. Additionally, the data in the Excel spreadsheet must be organized in a way that can be mapped to Access tables and fields.

Question 4

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 values that can be stored in that field and the type of operations that can be performed on those values. For example, a field of type text can store alphanumeric characters and can be used in string operations, while a field of type number can store numeric values and can be used in mathematical operations.

Question 5

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 in Microsoft Access.

Question 6

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

Accepted Answer

A query is indeed a question asked about the data in a database. It is a way to retrieve specific information from a database by selecting and filtering data based on specific criteria.

Question 7

An unchanging value is called a(n)________.

Accepted Answer

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

Question 8

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 9

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 10

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 11

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 12

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 help users create basic queries in Access by displaying a series of dialog boxes with step-by-step instructions.

Question 13

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

Accepted Answer

Enforcing referential integrity ensures that data in a related table is valid and consistent with data in the primary table. This helps to prevent data inconsistencies and improves data quality.

Question 14

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

Accepted Answer

The answer of When you add two or more tables...

Question 15

Comparison operators include *,?,and [ ].

Accepted Answer

Comparison operators include ==, !=, >, <, >=, and <=. The * operator is the multiplication operator, the ? operator is part of regular expressions, and the [ ] operator is used for indexing and slicing in lists and other sequences.

Question 16

The Is Null expression is used to find blank fields.

Accepted Answer

The Is Null expression is specifically used to find fields that do not have any value, also known as blank or null fields.

Question 17

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. A database in Access is a separate file with the .accdb or .mdb extension. It is not directly linked to the names of worksheets in an Excel workbook.

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

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

Choosing "Append a copy of the records to the table" means the incoming data will be added to an existing table.

Question 20

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

Accepted Answer

A primary key is a unique identifier for each record in a table. Without a primary key, it is not possible to establish a relationship between tables as there would be no way to uniquely identify records in the first table.

Quiz 31: Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data