Question 1

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

Accepted Answer

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

Question 2

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 
A)  navigation mode 
B)  design mode 
C)  editing mode 
D)  selection mode

Question 3

The + symbol is an example of a(n) ____ operator.

Accepted Answer

A)  arithmetic 
B)  logical 
C)  comparison 
D)  calculation 
A)  arithmetic 
B)  logical 
C)  comparison 
D)  calculation

Question 4

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 
A)  reconstructing 
B)  maintaining 
C)  developing 
D)  editing

Question 5

Results of a query are narrowed by using the Or logical operator.

Accepted Answer

A) True 
 B)False

Question 6

____ 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 
A)  Group By 
B)  SUM 
C)  Totals 
D)  Maximum

Question 7

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Accepted Answer

The answer of A set of restrictions placed on records...

Question 8

In the criterion,

Accepted Answer

A)  less than 250 
B)  equal to 250 
C)  less than or equal to 250 
D)  greater than or equal to 250 
A)  less than 250 
B)  equal to 250 
C)  less than or equal to 250 
D)  greater than or equal to 250

Question 9

Kyra has been asked to sort a database of cities and zip codes using a query.  The result should show records grouped by city with zip codes in ascending order within the city groups.  What is the best method for Kyra to use to achieve this result?

Accepted Answer

Kyra needs to set the field containing c

Question 10

Match between columns
                        Premises: The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Accepted Answer

The Answer of Home and condition and Ctrl + End is...

Question 11

The default query type for Access is the Crosstab query.

Accepted Answer

A) True 
 B)False

Question 12

In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

Accepted Answer

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

Question 13

Data may be sorted in a table datasheet, a form, and a ____.

Accepted Answer

A)  report 
B)  query datasheet 
C)  record 
D)  related table 
A)  report 
B)  query datasheet 
C)  record 
D)  related table

Question 14

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 
A)  builder 
B)  expression 
C)  operator 
D)  query

Question 15

Which view must be used to delete an entire record?

Accepted Answer

A)  Design 
B)  Query 
C)  Navigation 
D)  Datasheet 
A)  Design 
B)  Query 
C)  Navigation 
D)  Datasheet

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 
A)  Run 
B)  Append 
C)  Show 
D)  Design

Question 18

Case-Based Critical Thinking Questions Case 3-2 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' 
A)  Yes 
B)  >No 
C)  check=yes 
D)  'yes'

Question 19

In the accompanying figure, which field represents a calculated field?

Accepted Answer

A)  Visit ID 
B)  Invoice Amt 
C)  Late Fee 
D)  Date of Visit 
A)  Visit ID 
B)  Invoice Amt 
C)  Late Fee 
D)  Date of Visit

Question 20

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

Accepted Answer

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

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

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

The + symbol is an example of a(n) ____ operator.

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

Results of a query are narrowed by using the Or logical operator.

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

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

In the criterion,

Kyra has been asked to sort a database of cities and zip codes using a query. The result should show records grouped by city with zip codes in ascending order within the city groups. What is the best method for Kyra to use to achieve this result?

The default query type for Access is the Crosstab query.

In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

Data may be sorted in a table datasheet, a form, and a ____.

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

Which view must be used to delete an entire record?

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

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

In the accompanying figure, which field represents a calculated field?

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 4: Maintaining and Querying a Database

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

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

The + symbol is an example of a(n) ____ operator.

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

Results of a query are narrowed by using the Or logical operator.

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

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

In the criterion,

Kyra has been asked to sort a database of cities and zip codes using a query. The result should show records grouped by city with zip codes in ascending order within the city groups. What is the best method for Kyra to use to achieve this result?

The default query type for Access is the Crosstab query.

In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

Data may be sorted in a table datasheet, a form, and a ____.

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

Which view must be used to delete an entire record?

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

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

In the accompanying figure, which field represents a calculated field?

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters