Question 1

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.

Accepted Answer

A)  Yes/No 
B)  True/False 
C)  On/Off 
D)  Inventory/Custom

Question 2

Use the ____ property to specify how you want Access to display numbers, dates, times, and text.

Accepted Answer

A)  Setup 
B)  Layout 
C)  Format 
D)  Edit

Question 3

After setting the properties for the fields in your table, you can use Datasheet view to enter records in the table.

Accepted Answer

A) True 
 B)False

Question 4

When you create a table in Datasheet view, clicking the Click to Add field selector opens the list of data queries .

Accepted Answer

A) True 
 B)False

Question 5

When you use a template to create a database, the template creates the database and one or more table, query, form, and report themes that you use to enter and view data.

Accepted Answer

A) True 
 B)False

Question 6

You need to save a new record after entering it. Access does not save new records automatically.

Accepted Answer

A) True 
 B)False

Question 7

After you save a table, the new table name appears ____.

Accepted Answer

A)  on the tab for the table 
B)  in the Navigation Pane 
C)  both a. and b. 
D)  neither a. nor b.

Question 8

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

Accepted Answer

A)  quotation marks 
B)  parentheses 
C)  either a. or b. 
D)  neither a. nor b.

Question 9

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

Accepted Answer

A)  Datasheet 
B)  Design 
C)  Edit 
D)  Table

Question 10

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 11

In Design view, you can add, delete, and make changes to the way that fields store data .

Accepted Answer

A) True 
 B)False

Question 12

A Text field can store up to 155 characters and is used to store data such as names and addresses.

Accepted Answer

A) True 
 B)False

Question 13

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.

Accepted Answer

A)  Design 
B)  File 
C)  Home 
D)  Create

Question 14

After you have added all of the fields to your table, the last column in the table contains the Click to Add field selector in case you need to add another field later.

Accepted Answer

A) True 
 B)False

Question 15

Fields with the Memo data type accepts field values containing alphanumeric data, but can store field values containing up to ____ characters.

Accepted Answer

A)  535 
B)  6,535 
C)  65,535 
D)  165,535

Question 16

You can open a table directly in Design view from the Navigation Pane. ____ the table name in the Navigation Pane, and then click Design View on the shortcut menu.

Accepted Answer

A)  Right-click 
B)  Single-click 
C)  Double-click 
D)  Select

Question 17

When viewing a table in Design view, the field names and data types appear in the ____ in the top half of the Table window.

Accepted Answer

A)  datasheet 
B)  chart 
C)  design grid 
D)  matrix

Question 18

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

Accepted Answer

A)  Data 
B)  Views 
C)  Properties 
D)  Formatting

Question 19

Match between columns
                        Premises: Stores dates, times, or a combination of both.
Stores Yes/No, True/False, or On/Off values.
Accepts field values containing letters, numbers, spaces, and certain symbols.
Accepts monetary values and displays them with a dollar sign and decimal point.
Stores long passages of text.

Accepted Answer

The Answer of Yes/No and Date/Time and Text and Memo is...

Question 20

To create a database, start Access. On the ____ tab in Backstage view, click the template you want to use.

Accepted Answer

A)  New 
B)  Create 
C)  Print 
D)  Help

Exam 2: Access Lesson 2: Creating a Database

Use the ____ property to specify how you want Access to display numbers, dates, times, and text.

After setting the properties for the fields in your table, you can use Datasheet view to enter records in the table.

When you create a table in Datasheet view, clicking the Click to Add field selector opens the list of data queries .

When you use a template to create a database, the template creates the database and one or more table, query, form, and report themes that you use to enter and view data.

You need to save a new record after entering it. Access does not save new records automatically.

After you save a table, the new table name appears ____.

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

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

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?

In Design view, you can add, delete, and make changes to the way that fields store data .

A Text field can store up to 155 characters and is used to store data such as names and addresses.

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.

After you have added all of the fields to your table, the last column in the table contains the Click to Add field selector in case you need to add another field later.

Fields with the Memo data type accepts field values containing alphanumeric data, but can store field values containing up to ____ characters.

You can open a table directly in Design view from the Navigation Pane. ____ the table name in the Navigation Pane, and then click Design View on the shortcut menu.

When viewing a table in Design view, the field names and data types appear in the ____ in the top half of the Table window.

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

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

To create a database, start Access. On the ____ tab in Backstage view, click the template you want to use.