Access Chapter 4 Flashcards
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 specified 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 dockers independent of software applications and operating system environment.
The table or query that supplies the records for a form or report is also known as the
Record Source.
Which of the following statements is false?
Stacked layouts are more common for reports because they will use less paper when printed.
Which of the following statements is true?
- 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.
Which of the following is not an example of a control?
A report.
Which of the following is an example of a control?
- A text box on a form.
- Buttons on a report.
- A box on a report.
The simplest interface you can use to modify control widths in a form is in
Layout view
Which of the following views is the most powerful, but also the most complicated?
Design View
Which of the following statements about reports are false?
Reports are primarily used to modify data.
Which of the following statements about reports are true?
- 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.
Use the __________ to see exactly what the printed report will look like before printing.
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?
Portable Document Format (PDF)
Which of the following statements is false?
Layout controls for forms and reports are the defined sets of colors, fonts, and graphics.
Which of the following statements is true?
- 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.
Which of the following statements is false?
You can either group or sort (but not both).
Which of the following statements is true?
- 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.
