Time for a quick Microsoft Access quiz. This one covers a few beginner-level report and label basics: choosing the right Access object, picking a report layout, previewing before printing, arranging label text, and filtering labels for active customers only. Grab a pencil, keep score if you like, and no peeking at the answers until you've made your picks.
Each question has one best answer. If you need more than a few seconds, pause the video. Access will not complain. It will just sit there quietly, judging you with its tiny little navigation buttons.
Question 1: A manager needs a neatly arranged customer directory to print as a handout. Which Access object is designed for this?
A. A table
B. A data entry form
C. A report
D. A query
Answer: C. A report. Tables store your data, forms are generally used for entering and editing it, and queries select or organize records. A report is the object designed to format information for printing or sharing. If you want a polished customer directory, invoice, mailing list, or similar document, reports are where you want to be.
Question 2: In the Report Wizard, which layout puts each customer on one row in a list?
A. Tabular
B. Columnar
C. Justified
D. Landscape
Answer: A. Tabular. A tabular report is the familiar list-style layout: one record per row, with fields arranged in columns. Think spreadsheet-style customer lists, except considerably more printable. "Landscape" is a page orientation, not a report layout, so that one is a classic distractor.
Question 3: Before printing a report, you want to check page breaks and margins. Which view should you use?
A. Report View
B. Layout View
C. Design View
D. Print Preview
Answer: D. Print Preview. Print Preview shows you what the finished pages will actually look like when printed, including page breaks, margins, headers, footers, and whether your report is going to spill one lonely field onto a second page. Check it before printing and save a few trees.
Question 4: In the Label Wizard, how do you put the full name on one line and the company name on the next?
A. Put each field on a separate line.
B. Put a space between the names, then press Enter before the company name.
C. Add a space between every field on one line.
D. Add the fields together and let the wizard insert separators.
Answer: B. In the label prototype, place a space between the first and last name fields so the name reads normally, then press Enter before inserting the company field. That gives you a label with the full name on one line and the company beneath it. The wizard follows the layout you build there, so line breaks matter.
Question 5: Your Customer table has an Is Active Yes/No field. How should you build mailing labels for active customers only?
A. Sort all customers by Is Active, then create the labels.
B. Leave Is Active off the prototype.
C. Base the labels on a query with Is Active set to True.
D. Base the labels on a query with Is Active set to False.
Answer: C. Create a query that returns only customers whose Is Active field is True, and use that query as the record source for your labels. Sorting does not remove inactive customers, and hiding the field from the label design does not stop those records from printing. The query does the filtering first, which is exactly what you want.
How did you do? If you got all five, congratulations, you have earned at least a virtual gold star. If you missed a few, no worries. These are the kinds of little Access details that become second nature once you start building reports and labels for real-world databases.
The embedded video includes the complete quiz, and these topics are covered in more detail in the free Access Beginner 1, Lesson 12 training on building customer reports and labels.
Live long and prosper,
RR
No comments:
Post a Comment