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