Question 1

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

Accepted Answer

The answer of A(n) ____________________ is a database object that...

Question 2

FIGURE AC 5-1  Referring to the figure above, in this report, ____ appear in controls.
A) the Teacher ID label
B) the records shown below the Teacher ID label
C) both a. and b.
D) neither a. nor b.

Accepted Answer

Both the Teacher ID label and the records shown below the Teacher ID label appear in controls in the report. Controls are used to display data or labels on a report, and both the label and the records are displayed using controls.

Question 3

Another way to resize a report is to use the report ____, which appears in the upper-left corner of the report, where the horizontal and vertical rulers intersect.
A) editor
B) generator
C) selector
D) creator

Accepted Answer

The report selector is a tool used to select an entire report or a section of a report to be resized. It appears in the upper-left corner of the report where the horizontal and vertical rulers intersect. The other options (editor, generator, creator) do not specifically refer to a tool for resizing a report.

Question 4

You can remove a control from a control layout in a report just like you can for a form. Display the report in ____ view, click the control to select it, right-click the control to open the shortcut menu, point to Layout, and then click Remove Layout.
A) Format
B) Layout
C) Design
D) Data

Accepted Answer

In Layout view, you can manipulate the layout of the controls on the report. To remove a control from the layout, you can follow the steps provided in option B. The other options (A, C, and D) are not relevant to removing controls from a report layout.

Question 5

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie realizes he needs to change the width of the report. When resizing a control in ____ view, Eddie uses the outline of the control and drags it with the pointer to see the actual width of the control.
A) Design
B) Layout
C) Report
D) Print Preview

Accepted Answer

Eddie needs to resize the control, which is done in Layout view. When resizing a control in Layout view, Eddie can use the outline of the control and drag it to see the actual width. Therefore, the best choice is B) Layout.

Question 6

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.
A) control icon
B) section bar
C) upper edge
D) lower edge

Accepted Answer

In a report, you can select a section by clicking its section bar, which is located at the top of the section. The other options listed are not the correct way to select a section in a report.

Question 7

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.
A) blank lines
B) blank pages
C) a line of pound signs
D) a page of pound signs

Accepted Answer

If there are blank pages appearing in the report, it means that the report's width is not properly adjusted and needs to be adjusted to eliminate those blank pages. Blank lines or a line of pound signs do not necessarily indicate the need for width adjustment. A page of pound signs may indicate that the report data does not fit within the available space and may require other formatting changes.

Question 8

You can add a(n) _____ to a report.
A) clip-art image
B) graphic you created using another program
C) digital image
D) all of the above

Accepted Answer

All of the above options (A, B, and C) are valid choices for adding an image to a report.

Question 9

To change the style of a selected line, click the ____ Outline button, point to Line Type, and then click one of the line styles.
A) Symbol
B) Character
C) Shape
D) Line

Accepted Answer

To change the style of a selected line in many graphic or presentation software applications, you typically use the "Shape" options. This is because lines are considered a type of shape, and the controls for modifying their appearance are often found under the Shape or similar sections, where you can adjust aspects like line type, thickness, and style.

Question 10

FIGURE AC 5-1  In the header of the report shown above, the date of January 29, 2013 is listed. This is the ____.
A) date the report was first viewed
B) date the report was created
C) current date
D) default date for computer system

Accepted Answer

The date listed in the header of the report is most likely the date the report was created. It is unlikely that it is the date the report was first viewed or the current date, and it is not a default date for the computer system.

Question 11

Just like when used in forms, you can add text to a report by adding it in the ____ control.
A) text
B) address
C) comment
D) label

Accepted Answer

In reports, text can be added using the Label control. This control can be used to display information that does not change, such as column headers or titles.

Question 12

Point to a button in the Controls group to display its name in a ____.
A) dialog box
B) menu
C) status bar
D) ScreenTip

Accepted Answer

ScreenTips appear when the user hovers or pauses the mouse pointer over a button or control, and it displays the name of the control. This makes it a quick and easy way for users to identify the various controls available in the Controls group without having to click on them.

Question 13

To insert a line, click the Line button in the Controls group on the ____ tab. Move the pointer to the report, click the plus sign in the pointer where you want the line to begin, and then drag the pointer to the location where you want the line to end.
A) Design
B) Data
C) Format
D) Layout

Accepted Answer

The Line button is located in the Controls group on the Design tab. Moving the pointer to the report and clicking where you want the line to begin and dragging it to where you want it to end will insert the line.

Question 14

The layout options for reports do NOT include ____.
A) Stepped
B) Block
C) Outline
D) Stacked

Accepted Answer

All of the other options (stepped, block, and outline) are valid layout options for reports. However, stacked is not a recognized layout option.

Question 15

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. The first thing Monica does is to double-click First Name in the Available fields box. The First Name field is added to the Prototype label section. If the First Name field is enclosed in curly brackets, what does this mean?
A) This is how Access indicates a field name used in a label
B) This is how Access indicates an error in spacing
C) This is how Access indicates a data entry error
D) None of the above

Accepted Answer

Curly brackets indicate that the text within them is a field name. This is how Access identifies a field used in a label.

Question 16

Click a control to select it, and then use the options in the Text Formatting group on the ____ tab to change the text's font, size, and style.
A) Format
B) Layout
C) Home
D) Data

Accepted Answer

The Text Formatting group is typically found on the Home tab in Microsoft Office applications, including Word, Excel, and PowerPoint. The Format, Layout, and Data tabs may exist in some of these applications, but they are typically not relevant for changing text formatting.

Question 17

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?
A) insert a semi-colon
B) press the spacebar
C) press the tab key
D) insert a comma

Accepted Answer

Monica should press the spacebar to insert a space between the first and last name before double-clicking the Last Name in the Available fields box.

Question 18

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.
A) Format
B) Layout
C) Design
D) Data

Accepted Answer

The correct answer is C) Design. The Add Existing Fields button is located in the Tools group on the Design tab, which is used to manage fields and their properties in Layout view in applications like Microsoft Access.

Question 19

To add a picture to a report, click the Insert ____ button in the Controls group on the Design tab.
A) Picture
B) Logo
C) Brand
D) Image

Accepted Answer

The answer of To add a picture to a report,...

Question 20

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.
A) on the status bar
B) in the Quick Access Toolbar
C) in the Window footer
D) in the right-hand navigation pane

Accepted Answer

The width of a control in characters appears on the status bar when the control is selected or in design mode. The size of the control can be adjusted using the sizing handles on the edges of the control.

Quiz 5: Access Lesson 5: Creating and Modifying Reports

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

FIGURE AC 5-1 Referring to the figure above, in this report, ____ appear in controls.

Another way to resize a report is to use the report ____, which appears in the upper-left corner of the report, where the horizontal and vertical rulers intersect.

You can remove a control from a control layout in a report just like you can for a form. Display the report in ____ view, click the control to select it, right-click the control to open the shortcut menu, point to Layout, and then click Remove Layout.

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.

You can add a(n) _____ to a report.

To change the style of a selected line, click the ____ Outline button, point to Line Type, and then click one of the line styles.

FIGURE AC 5-1 In the header of the report shown above, the date of January 29, 2013 is listed. This is the ____.

Just like when used in forms, you can add text to a report by adding it in the ____ control.

Point to a button in the Controls group to display its name in a ____.

To insert a line, click the Line button in the Controls group on the ____ tab. Move the pointer to the report, click the plus sign in the pointer where you want the line to begin, and then drag the pointer to the location where you want the line to end.

The layout options for reports do NOT include ____.

Click a control to select it, and then use the options in the Text Formatting group on the ____ tab to change the text's font, size, and style.

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.

To add a picture to a report, click the Insert ____ button in the Controls group on the Design tab.

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.