Exam 2: Access Lesson 2: Creating a Database

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.

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.

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