Access Chapter 4

Question 1

Form

Answer 1

A database object that is used to add data into or edit data in a table.

Question 2

Form Tool

Answer 2

Used to create data entry forms for customers, employees, products, and other primary tables.

Question 3

Record Source

Answer 3

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

Question 4

Stacked Layout

Answer 4

Displays fields in a vertical column.

Question 5

Tabular Layout

Answer 5

Displays data horizontally.

Question 6

Controls

Answer 6

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

Question 7

Layout Control

Answer 7

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

Question 8

Form View

Answer 8

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

Question 9

Layout View

Answer 9

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

Question 10

Design View

Answer 10

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

Question 11

Split Form

Answer 11

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.

Question 12

Multiple Items Form

Answer 12

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

Question 13

Theme

Answer 13

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

Question 14

Report

Answer 14

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

Question 15

Report Tool

Answer 15

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

Question 16

Report Wizard

Answer 16

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

Question 17

Label Wizard

Answer 17

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

Question 18

Report View

Answer 18

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

Question 19

Print Preview

Answer 19

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

Question 20

Portable Document Format (PDF)

Answer 20

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

Question 21

The table or query that supplies the records for a form or report is also known as the

Answer 21

Record Source.

Question 22

Which of the following statements is false?

Answer 22

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

Question 23

Which of the following statements is true?

Answer 23

• Both forms and reports can use tabular and stacked layouts
• A stacked layout displays data in a vertical column.
• A tabular layout displays data horizontally.

Question 24

Which of the following is not an example of a control?

Answer 24

A report.

Question 25

Which of the following is an example of a control?

Answer 25

• A text box on a form.
• Buttons on a report.
• A box on a report.

Question 26

The simplest interface you can use to modify control widths in a form is in

Answer 26

Layout view

Question 27

Which of the following views is the most powerful, but also the most complicated?

Answer 27

Design View

Question 28

Which of the following statements about reports are false?

Answer 28

Reports are primarily used to modify data.

Question 29

Which of the following statements about reports are true?

Answer 29

• Reports can be saved to a file on your computer.
• Reports can produce output in a number of ways, including mailing labels.
• Reports can be created simply using the Report tool.

Question 30

Use the __________ to see exactly what the printed report will look like before printing.

Answer 30

Print Preview

Question 31

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?

Answer 31

Portable Document Format (PDF)

Question 32

Which of the following statements is false?

Answer 32

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

Question 33

Which of the following statements is true?

Answer 33

• Reports are generally used for printing, emailing, or viewing data on the screen.
• Forms are often used for inputting data.
• Forms and reports both include controls, such as text boxes, that can be resized.

Question 34

Which of the following statements is false?

Answer 34

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

Question 35

Which of the following statements is true?

Answer 35

• You can use grouping to show a list of properties by state.
• Sorting can be done on both forms and reports.
• Sorting can be done in ascending or descending order.