Access

Created by elizabeth_bec 

Upgrade to
remove ads

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

data type

the collection of related information that displays one record at a time uses this type of layout.

record

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

single form

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

autonumber

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

form

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

criteria

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

data type

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

quick start

an access field property that prevents a field in a table from having two of the same values

unique

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

relational database

a structural collection of related information about people, events, and things

database

the computer software that allows people to interact with a database

database management system

an access view that displays records in rows and fields in columns

datasheet

each individual characteristics in a record that diplays as a single column in a datasheet

field

a database object that displays a subset of data in response to a specific question

query

a database object used to display the result of a query or the contents of a table on the screen or in printed form

report

the blank row at the end of a datasheet used to add records to a table

append

an access field that limits the number of characters that can be typed into text or number field

field size

a rule that keeps related values synchronized

referential integrity

an access view that displays tools to modify the format of a report or form while being able to view the data that it is intended to display

layout

A wizard that quickly adds fields to a new query

Simple Query

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

IntelliSense

Equal to and greater than are examples of this type of operatpr

Comparison

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

Show Table

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

And

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

Or

This wildcard charater can represent any combination of characters.

Asterisk *

This wildcard character can represent any single character

Question mark ?

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

Square bracket

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

Total

In a query, criteria is added in this view

Design

In a query, results are displayed in this view

Datasheet

An IntelliSense menu of commands that match the characters you are typing

AutoComplete

An IntelliSense box that explains the purpose of the selected AutoComplete

Quick Info

In query criteria, dates are surrounded by this character.

3

An operator that finds all bumbers ort dates between and including two values

Between... And

A combination of fields, mathematical operators, and pre-built functions that calculates values

Expression

A data type used to store values that can have one of two possible values

Yes/No

The operator that is placed at the beginning of criteria that use wildcards

Like

A calculation for a group of data such as a total, an average, or a count

Summary Statistics

The arrangement of data and labels in a form or report

Layout

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

Form Wizard

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

Blank Form tool

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

Logo

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

Title

Cells arranged in rows and columns into which controls are placed

Contol grid

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

Input mask

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

One-to-many form

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

Main Form

By default, subforms display in this view.

Datasheet

An Access view used to format a form or report while viewing a sample of the data

Layout View

A layout that places labels in the first column and data in the second column

Columnar

An Access view used to enter data in a form

Form view

Objects on a form or report that describe each field.

Labels

Objects on a form or report that displays the data from fields

Text boxes

This property sheet tab contains the input mask that is replaced as you type data into the field

Placeholder character

The symbol in an input mask that is replaced as you type data into the field

Placeholder character

Formatting that evaluated the values in a field and formats that data accroding to the rules you specify; for example, only values over 1000 will have bold applied

Conditionial formatting

A form contained within another form that displays records related to the other form

Subform

When you want to build a form for a subset of data, you can base the form on this

Query

Cells arranged in rows and columns into which controls are placed

Layout

To combine two or more cells in a tabular layout

Merge

This is used when you want to build a report by adding fields one at a time or arrange them in different layout

Blank Report tool

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

Logo

To display a subset of records on a report that match a given criterion

Filter

The amount of space between a control's border and other controls on the form or report

Padding

An Area at the beginning of a report that contians labels, text boxes, and other controls.

Report Header

An area on the top of each page that contians labels, text boxes, and other controls.

Page Header

An area at the bottom of each page that contians labels, text boxes, and other controls.

Page footer

An area at the end of a report that contians labels, text boxes, and other controls.

Report footer

A tool that can create a report with a single click

Report tool

A page orientation where the page is wider than it is tall

Landscape

This can be removed from a report to prevent printing blank pages

Extra Space

This pane is used to add fields to a report in Layout view

Field list

This pane is used to grtoup and sort reports

Group, Sort, and Total Pane

A report formatted so that the data can be printed on a sheet of labels

Label report

This view is used when you want the most control over your report layout

Design View

This property is changed when you need to add page breaks before report headers

Force New Page

A text box that displays the result of an expression

Calculated control

When no alternating row color is desired, select this value

No Color

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