Access Video Quiz B1.12
By Richard Rost
13 hours ago
Which Report Layout Puts Customers on a Single Row
Which Access object is designed to print a neatly arranged customer directory? Welcome to another Microsoft Access Video Quiz. You will be asked five Beginner-level questions about reports, report layouts, Print Preview, mailing labels, and using queries to filter active customers. Answer each question, check your score, and see how well you know Microsoft Access.
Recommended Courses
Want More?
Keywords
Access Video Quiz, Access reports, Report Wizard tabular layout, Print Preview, Label Wizard, mailing labels, active customer labels, Yes No field query, customer directory report, report page breaks, report margins
More InformationTranscript It's time for another video quiz brought to you by Access Learning Zone.
This one's for beginners.
You'll have three seconds to answer each question, so hit that pause button if you need more time.
Keep track of your score. We'll see how you did at the end.
Now, quiet. I'm going to ask you a bunch of questions, and I want to have them answered immediately.
Question 1. Who is your daddy, and what does he do?
I'm just kidding. Great movie, though.
All right, for real.
Question 1. A manager needs a neatly arranged customer directory to print a handout. Which Access object is designed for this? A table, a data entry form, a report, or a query.
That's going to be a report.
Question 2. In the Report Wizard, which layout puts each customer on one row in a list? Tabular, columnar, justified, or landscape.
That's going to be tabular.
Question 3. Before printing a report, you want to check its page breaks and margins. Which view should you use? Report view, Layout view, Design view, or Print Preview.
That's going to be Print Preview. Save those trees.
Question 4. In the Label Wizard, how do you put the full name on one line and the company name on the next? Put each field on a separate line. Space between names, then enter before company name. Add a space between every field on one line, or add the field together and let the wizard insert separators.
That's B. Put a space between the names and then enter before company name.
Question 5. Your customer table has an Is Active Yes/No field. How should you build mailing labels for active customers only? Sort all customers by Is Active, then create the labels. Leave Is Active off the prototype. Base the labels on a query with Is Active set to True, or base the labels on a query with Is Active set to False.
That is C. Base the labels on a query with Is Active set to True.
All right, how'd you do? Did you get all five right? Did you earn the teacher's gold star, or did the hamster eat your lunch?
Well, if you missed any of these, these topics and more are covered in Access Beginner 1, Lesson 12, all about building customer reports, and it's absolutely free.
You'll find it on my website. I'll put a link down below.
Thanks for playing. Be sure to post your score down in the comments, and remember, the next time the teacher asks, "Who is your daddy, and what does he do?" you'll know how to put his name on a mailing label.
Until next time, live long and prosper. Intro Which Access object is designed to print a neatly arranged customer directory? Welcome to another Microsoft Access Video Quiz. You will be asked five Beginner-level questions about reports, report layouts, Print Preview, mailing labels, and using queries to filter active customers. Answer each question, check your score, and see how well you know Microsoft Access. |
