Question 1

A field's ____________________ determines the kind of data that you can enter in the field, such as numbers or text.

Accepted Answer

The answer of A field's ____________________ determines the kind of...

Question 2

Match between columns
                        Premises: Used to indicate the end of a label name

Accepted Answer

The Answer of syntax and label and comment and variable is...

Question 3

The ____ property specifies whether you must enter a field value in a record.
A) Needed
B) Necessary
C) Mandatory
D) Required

Accepted Answer

The "Required" property specifies whether a field value must be entered in a record in database management systems.

Question 4

When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the table's ____________________.

Accepted Answer

The answer of When you create a blank database, the...

Question 5

Case AC 2-2 Jennifer is creating a new inventory management table for the pet store where she works. She is spending the time upfront to make sure the data types are all assigned correctly. Jennifer's boss asks her if they can include detailed descriptions of each item in the database. The descriptions would be approximately 5000 characters. For this field she assigns the ____ data type.
A) Text
B) Memo
C) AutoNumber
D) Description

Accepted Answer

The Memo data type is designed to store large amounts of text, up to 65,536 characters. Therefore, it would be the appropriate choice for a field with a description of approximately 5000 characters. The Text data type is limited to 255 characters, so it would not be suitable for this field. AutoNumber is a data type used to automatically generate unique numbers, and Description is not a valid data type in Microsoft Access.

Question 6

When you enter a default value for a Text field, Access adds ____ around the field value.
A) quotation marks
B) parentheses
C) either a. or b.
D) neither a. nor b.

Accepted Answer

Access adds quotation marks around the default value for a Text field.

Question 7

What does the Field Size property do? What is the default field value for Text fields, and why would you want to change it? What is the default field value for Number fields, and why would you want to change it?

Accepted Answer

The answer of What does the Field Size property do?...

Question 8

FIGURE AC 2-1  Figure AC 2-1 above shows Field properties for a(n) ____ field.
A) Text
B) Memo
C) Number
D) AlphaNumeric

Accepted Answer

The field properties shown in Figure AC 2-1 are applicable to a Text field, as indicated by the data type listed in the top row of the properties.

Question 9

FIGURE AC 2-1  Figure AC 2-1 above, you would access this Field Properties screen in ____ view.
A) Datasheet
B) Design
C) Edit
D) Table

Accepted Answer

The Field Properties screen is used to define the properties of a field in a table or form. It can only be accessed in Design view.

Question 10

Match between columns
                        Premises: Wording that is used in VBA

Accepted Answer

The Answer of syntax and period (.) and comment and is...

Question 11

You can click the Data Type arrow in the ____________________ group to display a list of data types for fields.

Accepted Answer

The answer of You can click the Data Type arrow...

Question 12

Match between columns
                        Premises: Identifies what will appear in the unbound part of the text box control

Accepted Answer

The Answer of label and variable name and period (.) is...

Question 13

Match between columns
                        Premises: A symbolic name that you assign to a value

Accepted Answer

The Answer of variable name and period (.) and comment is...

Question 14

Because the primary key field in a table must contain a value, its Required property is set to Yes automatically. You must enter a value in a primary key field or Access ____.
A) will save the record, but it will be quarantined
B) will save the record, but it will be archived
C) will not save the record
D) will not save any part of the datasheet

Accepted Answer

When the Required property of a primary key field is set to Yes, Access will not allow the record to be saved if a value is not entered in the primary key field.

Question 15

The ____________________ database template creates a database with an empty table in it.

Accepted Answer

The answer of The ____________________ database template creates a database...

Question 16

You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group.

Accepted Answer

The answer of You can create a new table in...

Question 17

Match between columns
                        Premises: A statement that does not perform an action

Accepted Answer

The Answer of comment and variable name and syntax and is...

Question 18

Case AC 2-2 Jennifer is creating a new inventory management table for the pet store where she works. She is spending the time upfront to make sure the data types are all assigned correctly. Jennifer wants to add a field with the answer to the question, "Is this an inventory item?" The answer to the question would be "yes" or "no." In this case, she should use the ____ data type.
A) Yes/No
B) True/False
C) On/Off
D) Inventory/Custom

Accepted Answer

The Yes/No data type is the best choice because it allows for a binary choice of either "yes" or "no" which accurately reflects the answer to the question "Is this an inventory item?" The True/False and On/Off data types are also binary, but may not be as clear in their labeling for the specific question being asked. The Inventory/Custom data type does not relate directly to a binary choice and would not be appropriate for this field.

Question 19

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated
A) saves the table
B) saves the table and exits Access
C) copies and pastes the changes into Datasheet view
D) runs an update query

Accepted Answer

Saving the table in Design view will automatically update the changes in Datasheet view.

Question 20

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. Ron found a field that he wants to delete. He can delete a field by clicking the row selector for the field, and then clicking the Delete Rows button in the Tools group on the ____ tab.
A) Design
B) File
C) Home
D) Create

Accepted Answer

The Design tab in a database program such as Microsoft Access typically contains options for making structural changes to the database, such as deleting fields. The File tab is usually where options for saving, printing, and opening files are located. The Home tab typically contains options for working with data in the database, such as sorting and filtering. The Create tab usually contains options for creating new objects in the database, such as tables and queries, but not for deleting existing fields.

Quiz 1: Microsoft Access Basics

A field's ____________________ determines the kind of data that you can enter in the field, such as numbers or text.

Identify the letter of the choice that best matches the phrase or definition.

The ____ property specifies whether you must enter a field value in a record.

When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the table's ____________________.

When you enter a default value for a Text field, Access adds ____ around the field value.

What does the Field Size property do? What is the default field value for Text fields, and why would you want to change it? What is the default field value for Number fields, and why would you want to change it?

FIGURE AC 2-1 Figure AC 2-1 above shows Field properties for a(n) ____ field.

FIGURE AC 2-1 Figure AC 2-1 above, you would access this Field Properties screen in ____ view.

Identify the letter of the choice that best matches the phrase or definition.

You can click the Data Type arrow in the ____________________ group to display a list of data types for fields.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Because the primary key field in a table must contain a value, its Required property is set to Yes automatically. You must enter a value in a primary key field or Access ____.

The ____________________ database template creates a database with an empty table in it.

You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group.

Identify the letter of the choice that best matches the phrase or definition.

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. Ron found a field that he wants to delete. He can delete a field by clicking the row selector for the field, and then clicking the Delete Rows button in the Tools group on the ____ tab.