Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

False

Question 3

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

Accepted Answer

False

Question 4

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 5

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

Accepted Answer

In a query datasheet, you can enter and edit data just like in a table datasheet.

Question 6

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 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

Filters are used to select a subset of records in a datasheet by setting criteria for which records to display. The filtered view can then be printed, sorted or exported.

Question 9

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

Accepted Answer

Copying a query before making modifications to it ensures that you have a backup in case you make a mistake or want to revert to the original query. This helps prevent accidental changes to the original query.

Question 10

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

Accepted Answer

Deleting a field from a query does not affect the underlying table. It only removes the field from the results of the query. To delete a field from the underlying table, you must use a data definition query or directly modify the table's design.

Question 11

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

A query is specifically designed to select a subset of data from one or more tables and display it in a datasheet format.

Question 12

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 is a logical view of the data because it presents a subset of the data based on specified criteria, rather than a duplicate copy of the entire dataset. The other options are not accurate descriptions of a query datasheet.

Question 13

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

In many database applications, selecting a record and using the delete function from the toolbar or menu is a standard method to remove records.

Question 14

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

Accepted Answer

This is true. In Query Design View, you can add, delete, or change fields by selecting the field from the available tables or queries and dragging it onto the design grid, or by using the Field List pane to make changes.

Question 15

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 in Query Design View to set conditions for the data that is retrieved, which can limit the number of records shown in the resulting datasheet. Posts, versioning, and indices are not relevant to this process.

Question 16

Query criteria are not case sensitive.

Accepted Answer

Query criteria are not case sensitive because the database server automatically converts all input to uppercase or lowercase before comparing it to the data in the database.

Question 17

A query can be used to create calculated fields.

Accepted Answer

This is true. A query can be used to create calculated fields by using arithmetic operations, functions, and expressions on existing fields in one or more tables.

Question 18

In Access, the Save As command allows you to save either the entire database or the current object with a new name.

Accepted Answer

The Save As command in Access can be used to save the entire database or just the current object (like a table or form) with a new name, allowing for duplication or backup.

Question 19

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

Accepted Answer

OR criteria can be applied on different Criteria rows in the query design grid. This is useful when trying to retrieve records that meet any one of several criteria.

Question 20

A filter can be used to create calculated fields.

Accepted Answer

A filter is used to limit the data displayed, it cannot be used to create calculated fields. Calculated fields are created using formulas or expressions that manipulate existing fields.

Quiz 2: Building and Using Queries