Module 3

Question 1

Updating

Answer 1

To add, change, and delete records in database tables to keep them current and accurate.

Question 2

maintaining

Answer 2

To add, change, and delete records in database tables to keep them current and accurate.

Question 3

F2 key

Answer 3

The function key you press to switch between navigation mode and editing mode in a datasheet.

Question 4

navigation mode

Answer 4

The mode in which Access selects an entire field value, and your typed entry replaces the highlighted field value.

Question 4

editing mode

Answer 4

The mode in which you can insert or delete characters in a field value based on the location of the insertion point.

Question 5

Hide Fields

Answer 5

In Datasheet view, the command that allows you to remove the display of one or more fields.

Question 6

Unhide Fields

Answer 6

In Datasheet view, the command that allows you to redisplay any hidden fields.

Question 6

recordset

Answer 6

The set of records that results from running a query.

Question 6

Find command

Answer 6

A command you use to search for data in a form or a table or query datasheet so that you can locate a specific field value or part of a field value.

Question 7

expand indicator

Answer 7

In a datasheet, the plus sign that lets you display the related records in the subdatasheet.

Question 7

And logical operator

Answer 7

The logical operator you use in a query when you want a record selected only if two or more conditions are met.

Question 8

subdatasheet

Answer 8

A datasheet that displays the records related to the current record.

Question 8

Or logical operator

Answer 8

The logical operator you use in a query when you want a record selected if at least one of the specified conditions is met.

Question 9

Filter By Form

Answer 9

A filtering technique that changes a datasheet or form to display blank fields, allowing you to select a value from a list in any blank field to apply a filter that selects only those records containing that value.

Question 9

Filter By Selection

Answer 9

A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field.

Question 9

logical operators

Answer 9

In a query, an operator that allows you to combine two or more conditions.

Question 10

theme

Answer 10

A predefined set of formats including colors, fonts, and other effects that enhance a database object’s appearance and usability.

Question 10

Zoom box

Answer 10

A dialog box you can use to enter text, expressions, or other values.

Question 11

expression

Answer 11

A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation.

Question 11

calculated field

Answer 11

A field that you create with an expression that displays the results of the expression in a datasheet, form, or report, but does not exist as a field in the database.

Question 12

Aggregate functions

Answer 12

A function that performs an arithmetic operation on selected records in a database.

Question 12

Expression Builder

Answer 12

An Access tool that makes it easy to create an expression by providing boxes for entering the expression, options for displaying and selecting common operators, and one or more lists of expression elements, such as table and field names.

Question 13

Group By operator

Answer 13

In a query, an operator that divides the selected records into groups based on the values in the specified field.

Question 13

Object Type

Answer 13

The default category in the Navigation Pane; it arranges objects by type (tables, queries, forms, reports, and so on).

Question 14

collapse indicator

Answer 14

In a datasheet, the minus sign that lets you hide the related records in the subdatasheet.

Question 15

nonunique

Answer 15

A sort field for which more than one record can have the same value.

Question 15

Query Wizard

Answer 15

An Access tool that prompts you for information by asking a series of questions and then creates the appropriate query based on your answers.

Question 16

Sorting

Answer 16

To rearrange records in a specified order or sequence.

Question 16

AutoFilter

Answer 16

An Access feature, available by clicking the arrow to the right of a field name in Datasheet view for a table or query, that enables you to quickly sort and display the field’s values in various ways.

Question 17

sort field

Answer 17

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

Question 18

unique

Answer 18

A sort field whose value is different for each record.

Question 19

secondary sort field

Answer 19

A second field that determines the order of records in an object that are already sorted by the primary sort field.

Question 19

primary sort field

Answer 19

The first sort field specified that determines the order of records in an object.

Question 19

filter

Answer 19

A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records.

Question 19

All Access Objects

Answer 19

The default group in the Navigation Pane; it displays all objects in the database.