Access Forms Filters and Reports

Vanessa Romero

3rd Period

bound control

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

filter by form

A filtering technique that changes the datasheet to display empty fields, allowing you to select a value from a list in any blank field to apply a filter that selects only those records containing that value.

filter by selection

A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field.

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

calculated controls

Text boxes that display the results of expressions.

control layout

The grouped arrangement of controls on a form or report

data entry

action of typing the record data into database

control

an object on a form or report that displays data, such as a text box or check box, or a button that lets users control a program

detail section

contains the report details or content information; required

data control

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

blank report tool

create a report from scratch by adding the fields you want in the order you want them to appear

form tool

create a simple form with one mouse click

group footer

displays the field label by which the summarized has been grouped

group header

information printed at the beginning of each new group of records, for example the group name

group,sort,and total pane

opens at the bottom of your screen in which you can control how information is sorted and grouped in a report: provides the most flexibility for adding or modifying groups, sort orders, or totals options on a report

AND condition

records you are searching for must match both criteria

filtering

the process of displaying only records that meet specific conditions

design view

the view that allows you to change the structure of a database object

bound

used to describe objects and controls that are based on data that is stored in tables

form

window for displaying and collecting information