Access Matching Set

30 terms by heycrisveth

Create a new folder

Advertisement Upgrade to remove ads

Database object

The basic part of a database that you work with; for example, tables, queries, forms, and reports.

Record

The collection of related information that displays in a single row of a database table.

Single form

A form that displays one record at a time uses this type of layout.

AutoNumber

A data type that automatically assigns a unique, numeric value to a field.

Form

A database object used to enter new records, delete records, or update existing records.

Criteria

The conditions used in a query to select the records that you are looking for.

Data type

This specifies the kind of information that a field will hold; for example, text or numbers.

Quick start

A set of fields that can be added with a single click. For example, the Address data type inserts five fields for storing postal addresses.

Unique

An Access field property that prevents a field in a table from having two of the same values.

Relational Database

A database that consists of two or more tables that are related by sharing a field common to both tables.

Simple Query

A wizard that quickly adds fields to a new query.

IntelliSense

A technology that displays Quick Info, ToolTips, and AutoComplete as you type expressions.

Comparison

Equal to (=) and greater than (>) are examples of this type of operator.

Show Table

This dialog box is used to add tables to an existing query.

And

In the query design grid, two criteria placed in the same row use this logical operator.

Or

When two criteria are placed in different rows in the query design grid, this logical operator will be applied.

Asterisk (*)

This wildcard character can represent any combination of characters.

Question mark

This wildcard character can represent any single character.

Square bracket

When using a field name in a calculated field, the field's name must start and end with this character.

Total

To add summary statistics to a query, this row be added to the query.

Layout

The arrangement of data and labels in a form or report.

Form Wizard

A tool used to create a form where the desired fields are selected before they are added to the form.

Blank Form tool

An Access feature that adds fields to the form when you double-click them in the Field List.

Logo

A small picture that can be added to a form header, typically to the left of the title.

Title

A form control that displays the name of a form by default; the actual text can be edited later.

Control grid

Cells arranged in rows and columns into which controls are placed.

Input mask

A set of special characters that control what can and cannot be entered in a field.

One-to-many form

A type of form that has a subform that displays related records from another table.

Main form

This name is often applied to the form that has a subform.

Data sheet

By default, subforms display in this view.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set