Exam 3: Maintaining and Querying a Database

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?

(Multiple Choice)

4.8/5

(32)

Question 41

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

Premises:

A criterion or rule that determines which records are selected when a query is run.

Responses:

aggregate functions

logical operators

condition

Correct Answer:

Verified

A criterion or rule that determines which records are selected when a query is run.

(Matching)

4.9/5

(24)

Question 42

Hiding a field in Datasheet view removes the field from the current table. ____________________

(True/False)

4.7/5

(28)

Question 43

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

(Multiple Choice)

4.9/5

(38)

Question 44

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

(True/False)

4.8/5

(34)

Question 45

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

(True/False)

4.9/5

(24)

Question 46

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

Premises:

The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Responses:

select query

aggregate functions

theme

Correct Answer:

Verified

The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

(Matching)

5.0/5

(32)

Question 47

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

(True/False)

4.9/5

(42)

Question 48

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

(Multiple Choice)

5.0/5

(41)

Question 49

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

Premises:

Operators that allow two or more conditions to be combined such as And.

Responses:

comparison operator

Home

logical operators

Correct Answer:

Verified

Operators that allow two or more conditions to be combined such as And.

(Matching)

4.8/5

(36)

Question 50

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

(True/False)

4.8/5

(35)

Question 51

A criterion, or rule, that determines which records are selected when a query is run is called a(n)____.

(Multiple Choice)

4.8/5

(41)

Question 52

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

(Short Answer)

5.0/5

(28)

Question 53

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.

(Multiple Choice)

4.8/5

(37)

Question 54

Expression Builder is found in the Query Setup group on the DESIGN tab. ____________________

(True/False)

5.0/5

(34)

Question 55

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

(Multiple Choice)

4.9/5

(34)

Question 56

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

(Multiple Choice)

4.8/5

(32)

Question 57

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

(True/False)

4.9/5

(30)

Question 58

A calculated field is formatted using the ____ for the field.

(Multiple Choice)

4.9/5

(42)

Question 59

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

(True/False)

4.8/5

(33)

Question 60

Showing 41 - 60 of 74

Hiding a field in Datasheet view removes the field from the current table. ____________________

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

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

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

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

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

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

A criterion, or rule, that determines which records are selected when a query is run is called a(n)____.

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

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.

Expression Builder is found in the Query Setup group on the DESIGN tab. ____________________

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

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

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

A calculated field is formatted using the ____ for the field.

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

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters