Access Forms, Filters & Reports

22 terms by taylorwhitmire74

Create a new folder

Advertisement Upgrade to remove ads

6 th period

Taylor Whitmire

6th Peridod

AND condition

records you are searching for must match both criteria

Blank Report tool

an efficient way to create a report, especially if you plan to include only a few fields in your project

Bound

place limits on (extent or access)

Bound Control

A control connected to a field in the record source and is used to display, enter, and update data (AC 98).

Calculated Controls

Text boxes that display the results of expressions.

Control

the activity of managing or exerting control over something

Control Layout

A "container" that groups together the controls in a form so that you can change them as a group. (AC 95).

Data Entry

The process of getting information into a database, usually done by people typing it in by way of data-entry forms designed to simplify the process.

Date Control

A control on a form or report that inserts the current date each time the form or report is opened

Design View

this view is used in a table to define field names and assign data types

Detail Section

contains the report details or content information; required

Filter By Form

Use when you need to display records that contain one or more values based on the values stored in one or more fields (AC 58).

Filter By Selection

filters for information related to an active cell

Filtering

pulls out the records that meet specific criteria and includes only those records in the merge

Form

the spatial arrangement of something as distinct from its substance

Form Footer

An area at the bottom of the form, below the Detail area, in which you can enter explanatory text, date codes, or anything else that applies to the form as a whole.

Form Header

An area at the top of the form, above the Detail area, in which you can enter titles, explanatory text, graphics, or anything else that applies to the form as a whole

Form Tool

Creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source (AC 85).

Group Footer

used to display sums, counts, or averages of groups of data

Group Header

A tool that refines reports by sorting information into groups

Group, Sort, and Total Pane

a pane in a report in which you can modify the grouping fields, sort fields, and calculations for the report

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