Access Review Concepts

OR

Different criteria in multiple rows implies ______________. Records must match one criterion, but not all.

Report

Displays data from a table or query in a format suitable for printing.

Field

Each column in a table represents a specific data value called a(n)

Print dialog

Here you can specify which pages to print and how many copies to print.

Enable Content

If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.

calculated field

In a query, a ____________________ displays a value returned by an expression (a formula).

Caption

In the ____________ box, type the field name as it should appear in labels and column headings.

Ctrl+S

The keyboard shortcut used to save a database object

Table

The query results data sheet looks like a ___________________ datasheet. Including the same navigation buttons at the bottom.

Queries

These extract data from a table or related table and can include actions such as updating data values or deleting data.

relational

This database is a group of tables related to one another by common fields.

Input Mask

This ensures that users enter data in a particular format. For example, a field for social security numbers can force users to enter numbers in the format 123-45-6789

Sort

This feature allows you to control the order in which records appear in a table, query, or form.

Non-zero (!)

This is not a valid comparison operator used in criteria. (>, <, = are all valid operators)

tables

This is where all the data is stored

Default Value

This property allows you to add a preset value to a field.

Split

This type of form combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.

Report Wizard

This walks you step by step through the process of creating a REPORT.

Z-A

When sorting a Date/Time field, use the ________ button it you want to show the most recent records first.

Move to

When you enter data in a table, Access saves it each time you ____________________ a new field or being a new record.

Attachment

You can add this type of field so you can add images, Word documents, or almost any other type of data file to a record.

undo

You cannot ____________ a record deletion.

Relationships

objects in Access are related to one another defined by common fields between tables.

Lookup fields

A specific list of items that are useful to use for fields

YES/NO

A(n) _______________ field stores a true/false value as a -1 or 0