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.

(Multiple Choice)

4.9/5

(37)

Question 41

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.9/5

(28)

Question 42

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

(Multiple Choice)

5.0/5

(25)

Question 43

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

(Multiple Choice)

4.9/5

(38)

Question 44

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

(Multiple Choice)

4.9/5

(30)

Question 45

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

(True/False)

4.7/5

(28)

Question 46

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

(True/False)

4.9/5

(38)

Question 47

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

(True/False)

5.0/5

(34)

Question 48

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.

(Multiple Choice)

4.8/5

(30)

Question 49

The default name for a new Access query is ____________________.

(Short Answer)

4.8/5

(29)

Question 50

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

(Multiple Choice)

4.8/5

(38)

Question 51

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.

(Multiple Choice)

4.8/5

(39)

Question 52

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

(Multiple Choice)

4.8/5

(32)

Question 53

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

(True/False)

4.7/5

(38)

Question 54

Which comparison operator matches a pattern that includes wildcards?

(Multiple Choice)

4.8/5

(42)

Question 55

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

(Multiple Choice)

4.9/5

(41)

Question 56

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

(True/False)

4.9/5

(28)

Question 57

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

(Short Answer)

4.8/5

(29)

Question 58

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

(True/False)

4.9/5

(34)

Question 59

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

(Multiple Choice)

4.8/5

(35)

Question 60

Showing 41 - 60 of 75

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 ____.

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Filters