Access Video Quiz B1.5
By Richard Rost

8 hours ago

Explain What Primary Key Does in Database Tables?

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

Which data type is usually best for storing a phone number in an Access table? Welcome to another Microsoft Access Video Quiz. You will be asked five Beginner-level questions covering data types, number field sizes, AutoNumber fields, primary keys, and indexes. Answer each question, check your score, and see how well you know Microsoft Access.

Recommended Courses

Access Beginner 1, Lesson 5

Want More?

Access Video Quizzes

Keywords

Access Video Quiz, Access data types, phone number field, short text field, number field size, double data type, AutoNumber field, primary key, table indexing, faster searches and sorts, customer table

Comments for Access Video Quiz B1.5

Age	Subject	From
17 hours	Post Your Quiz Score Here!	Richard Rost

More Information

Transcript

Guess what time it is? It's time for another video quiz from Access Learning Zone.

This quiz is for the beginners. I'm going to give you five questions. They're going to come at you real fast. So if you need to pause, hit the pause button. Keep track of your score. We'll see how you did at the end. Are you ready? Here we go.

Question 1. Which data type is usually best for storing a phone number in an Access table? Short text, number, currency, or date/time?

That's going to be short text. Remember my rule. If you're not calculating it, use text. You're not going to take the sum of a bunch of phone numbers.

Question 2. Which number field size is generally appropriate for a value that can contain decimal places, such as a discount rate? Byte, integer, long integer, or double?

Of those choices, that's going to be double. There is a decimal type. I don't like using it, except for really advanced stuff, so stick to double.

Question 3. What's the main purpose of an AutoNumber field in a typical Access table? To calculate totals automatically, to assign a unique value to each record, to display numbers with commas, or to store a customer's account balance.

An AutoNumber is to assign a unique value to each record.

Question 4. What does a primary key do in an Access table? Uniquely identifies each record, sorts every field alphabetically, prevents users from editing records, or stores the table's description.

Again, a primary key is to uniquely identify each record, and usually your primary key is an AutoNumber.

Question 5. Why might you create an index on a field in an Access table? To make searches and sorts faster, to automatically create a form, to convert text into numbers, or to make the field required.

One of the benefits of indexing is it makes searches and sorting faster.

All right, how'd you do? Did you get all five right? Did you unveil a lightning-powered engine at the Royal Society? Or is your prototype still making encouraging whistling noises?

If you missed any, these topics and a lot more are covered in Access Beginner Level 1, Lesson 5, on building the customer table.

As always, thanks for playing. Be sure to post your score down below in the comments, and until next time, live long and prosper.

Intro

Quiz

Q1. Which data type is usually best for storing a phone number in an Access table?
A. Short Text
B. Number
C. Currency
D. Date/Time

Q2. Which number field size is generally appropriate for a value that can contain decimal places, such as a discount rate?
A. Byte
B. Integer
C. Long Integer
D. Double

Q3. What is the main purpose of an AutoNumber field in an Access table?
A. To calculate totals automatically
B. To assign a unique value to each record
C. To display numbers with commas
D. To store a customer's account balance

Q4. What does a primary key do in an Access table?
A. Uniquely identifies each record
B. Sorts every field alphabetically
C. Prevents users from editing records
D. Stores the table's description

Q5. Why might you create an index on a field in an Access table?
A. To make searches and sorts faster
B. To automatically create a form
C. To convert text into numbers
D. To make the field required

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

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 beginner-level questions about Microsoft Access table design. Keep track of your answers as you go, then compare your score with the correct answers at the end.

Question 1: Which data type is usually best for storing a phone number in an Access table? Your choices are Short Text, Number, Currency, or Date/Time.

The correct answer is Short Text. Phone numbers may contain parentheses, hyphens, spaces, extensions, or even a leading plus sign for international numbers. More importantly, you do not perform mathematical calculations with phone numbers. As a general rule, if you are not going to calculate with a value, it should usually be stored as text.

Question 2: Which Number field size is generally appropriate for a value that may contain decimal places, such as a discount rate? The choices are Byte, Integer, Long Integer, or Double.

The answer is Double. Byte, Integer, and Long Integer are intended for whole numbers. A Double field can store values with decimal places. Access also has a Decimal type, but I generally recommend using Double unless you have a more advanced reason to use Decimal.

Question 3: What is the primary purpose of an AutoNumber field in a typical Access table? The choices are calculating totals automatically, assigning a unique value to each record, displaying numbers with commas, or storing a customer's account balance.

The correct answer is assigning a unique value to each record. AutoNumber fields automatically generate a new value whenever a new record is created. This makes them ideal for identifying records individually.

Question 4: What does a primary key do in an Access table? The choices are uniquely identifying each record, sorting every field alphabetically, preventing users from editing records, or storing the table description.

The answer is that a primary key uniquely identifies each record in the table. In many Access tables, the primary key is an AutoNumber field because Access can generate a distinct value for every record automatically.

Question 5: Why might you create an index on a field in an Access table? The choices are making searches and sorts faster, automatically creating a form, converting text to numbers, or making a field required.

The correct answer is making searches and sorts faster. Indexes can improve performance when you frequently search, filter, sort, or join records based on a particular field.

If you got all five correct, excellent work. If you missed one or more questions, these topics are covered in Access Beginner Level 1, Lesson 5, where I teach you how to build a customer table.

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

Choosing data types for Access table fields
Storing phone numbers as short text
Using double fields for decimal values
Using AutoNumber fields for unique records
Using primary keys to identify records
Using indexes to speed up searches and sorting

Article

This is a video quiz. No article needed.

Primary Topics

Access data types, phone number storage, numeric field sizes, decimal values, AutoNumber fields, primary keys, table indexes

Secondary Topics

customer table design, discount rates, search performance, sort performance