Form
A database object that is used to add data into or edit data in a table.
Form tool
Used to create data entry forms for customers, employees, products, and other primary tables.
Record source
The table or query that supplies the records for a form or report.
Stacked layout
Displays fields in a vertical column.
Tabular layout
Displays data horizontally.
Controls
The text boxes, buttons, boxes, and other tools you use to add, edit, and display the data in a form or report.
Layout control
Provides guides to help keep controls aligned horizontally and vertically and give your form a uniform appearance.
Form view
A simplified interface primarily used for data entry; does not allow you to make changes to the layout.
Layout view
Enables users to make changes to a layout while viewing the data on the form or report.
Design view
Enables you to change advanced design settings you cannot see in the Layout view, such as a background image.
Split form
Combines two views of the same record source�one section is displayed in a stacked layout and the other section is displayed in a tabular layout.
Multiple Items form
Displays multiple records in a tabular layout similar to a table's Datasheet view, with more customization options.
Theme
A defined set of colors, fonts, and graphics that can be applied to a form or report.
Report
A document that displays information from a database in a format that outputs meaningful information to its readers.
Report tool
Used to instantly create a tabular report based on the table or query currently selected.
Report Wizard
Asks you questions and then uses your answers to generate a customized report.
Label Wizard
Enables you to easily create mailing labels, name tags, and other specialized tags.
Report view
Enables you to see what a printed report will look like in a continuous page layout.
Print Preview
Enables you to see exactly what the report will look like when it is printed.
Portable Document Format (PDF)
A file type that was created for exchanging documents independent of software applications and operating system environment.
Record Source.
The table or query that supplies the records for a form or report is also known as the:
Theme.
Control.
Tabular Layout.
Record Source.
Stacked layouts are more common for reports because they will use less paper when printed.
Which of the following statements is false?
Both forms and reports can use tabular and stacked layouts.
Stacked layouts are more common for reports because they will use less paper when printed.
A tabular layout displays data horizontally.
A stacked layou
A report
Which of the following is not an example of a control?
Buttons on a report
A report
A box on a report
A text box on a form
Layout view.
The simplest interface you can use to modify control widths in a form is in:
Layout view.
Design view.
Report view.
Form view.
Design view.
Which of the following views is the most powerful, but also the most complicated?
Print Preview.
Layout view.
Form view/Report view.
Design view.
Reports are primarily used to modify data.
Which of the following statements about reports are false?
Reports can produce output in a number of ways, including mailing labels.
Reports are primarily used to modify data.
Reports can be created simply using the Report tool.
Reports can be saved to a
Print Preview
Use the ____________ to see exactly what the printed report will look like before printing.
Report Wizard
Report tool
Report view
Print Preview
Portable Document Format (PDF)
If you have a client working on a Mac system, which of the following file formats would be the best choice to use to ensure the client can open it?
Microsoft Access
Portable Document Format (PDF)
Microsoft Word
Microsoft Excel
Layout controls for forms and reports are the defined sets of colors, fonts, and graphics.
Which of the following statements is false?
Forms and reports both include controls, such as text boxes, that can be resized.
Reports are generally used for printing, emailing, or viewing data on the screen.
Forms are often used for inputting data.
Layout
You can either group or sort (but not both).
Which of the following statements is false?
You can either group or sort (but not both).
Sorting can be done on both forms and reports.
You can use grouping to show a list of properties by state.
Sorting can be done in ascending or descending order.