Checkpoint 4 - Queries and User Interface

Vocabulary flashcards covering database queries, action queries, form design, and user interface concepts from Checkpoint 4.

Calculated field

A query field whose value is derived from other fields or expressions.

Count

A totals function that counts records or non-null values.

Sum

A totals function that adds numerical values.

Group By

Groups records with the same value so aggregate calculations can be performed.

Update query

An action query that changes values in existing records.

Append query

An action query that adds records to another table.

Delete query

An action query that permanently removes matching records.

Make-Table query

An action query that creates a new table from query results.

Action-query safety

Back up first and preview the intended records with a SELECT query.

Form

A user-friendly interface for viewing, entering and editing database data.

Bound form

A form connected to a table or query record source.

Combo box

A control that lets a user select from a list, often displaying a friendly value while storing an ID.

Tab order

The sequence controls receive focus when the user presses Tab.

Subform

A form embedded inside another form to display related child records.

Main form/subform link

The parent and child forms are linked using a common key.

Friendly display / stored ID

Interfaces can display meaningful names while storing keys.

Navigation form

A menu that gives users clear routes to common database tasks.

Command button

A clickable control that performs an action.

Query as form source

A form can be based on a query rather than directly on a table.

Usable interface

Clear labels, consistent layout, logical controls and restricted choices reduce errors.