Access Video Quiz B1.4
By Richard Rost

22 hours ago

Best Data Type for Customer ZIP Codes?

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

What data type is usually best for a ZIP code when you will not perform math with it? Welcome to another Microsoft Access Video Quiz. You will be asked five Beginner-level questions covering table fields, field names, data types, AutoNumber fields, and date/time values. Answer each question, check your score, and see how well you know Microsoft Access.

Recommended Courses

Access Beginner 1, Lesson 4

Want More?

Access Video Quizzes

Keywords

Access Video Quiz, Access beginner quiz, table field name and data type, short text field, ZIP code as text, AutoNumber unique identifier, date time field, customer table design, currency data type

Comments for Access Video Quiz B1.4

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

More Information

Transcript

It's time for another video quiz from Access Learning Zone.

Today's quiz is for beginner-level users. Gonna give you five questions, and they're gonna come pretty fast. So hit that pause button if you need more time. Keep track of your score. You ready? Here we go.

Question 1. When defining a field in an Access table, which two pieces of information are essential? The field name and data type, the table name and report style, the form caption and record source, or the query name and sort order.

That's gonna be A: the field name and the data type.

Question 2. Which Access data type is generally best for a customer's first name? Long text, short text, currency, or date/time?

That's gonna be B, short text.

Question 3. What data type is usually best for a ZIP code when you will not perform math with it? Short text, long integer, double, or currency?

That's gonna be short text. If you're not doing math with it, store it as text.

Question 4. What's the main purpose of an AutoNumber field in an Access table? Store a unique identifier for each record, calculate totals automatically, format values as currency, or create a list of choices for users.

That's gonna be to store a unique identifier for each record.

Question 5. What can an Access date/time field store? Only a calendar date, only a clock time, a date, a time, or both, text that looks like a date.

A date/time field can hold a date, a time, or both. You put it all in the same field.

All right, how'd you do? Did you get all five right? Are you a supreme commander of the paperclip empire? Or are you still searching for the any key?

If you missed any, these topics and a lot more are covered in my Access Beginner Level 1 class, Lesson 4, which is all about creating the customer table.

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

Intro

Quiz

Q1. When defining a field in an Access table, which two pieces of information are essential?
A. The field name and data type
B. The table name and report style
C. The form caption and record source
D. The query name and sort order

Q2. Which Access data type is generally best for a customer's first name?
A. Long Text
B. Short Text
C. Currency
D. Date/Time

Q3. What data type is usually best for a ZIP code when you will not perform math with it?
A. Short Text
B. Long Integer
C. Double
D. Currency

Q4. What is the main purpose of an AutoNumber field in an Access table?
A. Store a unique identifier for each record
B. Calculate totals automatically
C. Format values as currency
D. Create a list of choices for users

Q5. What can an Access Date/Time field store?
A. Only a calendar date
B. Only a clock time
C. A date, a time, or both
D. Text that looks like a date

Answers: 1-A; 2-B; 3-A; 4-A; 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

In today's Video Quiz, I have five beginner-level Microsoft Access questions for you. Keep track of your answers as you go, and pause whenever you need extra time to think.

Question 1: When you define a field in an Access table, what two pieces of information are essential?

The correct answer is the field name and the data type. Every field needs a name so you know what information it contains, such as FirstName or CustomerID. It also needs a data type so Access knows how that information should be stored, such as Short Text, Number, Currency, or Date/Time.

Question 2: Which Access data type is generally best for a customer's first name?

The correct answer is Short Text. A first name contains letters and may also include spaces, hyphens, or apostrophes. Since it is not a value you will use in calculations, Short Text is the appropriate choice.

Question 3: What data type is usually best for a ZIP code if you will not perform math with it?

The correct answer is Short Text. Although ZIP codes often consist of digits, they are identifiers rather than quantities. You do not add, subtract, multiply, or divide ZIP codes. Storing them as Short Text also preserves leading zeroes, which are important for many ZIP codes.

Question 4: What is the main purpose of an AutoNumber field in an Access table?

The correct answer is to store a unique identifier for each record. Access automatically assigns a different number to each new record. This is commonly used for a primary key field, such as CustomerID, so that every customer record can be uniquely identified.

Question 5: What can an Access Date/Time field store?

The correct answer is a date, a time, or both. A Date/Time field can contain just a calendar date, just a time of day, or a complete date and time together. It is not merely text that happens to look like a date.

If you got all five questions right, you are well on your way to becoming a supreme commander of the paperclip empire. If you missed a few, that is perfectly fine. These concepts are covered in my Access Beginner Level 1 class, Lesson 4, where I teach you how to create the 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

Access table field names and data types
Short Text fields for customer names
Short Text fields for ZIP codes
AutoNumber fields as unique record identifiers
Date/Time fields for dates and times

Article

This is a video quiz. No article needed.

Primary Topics

field names and data types, short text fields, ZIP code storage, AutoNumber identifiers, date/time fields

Secondary Topics

customer table design, customer first name field