Access Chapter 4

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

A report

The text boxes, buttons, boxes, and other tools you use to add, edit, and display the data in a form or report.

Controls

Enables you to change advanced design settings you cannot see in the Layout view, such as a background image.

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.

Design view.

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 primary tables.

Form tool

A simplified interface primarily used for data entry; does not allow you to make changes to the layout.

Form view

Enables you to easily create mailing labels, name tags, and other specialized tags.

Label Wizard

Provides guides to help keep controls aligned horizontally and vertically and give your form a uniform appearance.

Layout control

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 controls for forms and reports are the defined sets of colors, fonts, and graphics.

Layout controls for forms and reports are the defined sets of colors, fonts, and graphics.

Enables users to make changes to a layout while viewing the data on the form or report.

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.

Layout view.

Displays multiple records in a tabular layout similar to a table's Datasheet view, with more customization options.

Multiple Items form

A file type that was created for exchanging documents independent of software applications and operating system environment.

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

Portable Document Format (PDF)

Enables you to see exactly what the report will look like when it is printed.

Print Preview

Use the ____________ to see exactly what the printed report will look like before printing. Report Wizard Report tool Report view Print Preview

Print Preview

The table or query that supplies the records for a form or report is also known as the: Theme. Control. Tabular Layout. Record Source.

Record Source.

The table or query that supplies the records for a form or report.

Record source

A document that displays information from a database in a format that outputs meaningful information to its readers.

Report

Asks you questions and then uses your answers to generate a customized report.

Report Wizard

Used to instantly create a tabular report based on the table or query currently selected.

Report tool

Enables you to see what a printed report will look like in a continuous page layout.

Report view

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 file on your computer.

Reports are primarily used to modify data.

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.

Split form

Displays fields in a vertical column.

Stacked layout

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 layout displays data in a vertical column.

Stacked layouts are more common for reports because they will use less paper when printed.

Displays data horizontally.

Tabular layout

A defined set of colors, fonts, and graphics that can be applied to a form or report.

Theme

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.

You can either group or sort (but not both).