DBA115: Tutorial 2

When you use the number data type to define a field, you should set the field's ____ property based on the largest value you expect to store in that field.

Field Size

The default table name assigned to a new table is ____.

Table1

For unique Employee IDs such as 34A78C, use the _____ data type.

Text

Rossi Recycling Group Tom Rossi uses the Rossi database to maintain information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him maintain the database by updating one table and creating two new ones. Tom is debating about which format to use for the Donation Value field. What is the best reason to change the default currency data type format?

a. The dollar amounts will never contain cents because the donations are in whole dollar amounts only. b. The dollar signs clutter the datasheet and are also unnecessary. c. Whole numbers can be stored in less space on the hard disk. **d. all of the above

he ____ determines what field values are allowed and what other properties the field will have.

data type

When designing a database, you need to identify the ____ that will be required.

fields

Given a relationship between the two tables in the accompanying figure, the field values labeled 2 show ____ data.

inconsistent

The maximum size of the Text data type is ___ characters.

255

Pine Hill Music School Yuka Koyama uses the Pinehill database to maintain information about the students, teachers, and contracts for her music school. Yuka asks you to help her build the database by updating one table and creating two new tables. If you choose the ____, Access permits the change in value to the primary key and changes the appropriate foreign key values in the related table, thereby eliminating the possibility of inconsistent data in Yuka's database.

Cascade Update Related Fields option

Given a relationship between the two tables in the accompanying figure, in the Contract table shown, the ____ field is a redundant field.

Company

Rossi Recycling Group Tom Rossi uses the Rossi database to maintain information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him maintain the database by updating one table and creating two new ones. Tom notices that he often needs to type the same data that he just typed in the previous record. He can speed up the data entry process by using ____.

Ctrl+'

In the accompanying figure, the primary key is in the ____ table and the foreign key is in the ____ table.

Customer, Contract

GEM Ultimate VacationsGriffin and Emma MacElroy use the GEM database to track data about the services they provide to clients who book luxury vacations through their agency. They ask you to help them maintain this database. If Griffin wants to delete several fields he imported, he should work in ____ view.

Design

Which view would you select if you wanted to define a table yourself from start to finish?

Design view

What data type has a field size of 1 to 65,535 characters (although the exact size is determined by the entry), and allows field values containing letters, digits, spaces, and special characters? It is also used for long comments and explanations.

Memo

Rossi Recycling Group Tom Rossi uses the Rossi database to maintain information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him maintain the database by updating one table and creating two new ones. For a special report, Tom wants his donation fields to display in a Currency format that does not display dollar signs, so he will use the ____ format.

Standard

To create a new table, you should ____.

a. name the fields and define their properties b. define the primary key c. save the table structure **d. all of the above

The Relationships window in the accompanying figure can be used to do which of the following?

all of the above

A primary key that consists of more than one field is called a ____ key.

composite

If you do not enter any value for a field, you have given the field a/an ____ value.

null

Case-Based Critical Thinking Questions Case 2-4 GEM Ultimate VacationsGriffin and Emma MacElroy use the GEM database to track data about the services they provide to clients who book luxury vacations through their agency. They ask you to help them maintain this database. Griffin notices that he has records in one table that are supposed to have a matching record in another related table, but they do not. These records are considered to be ____ records.

orphaned

To rearrange the order of fields in the design of an Access table without cutting, _____.

position the mouse pointer in the row selector and use the move pointer to drag and drop the field

The characteristics of a field, such as name, size, and type, are called the field ____.

properties

Parkhurst Health & Fitness Center Martha Parkhurst uses the Fitness database to track information about members who join the center and the program in which each member is nrolled. She asks you to help her maintain this database. If Martha imports data from a spreadsheet into a new table but forgets to indicate that the first row contains column headings, she will see ____.

the first row of data will be the field names

A primary key ____.

uniquely identifies each record in a table