Question 1

SQL is the acronym for " simple query language ".

Accepted Answer

A) True 
 B)False

Question 2

In the figure above, item 7 points to the ____.

Accepted Answer

A) Records 
B) Link line 
C) Datasheet 
D) Tables

Question 3

To move fields in the query grid, drag the field ____________________.

Accepted Answer

The answer of To move fields in the query grid,...

Question 4

Explain the difference between AND and OR criteria.

Accepted Answer

The answer of Explain the difference between AND and OR...

Question 5

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel wants to build a query that will show each customer name, day of the week (if specific), and subdivision.What criterion should he use to quickly find his customers whose day of the week varies?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 6

Match between columns
                        Premises: Criterion that finds all records where no entry has been made in the field
Creates a temporary subset of records
Used to search for a pattern
Rules that determine how criteria is entered
Creates a datasheet of selected fields and records from one or more tables
The lower pane in Query Design View
Limiting conditions used to narrow the number of records on a datasheet
Putting records in ascending or descending order based on a field's values

Accepted Answer

The Answer of Wildcard and Query and Filter and Query is...

Question 7

Each time a query is opened, it displays a current view of the latest updates to the database.

Accepted Answer

A) True 
 B)False

Question 8

In the figure above, item 1 points to the ____.

Accepted Answer

A) Grid button 
B) Table button 
C) View button 
D) Report button

Question 9

Criteria ____ is the term for rules by which criteria must be entered in a query.

Accepted Answer

A) Syntax 
B) Formatting 
C) Sorting 
D) Filter by Form

Question 10

In the figure above,  item 3 could also be entered as ____.

Accepted Answer

A) colorado 
B) COLORADO 
C) CoLoRaDo 
D) All of the above

Question 11

In the figure above, item 2 points to the ____.

Accepted Answer

A) Criteria cells 
B) Datasheet view 
C) Field list 
D) Design grid

Question 12

A query datasheet is sometimes called a ____ of the data.

Accepted Answer

A) Logical View 
B) Duplicate Copy 
C) Table Simulator 
D) Warehouse

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In the figure above, which button would you use to filter for an exact match?

Accepted Answer

A) 2 
B) 3 
C) 4 
D) 5

Question 16

In the figure above, item 4 points to "Cost" as the ____.

Accepted Answer

A) Fourth field of a query 
B) Date/Time field 
C) Query design grid 
D) None of the above

Question 17

In the figure above, which button indicates whether a filter is applied or not?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4

Question 18

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

Accepted Answer

A) 0 
B) Is Not Null 
C) *=* 
D) * *

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Define sorting, filtering, and finding.

Accepted Answer

The answer of Define sorting, filtering, and finding....

Exam 2: Building and Using Queries

SQL is the acronym for " simple query language ".

In the figure above, item 7 points to the ____.

To move fields in the query grid, drag the field ____________________.

Explain the difference between AND and OR criteria.

Match each term with the statement that best describes it.

Each time a query is opened, it displays a current view of the latest updates to the database.

In the figure above, item 1 points to the ____.

Criteria ____ is the term for rules by which criteria must be entered in a query.

In the figure above, item 3 could also be entered as ____.

In the figure above, item 2 points to the ____.

A query datasheet is sometimes called a ____ of the data.

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

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

In the figure above, which button would you use to filter for an exact match?

In the figure above, item 4 points to "Cost" as the ____.

In the figure above, which button indicates whether a filter is applied or not?

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

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

Define sorting, filtering, and finding.