Deck 2: Access Lesson 2: Creating a Database

Question 1

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.

Answer 1

True

Question 2

In a table, the first key is the field that contains a unique field value for each record in the table.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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.

Question 5

You can only skip saving a table when you make changes to its layout.

Question 6

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

Question 7

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

Question 8

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

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

Question 9

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

Question 10

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

Question 11

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

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

Question 12

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.

Question 13

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

Question 14

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

Question 15

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

Question 16

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) New
B) Create
C) Table
D) Datasheet

Question 17

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

A) Data1
B) Table1
C) Sheet1
D) Datasheet1

Question 18

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

A) student identification numbers
B) employee numbers
C) Social security numbers
D) birthdates

Question 19

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.

Question 20

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

Question 21

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.

A) Text
B) Memo
C) AutoNumber
D) Description

Question 22

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

Question 23

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

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

Question 24

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

A) Needed
B) Necessary
C) Mandatory
D) Required

Question 25

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

A) Default
B) Repeat
C) Redo
D) Sample

Question 26

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

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

Question 27

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

A) Queries
B) Forms
C) Properties
D) Data Type

Question 28

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

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

Question 29

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.

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

Question 30

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

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

Question 31

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.

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

Question 32

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.

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

Question 33

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated

A) saves the table
B) saves the table and exits Access
C) copies and pastes the changes into Datasheet view
D) runs an update query

Question 34

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.

A) Tables
B) Records
C) Fields
D) Data

Question 35

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

A) Text
B) Memo
C) Number
D) AlphaNumeric

Question 36

If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table's primary key.

A) key
B) lock
C) infinity
D) clasped hands

Question 37

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

Question 38

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

Question 39

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.

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

Question 40

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

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

Question 42

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?

Question 43

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

Question 44

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

Question 45

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.

Question 46

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