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 
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

1.AND: All criteria must be true in orde

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 
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 
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 
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 
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 
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 
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 
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 
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) * * 
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

1.Sorting refers to reorganizing the rec

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.

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.

Getting Started With Microsoft Office 2010 Question

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

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.

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.

Getting Started With Microsoft Office 2010 Question

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters