Exam 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.

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

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

To set a table's primary key, click the Primary Key button in the Tools group on the Home tab.

Using the ____ data type, open the Expression Builder dialog box, which lets you specify fields and operators to use in calculations.

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

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 .

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 you create a blank database, Access creates the first table in the database for you and names it ____.

If you have a table with an ID field with the AutoNumber data type, when you enter a new record in the table, you do not need to type a value in this field.

All of these values are also good candidates to use as a table's primary key field EXCEPT ____.

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.

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

The ____ Value property enters the same field value in a field every time a new record is added to the table.

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.

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

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

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 ____________________.

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