Question 1

Case-Based Critical Thinking Questions
Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
- When creating a query to determine which plants need full sun,which fields must be included in the query?

Accepted Answer

A)   Plant Name and When to Plant
B)   Amount of Sun and Annual 
C)   Plant Name and Amount of Sun
D)   Amount of Sun and When to Plant C

Question 2

Identify the letter of the choice that best matches the phrase or definition.
- The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Accepted Answer

h

Question 3

Which aggregate function supports the Yes/No field data type?

Accepted Answer

A)   Count
B)   Average 
C)   Minimum
D)   Sum A

Question 4

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n) ____.

Accepted Answer

A)   builder
B)   expression 
C)   operator
D)   query

Question 5

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

Accepted Answer

A)   Run
B)   Append 
C)   Show
D)   Design

Question 6

Identify the letter of the choice that best matches the phrase or definition.
- A type of query in which you specify the fields and records you want Access to select.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Accepted Answer

The answer of Identify the letter of the choice that...

Question 7

It is not possible to create a query from more than one table. ____________________

Accepted Answer

A) True 
 B)False

Question 8

The AutoFilter sort method works on a(n)____ field(s).

Accepted Answer

A)   multiple
B)   10 fields 
C)   adjacent
D)   single

Question 9

Identify the letter of the choice that best matches the phrase or definition.
- A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

A)  aggregate functions
B)  Zoom box
C)  theme
D)  logical operators
E)  comparison operatorF) conditionG) Ctrl + EndH) HomeI) sort fieldJ) select query

Question 10

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

Question 11

Access database objects are divided into categories on the Navigation Pane.____________________

Accepted Answer

A) True 
 B)False

Question 12

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 13

The most simple technique to use for filtering records is Filter By Form.____________________

Accepted Answer

A) True 
 B)False

Question 14

Access may base queries on one or more tables or queries.____________________

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

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

Accepted Answer

A)   reconstructing
B)   maintaining 
C)   developing
D)   editing

Question 17

A ____________________ is a set of records that answers the question resulting from a query.

Accepted Answer

The answer of  A ____________________ is a set of records...

Question 18

A field with the Short Text data type sorted in descending order will display the data in which order?

Accepted Answer

A)   A to Z
B)   lowest to highest 
C)   Z to A
D)   highest to lowest

Question 19

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Accepted Answer

A)   SUM
B)   New Row 
C)   Totals
D)   Add All

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 3: Maintaining and Querying a Database

Which aggregate function supports the Yes/No field data type?

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n) ____.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

It is not possible to create a query from more than one table. ____________________

The AutoFilter sort method works on a(n) ____ field(s) .

Identify the letter of the choice that best matches the phrase or definition. - A criterion or rule that determines which records are selected when a query is run.

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

Access database objects are divided into categories on the Navigation Pane.____________________

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.

The most simple technique to use for filtering records is Filter By Form.____________________

Access may base queries on one or more tables or queries.____________________

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

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

A ____________________ is a set of records that answers the question resulting from a query.

A field with the Short Text data type sorted in descending order will display the data in which order?

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

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