Question 1

Match between columns
                        Premises: Functions that perform arithmetic operations on selected records in a database.

Accepted Answer

The Answer of aggregate functions and condition and sort field is...

Question 2

The ____ command removes the display of one or more fields in Datasheet view.

Accepted Answer

A)  Hide Fields 
B)  Unhide Fields 
C)  Remove Fields 
D)  Display Fields

Question 3

The comparison operator, , is used to insert a condition that means ____.

Accepted Answer

A)  greater than 
B)  And 
C)  less than 
D)  not equal to

Question 4

In the accompanying figure, which field is the primary sort field?

Accepted Answer

A)  City 
B)  Patient 
C)  VisitDate 
D)  Visit

Question 5

In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Accepted Answer

A)  leftmost 
B)  rightmost 
C)  adjacent to the leftmost field 
D)  adjacent to the rightmost field

Question 6

When a question is asked of a database using a select query, the answer is returned as a datasheet.

Accepted Answer

A) True 
 B)False

Question 7

Logical operators must be used in order to combine two or more conditions in a query.

Accepted Answer

A) True 
 B)False

Question 8

In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

Accepted Answer

The answer of  
In the accompanying figure, the VisitDate...

Question 9

Fields included in a query may be modified after the query is saved.

Accepted Answer

A) True 
 B)False

Question 10

The criteria entered in the figure above are an example of which logical operator?

Accepted Answer

A)  Or 
B)  Not 
C)  And 
D)  Between

Question 11

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects.  List five capabilities that allow for data analysis and manipulation in Access.

Accepted Answer

The answer of Access queries provide several capabilities that allow...

Question 12

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field.  What is the common field between the two tables?

Accepted Answer

A)  Product ID 
B)  Customer ID 
C)  Date 
D)  Product

Question 13

Match between columns
                        Premises: The field used to determine the order of records in a datasheet.

Accepted Answer

The Answer of Zoom box and aggregate functions and Home is...

Question 14

In the accompanying figure, the sort order for the VisitDate field is descending . ____________________

Accepted Answer

A) True 
 B)False

Question 15

The condition "Seattle" for the field City in a student database is an example of what type of value?

Accepted Answer

A)  text value 
B)  field value 
C)  comparison value 
D)  criteria value

Question 16

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers.  To do this, she must use at last two tables to create the query.  Which two tables would be best to use for this query?

Accepted Answer

A)  Customer Info and Product Info 
B)  Order Info and Product Info 
C)  Customer Info and Order Info 
D)  Order Info and Vendors

Question 17

The accompanying figure illustrates the use of the ____________________ logical operator to define query criteria.

Accepted Answer

The answer of  
The accompanying figure illustrates the use...

Question 18

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Accepted Answer

A)  Tab 
B)  Home + Up Arrow 
C)  Up Arrow 
D)  Ctrl+Home

Exam 4: Maintaining and Querying a Database

Identify the letter of the choice that best matches the phrase or definition.

The ____ command removes the display of one or more fields in Datasheet view.

The comparison operator, , is used to insert a condition that means ____.

In the accompanying figure, which field is the primary sort field?

In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

When a question is asked of a database using a select query, the answer is returned as a datasheet.

Logical operators must be used in order to combine two or more conditions in a query.

In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

Fields included in a query may be modified after the query is saved.

The criteria entered in the figure above are an example of which logical operator?

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects. List five capabilities that allow for data analysis and manipulation in Access.

Identify the letter of the choice that best matches the phrase or definition.

In the accompanying figure, the sort order for the VisitDate field is descending . ____________________

The condition "Seattle" for the field City in a student database is an example of what type of value?

The accompanying figure illustrates the use of the ____________________ logical operator to define query criteria.

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?