30 terms

Access 2016 Comprehensive, 1e Ch 4

STUDY
PLAY

Terms in this set (...)

A database object that is used to add data into or edit data in a table.
Form
Used to create data entry forms for customers, employees, products, and other tables.
Form tool
The table or query that supplies the records for a form or report.
Record source
Displays fields in a vertical column.
Stacked layout
Displays fields horizontally.
Tabular layout
A text box, button, label, or other tool you use to add. edit, and display the data in a form or report.
Controls
Provides guides to help keep controls aligned horizontally and vertically and give your form a uniform appearance.
Layout control
A simplified user interface primarily used for data entry; does not allow you to make changes to the layout.
Form view
Enables users to make changes to a layout while viewing the data in the form or report.
Layout view
Enables you to change advanced design settings you cannot see in Layout view, such as removing a layout control.
Design view
Combines two views of the same record source. By default: the top section is displayed in a stacked layout and the bottom section is displayed in a tabular layout.
Split form
Displays multiple records in a tabular layout similar to a table's Datasheet view with more customization options.
Multiple items form
A defined set of colors. fonts, and graphics that can be applied to a form or report.
Theme
A database document that outputs meaningful information to its readers.
Report
Used to instantly create a tabular report based on the table or query currently selected.
Report tool
Prompts you for input and then uses your answers to generate a customized report.
Report Wizard
Enables you to easily create mailing labels, name tags, and other specialized tags.
Label Wizard
Enables you to determine what a printed report will look like in a continuous page layout.
Report view
Enables you to see exactly what the report will look like when it is printed.
Print Preview
A file type that was created for exchanging documents independent of software applications and operating system environment.
Portable Document Format (PDF)
A report can be made from one or more tables or a query.
The object(s) that a report is based on is known as the:
(a) Control.
(b) Record Source.
(c) Theme.
(d) Tabular Layout
Record Source
Which of the following statements is false?
(a) Both forms and reports can use tabular and stacked layouts.
(b) A stacked layout displays data in a vertical column.
(c) A tabular layout displays data horizontally.
(d) Stacked layouts are more common for reports because they use less paper when printed
Stacked layouts are more common for reports because they use less paper when printed
In order to summarize data in a report and override the sort order of the record source you would use:
(a) A text box.
(b) A button on a report.
(c) The Group, Sort, and Total Pane.
(d) A label on a report.
The Group, Sort, and Total Pane
The simplest view you can use to modify control widths in a form is:
(a) Layout view.
(b) Form view.
(c) Design view.
(d) Print Preview.
Layout view
Which of the following views provides you with the most flexibility in modifying forms and reports?
(a) Design view
(b) Layout view
(c) Form view/Report view
(d) Print Preview
Design view
Which of the following statements about reports is false?
(a) Reports can be saved to a file (such as a Word document) on your computer.
(b) Reports are primarily used to modify data.
(c) Reports can produce output in a number of ways, including mailing labels.
(d) Reports can be created simply by using the Report tool.
Reports are primarily used to modify data
Use the ____ to see exactly what the printed report will look like before printing.
(a) Report tool
(b) Report Wizard
(c) Report view
(d) Print Preview
Print Preview
If you need to send a report to a user who does not have Microsoft Office available, which of the following file formats would be the best choice to ensure it can be opened?
(a) Word
(b) Excel
(c) Reader
(d) Portable Document Format (PDF)
Portable Document Format (PDF)
Which of the following statements is false?
(a) Reports are generally used for printing, emailing, or viewing data on the screen.
(b) Layouts for forms and reports are the predefined sets of colors, fonts, and graphics.
(c) Forms are often used for inputting data.
(d) Forms and reports both include controls, such as text boxes. that can be resized.
Layouts for forms and reports are the predefined sets of colors, fonts, and graphics
Which of the following statements is true?
(a) You can group records to show a list of properties by state.
(b) You can sort records in reports but not in forms.
(c) A sort can only be set on one field at a time.
(d) You can either group or sort records (but not both).
You can group records to show a list of properties by state