Access Video Quiz X1.4
By Richard Rost

5 days ago

What Should Combo Box Store for Related Records?

S M L XL FS | Slo Reg Fast 2x | Bookmark | Autoplay: ON

What should normally be stored in a contact record when a combo box selects a related customer? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions covering primary keys, relational combo boxes, hidden key columns, query row sources, and invalid control source errors. Answer each question, check your score, and see how well you know Microsoft Access.

Recommended Courses

Access Expert 1, Lesson 4

Want More?

Access Video Quizzes

Keywords

Access Video Quiz, relational combo boxes, foreign key storage, combo box bound column, hidden key column, combo box row source query, primary key field, invalid control source error, bound form controls, form record source, calculated combo box fields

Comments for Access Video Quiz X1.4

Age	Subject	From
16 days	Post Your Quiz Score Here!	Richard Rost

More Information

Transcript

Welcome to another video quiz from Access Learning Zone.

Today's quiz is for expert-level users.

Going to be five questions coming at you fast. If you need more time, hit that pause button. Keep track of your score. You ready? Here we go.

Question 1.

When a combo box is used to select a related customer for a contact, what should normally be stored in the contact record? The customer's primary key value, the customer's full name as text, a copy of all customer fields, or the position of the customer in the list.

That's going to be the customer's primary key value.

Question 2.

What's the main job of a primary key field at an Access table? It formats text consistently, it uniquely identifies each record, it automatically sorts every query, or it hides duplicate records.

That's an easy one. It uniquely identifies each record.

Question 3.

What happens when the key column in a related combo box is hidden? Access cannot store the selected value, the key is deleted from the source table, the key is not displayed, but it can still be stored, or the combo box becomes read-only.

That is C. The key is not displayed, but it can still be stored, and the next column is the displayed column.

Question 4.

Why might you use a query as the row source for a combo box instead of using a table directly? To display calculated or combined fields in the list, to turn the combo box into a report, to prevent users from selecting records, or to remove the need for relationships.

That's A, display calculated or combined fields in the list.

Question 5.

What does an invalid control source error on a bound form control usually mean? The form has too many records, the control refers to a field not available in the form's record source, the table's primary key is hidden, or the form needs to be converted to a report.

That is B. The control refers to a field not available in the form's record source.

How'd you do?

Did you get all 5?

Did you reboot Windows without losing Solitaire?

Or did you double-click on My Computer and get nervous?

If you missed any of these topics, a lot more are covered in Access Expert Level 1 Lesson 4 on relational combo boxes.

Thanks for playing. Post your score down below, and until next time, live long and prosper.

Thanks for watching.

Intro

Quiz

Q1. When a combo box is used to select a related customer for a contact, what should normally be stored in the contact record?
A. The customer's primary key value
B. The customer's full name as text
C. A copy of all customer fields
D. The customer's position in the combo box list

Q2. What is the main purpose of a primary key field in an Access table?
A. It formats text consistently
B. It uniquely identifies each record
C. It automatically sorts every query
D. It hides duplicate records

Q3. What happens when the key column in a related combo box is hidden?
A. Access cannot store the selected value
B. The key is deleted from the source table
C. The key is not displayed, but it can still be stored
D. The combo box becomes read-only

Q4. Why might you use a query as the row source for a combo box instead of using a table directly?
A. To display calculated or combined fields in the list
B. To turn the combo box into a report
C. To prevent users from selecting records
D. To remove the need for relationships

Q5. What does an invalid control source error on a bound form control usually mean?
A. The form has too many records
B. The control refers to a field not available in the form's record source
C. The table's primary key is hidden
D. The form needs to be converted to a report

Answers: 1-A; 2-B; 3-C; 4-A; 5-B

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

In today's Video Quiz, I have five expert-level Microsoft Access questions for you. Keep track of your score as you go.

Question 1: When you use a combo box to select a related customer for a contact, what value should normally be saved in the contact record?

The correct answer is the customer's primary key value. In a properly designed relational database, the contact record stores the CustomerID, or whatever primary key field identifies the customer. You do not normally store the customer's full name, duplicate all of the customer information, or save the customer's position in the combo box list.

Question 2: What is the primary purpose of a primary key field in an Access table?

A primary key uniquely identifies each record in the table. No two records should have the same primary key value. A primary key does not format text, automatically sort every query, or hide duplicates.

Question 3: What happens when the key column in a related combo box is hidden?

The key is not displayed to the user, but it can still be stored in the underlying record. For example, a combo box may store the CustomerID while displaying the customer's name. Hiding the key column is common because users usually need to see meaningful information, such as a name or company, instead of an internal numeric ID.

Question 4: Why might you use a query as the row source for a combo box instead of selecting a table directly?

A query lets you display calculated fields or combine information from multiple related tables. For example, you could build a combo box list that displays a customer's full name by combining first name and last name fields, or show information from both a customer table and another related table. Using a query as the row source does not turn the combo box into a report, prevent selections, or eliminate the need for relationships.

Question 5: What does an invalid control source error on a bound form control usually mean?

It usually means the control refers to a field that is not available in the form's record source. The field may not exist in the table or query that the form is based on, or the field name may have been changed or misspelled. This error does not mean the form has too many records, the primary key is hidden, or that the form needs to be converted into a report.

These concepts are covered in more detail in Access Expert Level 1 Lesson 4, which focuses on relational combo boxes.

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

Storing primary keys with related combo boxes
Primary key fields and record identification
Hidden combo box columns and stored values
Using queries as combo box row sources
Fixing invalid control source errors

Article

This is a video quiz. No article needed.

Primary Topics

relational combo boxes, foreign key storage, primary keys, hidden combo box columns, combo box row sources, bound form controls

Secondary Topics

customer-contact relationships, calculated query fields, form record sources