Access chapter 3
Layout view
Allows you to make changes to a form or report with the data displayed in the fields
From view
Allows you to view, modify, delete records or add to the records in a table
Since the data in a text box comes from a field in a table or query, a textbox control is referred to as a(n) ______ control.
Bound
When a report is displayed in layout view and you want to apple a theme to it, ______.
Click themes in the themes group, under report layout tools on the design tab.
Calculated
Control that contains an expression that most often summarizes a field that contains numerical data
Label
Control that contains descriptive information
Unbound
Control that does not have a source of data
Bound
Control that retrieves it's data from a field in an underlying table or query.
Design view
Displays the detailed structure of a query, form, or report.
True or false. The AND condition displays records that match at least one of the specified values.
False
True or false. The form tool gives more flexibility in the design, layout, and number of fields in a form than from the wizard.
False
True or false. The report wizard is the fastest way to create a report.
False
True or false. The techniques and tools for modifying the design of a report created using the Report Wizard are different from those used to modify the report created with the Report tool.
False
True or false. When using a form, you can remove a record from a table by right-clicking the record, and then clicking Delete.
False
True or false. When viewing a report in layout view, clicking Group & Sort in the Grouping & Totals group on the DESIGN tab opens the Group, Sort, Total dialog box
False
A ____ is a database object used to enter new records into a table or to edit, delete, or display existing records in a table.
Form
What is NOT a source of information for a report?
Information from a report
Text box
Most commonly used control
True or false. Data entry refers to the process of inputting the actual records into a database.
True
True or false. Filtering records in a form displays only a portion of the total records based on matching specific values.
True
True or false. In the relationships window, double-clicking a join line displays the Edit Relationship dialog box.
True
True or false. Queries or tables that provide the underlying data for a report are referred to as the report's record source
True
True or false. The report wizard is used when more flexibility is needed in the design of a report.
True
True or false. While in layout view, you can remove a control from a report by right-clicking Delete
True
Form tool
Used to create a form with a single mouse click, which includes all of the fields from the underlying data source
Form wizard
Walks you step by step through the creation of a form
You can create a form using the form _____, which walks you step by step through the creation of the form.
Wizard
