Access Video Quiz A4.2
By Richard Rost
5 hours ago
Records Controlling Report Detail Section Printing What primarily determines how many times a report's detail section prints? Welcome to another Microsoft Access Video Quiz. You will be asked five advanced-level questions about Access reports, including report record sources, references to open form controls, full-sheet label reports, and repeated label values. Answer each question, check your score, and see how well you know Microsoft Access. Recommended CoursesWant More?KeywordsAccess Video Quiz, Access report detail section, report record source, report control expressions, Forms! form references, label report 30 records, full sheet mailing labels, repeating form values in reports, report text box control source
More InformationTranscript Welcome to another video quiz from Access Learning Zone.
This one's for advanced users, with five questions covering Access reports. You'll have three seconds to answer each question, so use that pause button if you need more time.
Keep track of your score so we can see how you did at the end. Ready to make it through the wormhole? Here we go.
Question 1.
What primarily determines how many times a report's detail section prints?
The number of text boxes in the detail section, the number of records returned by the report's record source, the number of pages selected in Print Preview, or the number of controls on the form that opened it.
That's going to be the number of records returned by the report's record source.
Question 2.
A report control uses an expression that refers to a control on an open form. What must be true when the report runs?
The report must remain open so Access can evaluate the reference, the form must be saved as a report first, the report and form must use the same record source, or the referenced form control must be unbound.
That is A: the form must remain open so Access can evaluate the reference.
Question 3.
Why might a label report use a small table containing exactly 30 otherwise meaningless records?
To permanently store each customer's mailing address, to make Access automatically create 30 new customers, to supply 30 detail section records for one full sheet, or to force the report to use landscape orientation.
That is C: to supply 30 detail section records for one full sheet.
Question 4.
Which control source expression correctly displays the first name control from an open form named customer F in a report text box?
There are your four options. Select one now.
And the correct answer is C: =Forms!CustomerF!FirstName.
And question 5.
A full-sheet label report repeats values from the current customer form 30 times. Why is it a poor choice when three labels need different text?
Reports cannot contain calculated controls, changing the form value changes every repeated label that reads it, Access reports can print only one copy of each record, or a report cannot use a table with 30 records.
And that is B: changing the form value changes every repeated label that reads it.
All right, how'd you do? Did you get all five right? Did you broker peace with the Dominion? Or did you ask which way to Quark's and get shown the airlock?
Well, if you missed any, all of these topics and more are covered in Microsoft Access Advanced Level 4, where we learn how to print full sheets of mailing labels.
Thanks for playing. Post your score in the comments down below, and let us know. Did you run the station like Sisko or get detained by Odo?
And until next time, live long and prosper. Intro What primarily determines how many times a report's detail section prints? Welcome to another Microsoft Access Video Quiz. You will be asked five advanced-level questions about Access reports, including report record sources, references to open form controls, full-sheet label reports, and repeated label values. Answer each question, check your score, and see how well you know Microsoft Access.
|