Question 1

Identify the letter of the choice that best matches the phrase or definition.
- Functions that perform arithmetic operations on selected records in a database.

Accepted Answer

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

Question 2

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?
- To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query.  The Perennial field has a data type of Yes/No.  Which criterion should Jorge use in the query for the Perennial field?

Accepted Answer

A)  Yes 
B)  >No 
C)  check=yes 
D)  'yes'

Question 3

The primary key of a table must be unique for each record; however,the ____ sort field does not have to be unique.

Accepted Answer

A)  table 
B)  chronological 
C)  primary 
D)  adjacent

Question 4

Queries based on more than one table,must have a ____ field.

Accepted Answer

A)  common 
B)  similar 
C)  text 
D)  calculated

Question 5

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

Accepted Answer

A)  modify 
B)  rename 
C)  delete the existing query 
D)  include comparison operators

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

To toggle between navigation mode and editing mode press the F2 keyboard shortcut. ____________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Identify the letter of the choice that best matches the phrase or definition.
- A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

Accepted Answer

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

Question 10

The default name for a new Access query is ____________________.

Accepted Answer

The answer of  The default name for a new Access...

Question 11

A query based on more than one table is a(n) ____query.

Accepted Answer

A)  multiple 
B)  advanced 
C)  relationship 
D)  multitable

Question 12

Identify the letter of the choice that best matches the phrase or definition.
- Operators that allow two or more conditions to be combined such as And.

Accepted Answer

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

Question 13

____ is the default entry for each field in the Total row of the query design grid.

Accepted Answer

A)  Group By 
B)  SUM 
C)  Totals 
D)  Maximum

Question 14

A sort field is unique if more than one record can have the same value for the sort field.__________________

Accepted Answer

A) True 
 B)False

Question 15

Which comparison operator matches a pattern that includes wildcards?

Accepted Answer

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

Question 16

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

Accepted Answer

A)  navigation mode 
B)  design mode 
C)  editing mode 
D)  selection mode

Question 17

It is more efficient to use the Query Wizard for common,informational queries than to design your own query. ____________________

Accepted Answer

A) True 
 B)False

Question 18

The first field specified in the sorting process is called the ____________________ field.

Accepted Answer

The answer of  The first field specified in the sorting...

Question 19

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

Accepted Answer

A) True 
 B)False

Question 20

A calculated field created in a query generates results when ____.

Accepted Answer

A)  the database is opened 
B)  the query's underlying table is opened 
C)  when a report is created 
D)  when the query is run

Exam 3: Maintaining and Querying a Database

Identify the letter of the choice that best matches the phrase or definition. - Functions that perform arithmetic operations on selected records in a database.

The primary key of a table must be unique for each record; however,the ____ sort field does not have to be unique.

Queries based on more than one table,must have a ____ field.

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

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

To toggle between navigation mode and editing mode press the F2 keyboard shortcut. ____________________

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

Identify the letter of the choice that best matches the phrase or definition. - A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

The default name for a new Access query is ____________________.

A query based on more than one table is a(n) ____query.

Identify the letter of the choice that best matches the phrase or definition. - Operators that allow two or more conditions to be combined such as And.

____ is the default entry for each field in the Total row of the query design grid.

A sort field is unique if more than one record can have the same value for the sort field.__________________

Which comparison operator matches a pattern that includes wildcards?

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

It is more efficient to use the Query Wizard for common,informational queries than to design your own query. ____________________

The first field specified in the sorting process is called the ____________________ field.

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

A calculated field created in a query generates results when ____.