Microsoft Access

Computing

Quiz 7 :

Creating Custom Reports

Quiz 7 :

Creating Custom Reports

Question Type
search
arrow
What is the function and syntax to print the current date in a report
Free
Essay
Answer:

Answer:

Date can be added in a report by using the function date().
The format of the Date function is =Date().
In the syntax, = indicates that it is an expression; Date is the name of the function.
To add the date to a report, in DESIGN tab and in Header/Footer group, click the Date and Time button.

Tags
Choose question tag
close menu
arrow
How do you insert a page number in the Page Header section
Free
Essay
Answer:

Answer:

Following are the steps to add page number to the Page Header Section:
• In the Report Header section, drag the bottom border up to the top of the section.
• Click the Design Tab, and then in the header or footer option, click the Page Number button, which opens the Page Numbers dialog box.
• Select the Page N option button in the Format section.
• Select the Top of Page option button in the Position section.
• Set the Show Number on First Page check box to on.

Tags
Choose question tag
close menu
arrow
The img property, when set to Yes, expands a text box vertically to fit the field value when a report is printed, previewed, or viewed in Layout and Report views.
Free
Essay
Answer:

Answer:

Can grow property
• Can grow property is a property that controls the way the control or section in a form or report is displayed when viewed, printed or previewed.
• By setting this property to yes, the control or section will be expanded to fit the data within the control or section
Therefore, the appropriate word to fill in the blank is can grow.

Tags
Choose question tag
close menu
arrow
Clicking the Title button in the Header/Footer group on the DESIGN tab adds a report title to the img section.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is a multiple-column report
Essay
Answer:
Tags
Choose question tag
close menu
arrow
List and describe the seven sections of an Access report.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
img section appears by itself at the top of a page, and the detail lines for the section appear on the previous page.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
You can view a report in Report view. What other actions can you perform in Report view
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Why might you want to hide duplicate values in a report
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is a custom report
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is a grouping field
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is a detail report A summary report
Essay
Answer:
Tags
Choose question tag
close menu
arrow
The img property prints a group header on a page only if there is enough room on the page to print the first detail record for the group; otherwise, the group header prints at the top of the next page.
Essay
Answer:
Tags
Choose question tag
close menu