Question 1

Query Design View presents the fields you can use for a query in small windows called field ____.
A) glossaries
B) lists
C) links
D) catalogs

Accepted Answer

The small windows used to select fields in Query Design View are called field lists.

Question 2

Enter OR criteria on different Criteria rows in the query design grid.

Accepted Answer

OR criteria can be added on different criteria rows in the query design grid to retrieve data that matches any of the specified criteria.

Question 3

A filter can be used to create calculated fields.

Accepted Answer

A filter is used to narrow down the recordset in a table or query based on specific criteria. It does not create calculated fields. Calculated fields are created using formulas or expressions in a query or report design.

Question 4

SQL stands for ____.
A) Structured Query Lingo
B) Standard Query Lingo
C) Standard Query Language
D) Structured Query Language

Accepted Answer

The answer of SQL stands for ____.
A) Structured Query Lingo
B)...

Question 5

To filter for comparative data, use the Filter By Selection feature.

Accepted Answer

The answer of To filter for comparative data, use the...

Question 6

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Accepted Answer

By copying the original query, you have a backup in case you make mistakes or unintended changes while modifying the copied query. This ensures that the original query is never accidentally altered.

Question 7

A query can be used to create calculated fields.

Accepted Answer

A query can use calculations to create new fields that do not exist in the underlying table. The calculated fields can be based on existing fields, expressions, or functions.

Question 8

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

The answer of The easiest way to filter the records...

Question 9

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

Accepted Answer

This statement is true. A query allows for the selection of certain fields and records from tables and presents them as a single datasheet.

Question 10

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Accepted Answer

This is the correct process to delete records from a query datasheet in Microsoft Access.

Question 11

The question mark (?) is the wildcard character which stands for any single character in criteria.

Accepted Answer

The answer of The question mark (?) is the wildcard...

Question 12

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

In Query Design View, you can add, delete, or change fields by selecting the field and making the desired changes in the Criteria or Field row.

Question 13

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Accepted Answer

When you run a select query in datasheet view, you can edit the data just like you do in a table datasheet.

Question 14

Access saves ____ automatically as you move from record to record.
A) data
B) queries
C) tables
D) all of the above

Accepted Answer

Access saves data automatically as you move from record to record. It does not automatically save queries or tables unless specifically instructed to do so.

Question 15

Filters are used to select a subset of records in a datasheet.

Accepted Answer

Filters are indeed used to select a subset of records in a datasheet.

Question 16

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.
A) criteria
B) posts
C) versioning
D) indices

Accepted Answer

Criteria are used to set conditions that limit the records shown in the resulting datasheet. This allows for more targeted and efficient data retrieval. Posts, versioning, and indices are not relevant to limiting records in Query Design View.

Question 17

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Accepted Answer

The answer of The asterisk (*) is the wildcard used...

Question 18

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.
A) fix
B) post
C) freeze
D) view

Accepted Answer

The answer of In large datasheets, you may want to...

Question 19

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

Deleting a field from a query does not delete it from the underlying table, as the table and query are two separate objects. The only way to delete a field from a table is by editing the structure of the table itself.

Question 20

A query datasheet is sometimes called a ____ of the data.
A) logical view
B) duplicate copy
C) table simulator
D) warehouse

Accepted Answer

A query datasheet presents a logical view of the data, displaying only selected fields and records based on specific criteria. It does not create a duplicate copy of the data or simulate a table. The term "warehouse" typically refers to the physical storage location of data, not a specific type of data display.

Quiz 2: Building and Using Queries

Query Design View presents the fields you can use for a query in small windows called field ____.