FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Access Lesson 2: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Calculated
B) Math
C) Accounting
D) Monetary

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

When viewing a table in Design view, the bottom half of the Table window is called the Field ____ pane.

After specifying the file name and the location in which to store the database, click the ____ button to create the new database and open it in Access.

A combination of numbers and text is also called alphanumeric data.

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

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

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

An AutoNumber field automatically adds a unique number to the primary key field for each record in the table.

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.

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.

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

The first step in creating a database is to create the file that will store the data.

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

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

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

When you create a blank database, Access creates the first table in the database for you and names it ____.

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

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

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