Access Forms, Filters & Reports
6 th period
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
place limits on (extent or access)
A control connected to a field in the record source and is used to display, enter, and update data (AC 98).
Text boxes that display the results of expressions.
the activity of managing or exerting control over something
A "container" that groups together the controls in a form so that you can change them as a group. (AC 95).
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.
A control on a form or report that inserts the current date each time the form or report is opened
this view is used in a table to define field names and assign data types
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
pulls out the records that meet specific criteria and includes only those records in the merge
the spatial arrangement of something as distinct from its substance
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.
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
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).
used to display sums, counts, or averages of groups of data
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
Upgrade to remove ads