30 terms

Access Chapter 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 primary 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 data horizontally.
Tabular layout
The text boxes, buttons, boxes, and other tools 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 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 on the form or report.
Layout view
Enables you to change advanced design settings you cannot see in the Layout view, such as a background image.
Design view
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 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 document that displays information from a database in a format 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
Asks you questions 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 see 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)
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.
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.
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 simplest interface you can use to modify control widths in a form is in:

Layout view.

Design view.

Report view.

Form view.
Layout 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.
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.
Use the ____________ to see exactly what the printed report will look like before printing.

Report Wizard

Report tool

Report view

Print Preview
Print Preview
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)
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.
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).