Access Video Quiz B1.2
By Richard Rost
11 hours ago
How Should Customer Orders Be Stored?
Which Microsoft Access object is primarily used to store the actual data in a database? Welcome to another Access Video Quiz. You will be asked five beginner-level questions covering tables, forms, reports, relational design, and storing names in separate fields. Answer each question, check your score, and see how well you know Microsoft Access.
Recommended Courses
Want More?
Keywords
Access Video Quiz, Access beginner quiz, database tables, one-to-many relationship, customer orders table, forms for data entry, reports for printing, first name last name fields, database normalization, primary key
Transcript It's time for another video quiz from Access Learning Zone.
Today's quiz is for beginner users.
I'll ask you five questions, give you a few seconds to think about each one, then reveal the answer. Keep track of your score. We'll see how you did at the end.
Are you ready? Here we go.
Which Microsoft Access Object is primarily used to store the actual data in the database? Is it a table, form, report, or query?
That's an easy one. That's a table.
Question two. A customer can place many orders. What is the usual relational database design?
Put order one, order two, and order three in fields on the customer table. Store each order as a separate record in an orders table. Create a separate customer table for each order. Or put all order details in one large notes field.
That's going to be B. Store each order as a separate record in an orders table.
Question three. Why is it often better to store first name and last name in separate fields?
A. Access requires all names to be split into two fields.
B. It makes sorting, filtering, and personalized letters easier.
C. It prevents two customers from having the same last name.
Or D. It automatically creates a primary key.
That's going to be B. It makes sorting, filtering, and personalized letters easier. You can say, "Dear Spock."
Question four. Which Access Object is generally best for entering and viewing data on the screen? Would that be a table, form, report, or relationship?
That's another easy one. That's a form. Remember, forms on the screen, reports to print out.
And question five. Which Access Object is generally designed for formatted printing, such as invoices or mailing labels?
And that's going to be C. Reports. I just told you that a second ago. Reports are for printouts, PDFs, all that kind of stuff.
All right, how'd you do? Did you get all five right? Did you become the doctor's favorite companion, or were you just stuck pressing every button on the TARDIS console, and you had no idea where you were going?
Well, if you missed any, these topics and a lot more are covered in my Access Beginner One Class Lesson Two, and it's absolutely free.
So thanks for playing. Post your score in the comments, and until next time, live long and prosper.Intro Which Microsoft Access object is primarily used to store the actual data in a database? Welcome to another Access Video Quiz. You will be asked five beginner-level questions covering tables, forms, reports, relational design, and storing names in separate fields. Answer each question, check your score, and see how well you know Microsoft Access.Quiz Q1. Which Microsoft Access object is primarily used to store the actual data in a database?
A. Table
B. Form
C. Report
D. Query
Q2. A customer can place many orders. What is the usual relational database design?
A. Put multiple order fields in the customer table
B. Store each order as a separate record in an orders table
C. Create a separate customer table for each order
D. Put all order details in one notes field
Q3. Why is it often better to store first name and last name in separate fields?
A. Access requires all names to be split into two fields
B. It makes sorting, filtering, and personalized letters easier
C. It prevents two customers from having the same last name
D. It automatically creates a primary key
Q4. Which Access object is generally best for entering and viewing data on the screen?
A. Table
B. Form
C. Report
D. Relationship
Q5. Which Access object is generally designed for formatted printing, such as invoices or mailing labels?
A. Table
B. Form
C. Report
D. Query
Answers: 1-A; 2-B; 3-B; 4-B; 5-C
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.Summary This beginner quiz from Access Learning Zone tests your knowledge of five basic Microsoft Access concepts. Keep track of your answers as you go, then compare your score at the end.
Question 1: Which Microsoft Access object is primarily used to store the actual data in a database?
Your choices are table, form, report, or query.
The correct answer is a table. Tables are where the records and fields that make up your database data are stored.
Question 2: A customer can place many orders. What is the usual relational database design?
You could place Order1, Order2, and Order3 fields in the Customer table, create a separate Customer table for every order, put all order information in one large Notes field, or store each order as a separate record in an Orders table.
The correct answer is to store each order as a separate record in an Orders table. This is the proper one-to-many relationship design. One customer may be associated with many order records, but each order record belongs to one customer.
Question 3: Why is it usually better to store first names and last names in separate fields?
The choices are that Access requires names to be split into two fields, it makes sorting, filtering, and personalized letters easier, it prevents duplicate last names, or it automatically creates a primary key.
The correct answer is that separate fields make sorting, filtering, and personalized letters easier. For example, if you have separate first-name fields, you can create a letter greeting such as "Dear Spock." You can also sort customers by last name, filter records by first name, and use either part of the name independently in queries, forms, and reports.
Question 4: Which Access object is generally best for entering and viewing data on the screen?
The choices are table, form, report, or relationship.
The correct answer is a form. Although you can enter data directly into a table, forms are designed to provide a user-friendly interface for viewing, editing, and adding records.
Question 5: Which Access object is generally designed for formatted printing, such as invoices or mailing labels?
The correct answer is a report. Reports are intended for printed output, print previews, PDFs, invoices, mailing labels, summaries, and other formatted documents.
If you got all five questions correct, excellent work. If you missed any, do not worry. These foundational concepts are covered in much more detail in my free Access Beginner 1 class, Lesson 2.
You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.Topic List Tables for storing database data
One-to-many customer and order relationships
Separate first and last name fields
Forms for entering and viewing data
Reports for formatted printingArticle This is a video quiz. No article needed.Primary Topics tables for data storage, one-to-many customer-order relationships, separate first and last name fields, forms for screen data entry, reports for formatted printingSecondary Topics sorting and filtering names, personalized letters, invoices, mailing labels, PDFs |
