FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Access Module Maintaining and Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Matching

Review LaterAdd Note

Review Later

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

Premises

Responses

The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Ctrl + End

A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

select query

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

logical operators

Functions that perform arithmetic operations on selected records in a database.

condition

A type of query in which you specify the fields and records you want Access to select.

Home

The field used to determine the order of records in a datasheet.

aggregate functions

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

sort field

A dialog box used to enter text, expressions, or other values.

comparison operator

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

Zoom box

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

theme

Premises

The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

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

Functions that perform arithmetic operations on selected records in a database.

A type of query in which you specify the fields and records you want Access to select.

The field used to determine the order of records in a datasheet.

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

A dialog box used to enter text, expressions, or other values.

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

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

Responses

Ctrl + End

select query

logical operators

condition

Home

aggregate functions

sort field

comparison operator

Zoom box

theme

Show Answer

Correct Answer

Premises

Responses

The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

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

Functions that perform arithmetic operations on selected records in a database.

A type of query in which you specify the fields and records you want Access to select.

The field used to determine the order of records in a datasheet.

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

A dialog box used to enter text, expressions, or other values.

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

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

Premises

The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

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

Functions that perform arithmetic operations on selected records in a database.

A type of query in which you specify the fields and records you want Access to select.

The field used to determine the order of records in a datasheet.

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

A dialog box used to enter text, expressions, or other values.

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

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

Responses

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

The comparison operator, <>, is used to insert a condition that means ____.

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.

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

Date criteria are automatically enclosed in ____ when entered in a query design.

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.

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

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

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

The contents of query datasheet are permanent .

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

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?

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

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

Which comparison operator matches a pattern that includes wildcards?

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

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.