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

Multiple Choice

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

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 3

True/False

Review LaterAdd Note

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

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

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

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.

The ____ Value property enters the same field value in a field every time a new record is added to 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.

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

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.

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

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

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.

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.

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

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

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.

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

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