Study sets, textbooks, questions
Upgrade to remove ads
Access Ch 3
Terms in this set (45)
records you are searching for must match both criteria
Blank Report tool
an access feature with which you can create a report from scratch by adding the fields you want in the order you want them to appear
The term used to describe objects and controls that are based on data that is stored in tables.
A control connected to a field in the record source and is used to display, enter, and update data (AC 98).
Control on a database form or report that uses an expression to generate the data value for a field.
standard to which the outcome of a test is compared
The grouped arrangement of controls on a form or report
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
A filter that you can apply to a datasheet or form that rearranges the records based on a selected field value or part of a field value.
a process of change in the use of a house, from single-family owner occupancy to abandonment
a database view that allows the user to see all fields for one record and enter them one at a time
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.
A method of viewing or inputting data that displays only one record at a time.
What is an automated step-by-step method for creating a form in a database called?
When viewing a report, where does the subtotal related to the group of records appear?
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
A control on a form or report that contains descriptive information, typically a field name.
A small symbol that displays in the upper left hand corner of a selected control layout in a form or report that is displayed in layout view and that is used to move an entire group of controls
A view that allows you to see how your data will look when printed
must match only one criteria or the other
Same as form footer except it applies to individual printed pages
Same as form header except it applies to individual printed pages instead of to the form as a whole
Page number control
A control on a form or report that inserts the page numbers of the pages when displayed in Print Preview or when printed.
a window listing the properties for an object
Record selector bar
displays to left of each record
The tables or queries that contain the data used in a form (AC 85).
a document that uses data from tables and/or queries; the user controls which items in the database will appear in the report and how it is filtered or sorted
Information printed once at the end of a report; use to print report totals or other summary information for the entire report.
Contents appear at the top of the first page of the report
An Access tool that places all the fields from a table or query on a report.
Use this Wizard when you want to create a report quickly. The Wizard will ask you about the report you want to create and to select options in dialog boxes
a narrow strip along the left margin of a page that automates selection of text. When the mouse pointer is in the selection area, the cursor changes to an arrow pointing up and to the right
A control layout in which text box controls are arranged vertically with a label to the left of each text box control.
if data consist of two or more groups that have been thrown together, it is usually best to fit different linear models to each group than to try to fit a single model to all of the data
The order in which the insertion point moves from field to field on a form.
Text box control
Used for input and output
The main idea or meaning of a text. Often, this is an insight about human life revealed in a literary work
A control that is not connected to a record source and is used to display information, lines, rectangles, and pictures (AC 98).
Sets with similar terms
Access Chapter 3
Access Chapter 3 Vocabulary
Access Chapter 3
Microsoft 2010 Access Unit C
Other sets by this creator
Mod Civ Kengor Final
Mod Civ Kengor Midterm
Civ Arts Exam 1
Theology of the Spiritual Life Final Exam