Question 1

In the query shown in the accompanying figure, what are the names of the tables involved in the query?

Accepted Answer

The answer of  In the query shown in the...

Question 2

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Accepted Answer

The answer of Explain the relationship between the Like operator...

Question 3

In the query shown in the accompanying figure, what sort orders have been specified?

Accepted Answer

The answer of  In the query shown in the...

Question 4

Match between columns
                        Premises: An asterisk or question mark used in a query
A predefined Access formula that returns a value such as a subtotal or count
A statistic such as a subtotal or count is determined on a given field in a group of records
A datasheet's records are placed in a determined order
A field of data that is created based on values of other fields
A combination of field names, operators and functions

Accepted Answer

The Answer of Aggregate function and Sort and Wildcard character is...

Question 5

You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

Accepted Answer

The answer of  You want to add the PaymentDate...

Question 6

SQL statements start with the FROM keyword.

Accepted Answer

SQL statements start with different keywords depending on the type of statement, such as SELECT, INSERT, UPDATE, etc. FROM is a keyword used in SELECT statements to specify the table or view to retrieve data from.

Question 7

In SQL, the FROM keyword determines how records are sorted.

Accepted Answer

The FROM keyword in SQL is used to specify the table(s) from which the data is being retrieved, and it does not determine how the records are sorted. The ORDER BY keyword is used for sorting the records.

Question 8

Describe the one-to-many relationships of the tables shown in the accompanying figure.

Accepted Answer

The answer of  Describe the one-to-many relationships of the...

Question 9

Explain the position and purpose for the three typical field positions used in a crosstab query.

Accepted Answer

The answer of Explain the position and purpose for the...

Question 10

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 11

In Query Design View, you can drag the edge of a(n) field list to resize it.

Accepted Answer

This statement is true. You can drag the edge of the field list in Query Design View to resize it.

Question 12

When you are saving a query, you are saving a set of instructions written in Standard Query Language.

Accepted Answer

The answer of When you are saving a query, you...

Question 13

The > operator means less than in a query.

Accepted Answer

The > operator actually means "greater than" in a query.

Question 14

Discuss the use of the * wildcard character in query criteria.

Accepted Answer

The answer of Discuss the use of the * wildcard...

Question 15

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query.

Accepted Answer

Syntax refers to the rules that define the structure of a language, such as SQL for database queries, rather than tests or conditions for selecting records. Conditions that must be true for a record to be selected are typically referred to as criteria or filters in the context of database queries.

Question 16

Filtering refers to reordering records in either ascending or descending order based on the values in the field.

Accepted Answer

Filtering refers to the process of specifying criteria to display only those records that meet those criteria, not to reordering records. Sorting is the process that reorders records in either ascending or descending order based on field values.

Question 17

Queries evaluate sort orders from left to right .

Accepted Answer

Queries evaluate sort orders and other operations from left to right.

Question 18

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

Accepted Answer

The answer of  You want to search for all...

Question 19

When a query is saved, it saves VBA statements.

Accepted Answer

When a query is saved, it saves SQL statements, not VBA statements.

Question 20

You can view the SQL code for any query by switching to Code View.

Accepted Answer

The answer of You can view the SQL code for...

Quiz 6: Modifying the Database Structure