AL1 C1 C2

Question 1

When you delete a table from your computer’s hard drive, the message asking you to confirm the deletion does not display. Why?

Answer 1

Access automatically sends the deleted table to the Recycle Bin, where it can be retrieved.

Question 2

Each field in a table must have a name that is

Answer 2

unique

Question 3

What is the first step in creating a table?

Answer 3

Determine the fields.

Question 4

To create a new database or open a previously created database, click the Windows Start button and then click the

Answer 4

Access tile

Question 5

What does it mean when a pencil icon displays next to a field entry?

Answer 5

The record is being edited and the changes to the data have not yet been saved

Question 6

When a database is being designed, one field in each table has an asterisk next to its name. That field is called the

Answer 6

primary key field

Question 7

Use options in the _____ category in the More Fields button drop-down list to define a data type, assign a field name, and add a group of related fields.

Answer 7

Quick Start

Question 8

When you have a table open and click the Quick Print option in the Print backstage area, what happens?

Answer 8

The information in the table is sent to the printer without making any changes to the printer setup or the table formatting

Question 9

When you open a _____, it displays in _____ in the work area.

Answer 9

table; Datasheet view

Question 10

What data type should you use for a field that will store telephone numbers?

Answer 10

Short Text

Question 11

Which of the following Access screen elements contains tabs with commands and buttons divided into groups?

Answer 11

ribbon

Question 12

Adjust field column widths in a table by selecting the columns and then _____ one of the selected column boundary lines.

Answer 12

double clicking

Question 13

How can you print a table without the table name, date, and page number?

Answer 13

Remove the checkmark from the Print Headings option at the Page Setup dialog box

Question 14

To control what objects are shown in the Navigation pane, click which of the following?

Answer 14

the button on the menu bar containing the down arrow

Question 15

A database is composed of a series of _____ used to enter, manage, view, and print data.

Answer 15

objects

Question 16

Which of the following Access screen elements displays messages, the current view, and view buttons?

Answer 16

Status bar

Question 17

To freeze a column, click in the column, click the _____ button, and then click _____ at the drop-down list.

Answer 17

More; Freeze Fields

Question 18

What is the maximum number of characters that can be stored in a field of the Short Text data type?

Answer 18

255

Question 19

A _____ displays data from a table or related tables that meets a conditional statement and/or performs calculations.

Answer 19

query

Question 20

A relational database is a database with related

Answer 20

tables

Question 21

If a new database is opened in the current Access window, what will happen?

Answer 21

the existing database will close

Question 22

Data in a database is organized into _____, which contain information for related items.

Answer 22

tables

Question 23

A field is one piece of information about a person, place, or item, and all the fields for one unit are considered a

Answer 23

record

Question 24

Change a field name by _____ the name, clicking Rename Field at the shortcut menu, and then typing the new name.

Answer 24

right-clicking

Question 25

When a new field column is added in Datasheet view, where is it added?

Answer 25

to the right of existing fields

Question 26

The Name & Caption button is in the _____ group on the _____ tab.

Answer 26

Properties; Table Tools Fields

Question 27

The _____ includes the First and Last record buttons, the Previous and Next record buttons, and the New (blank) record button.

Answer 27

Record Navigation Bar

Question 28

Which of the following groups is not on the Print Preview tab?

Answer 28

Properties

Question 29

When creating a table, you can provide additional information about a field as a caption and a(n)

Answer 29

description

Question 30

One method for deleting a record is

Answer 30

clicking the Delete button arrow on the Home tab and then clicking Delete Record.

Question 31

The _____ is the base upon which other objects are created.

Answer 31

table

Question 32

When a field in a column is active, the text typed in the Description text box displays

Answer 32

at the left side of the Status bar

Question 33

A field name can contain up to _____ characters.

Answer 33

64

Question 34

When working in a table, press the Tab key to make the next field active or press _____ to make the previous field active.

Answer 34

Shift + Tab

Question 35

In Access, you can create a table in Datasheet view or in _____ view.

Answer 35

Design

Question 36

When moving a field column, begin by positioning the mouse pointer on the field name in the header row until the pointer displays as a

Answer 36

down-pointing black arrow

Question 37

When designing a database, the first principle is to reduce

Answer 37

redundant or duplicate information

Question 38

A _____allows fields and records to be presented in a layout different from the datasheet.

Answer 38

form

Question 39

To display a table in Print Preview, click the _____ option at the Print backstage area.

Answer 39

Print Preview

Question 40

In which situation would you want to define a default value for a field in your table?

Answer 40

when most records are likely to contain the same field value

Question 41

By default, Access prints a table

Answer 41

in standard letter size

Question 42

Use the _____ and _____ features to prevent field columns from showing or to view two nonadjacent field columns for comparison.

Answer 42

hide; freeze

Question 43

If a value is not entered in a field, Access enters a

Answer 43

null value

Question 44

How are relationships indicated in the Relationships window?

Answer 44

A black line connects the table field list boxes

Question 45

To display a different subdatasheet, remove the subdatasheet first, before selecting the next subdatasheet. Do this by clicking the _____, pointing to Subdatasheet, and then clicking Remove.

Answer 45

More button

Question 46

If Cascade Update Related Fields is selected at the Edit Relationships dialog box and changes are made to the primary key field value in the primary table, Access will automatically _____ the matching value in the related table.

Answer 46

update

Question 47

In the Relationships window, what signifies the “one” side of a one-to-many relationship?

Answer 47

the number 1

Question 48

In defining a primary key, which step do you complete just before you click the Primary Key button?

Answer 48

Click the field

Question 49

Suppose that you have not yet established any relationships among your tables. What happens when you click the Relationships button?

Answer 49

The Show Table dialog box displays

Question 50

What are the two general categories of database management systems?

Answer 50

file management and relational database management systems

Question 51

When a table is opened, it is sorted by

Answer 51

the primary key field

Question 52

Data in a foreign key field _____ match data in the primary key field of the related table.

Answer 52

must

Question 53

File management systems are sometimes referred to as

Answer 53

flat file databases

Question 54

When a relationship is established between two tables, the primary key in one table is joined to the _____ key in the other table.

Answer 54

foreign

Question 55

In which situation would using a one-to-one relationship be helpful?

Answer 55

when you need to divide a large table with many fields into two separate tables

Question 56

If only Enforce Referential Integrity is selected at the Edit Relationships dialog box and the related table contains a record, then a _____ key field value in the primary table cannot be changed.

Answer 56

primary

Question 57

What is displayed in the three-row grid in the middle of the Edit Relationships dialog box?

Answer 57

the names of the fields to be used to join the tables

Question 58

Choosing Cascade Update Related Fields and Cascade Delete Related Records at the Edit Relationships dialog box will cause primary key updates and deletions in _____ to be made automatically in _____.

Answer 58

the primary table; the related table

Question 59

The _____ integrity rules ensure that a record added to a related table has a matching record in the primary table.

Answer 59

referential

Question 60

Where is the Primary Key button?

Answer 60

in the Tools group on the Table Tools Design tab

Question 61

In the Relationships window, what signifies the “many” side of a one-to-many relationship?

Answer 61

the infinity symbol (¥)

Question 62

How does joining tables help ensure data integrity?

Answer 62

by avoiding the need to enter the same data in multiple tables

Question 63

A table should be about _____ subject(s).

Answer 63

one

Question 64

Which of the following features is found in a relational database management system but not in a file management system?

Answer 64

the ability to define relationships between tables

Question 65

To close subdatasheets for all records, begin by clicking the _____ button.

Answer 65

More

Question 66

What is done at the Show Table dialog box?

Answer 66

Tables are added to the Relationships window

Question 67

Once a relationship is established between tables, clicking the Relationships button displays which of the following?

Answer 67

the Relationships window

Question 68

If a table has more than one relationship defined, clicking the expand indicator will display the

Answer 68

Insert Subdatasheet dialog box

Question 69

To edit a specific relationship, position the mouse pointer _____, click the right mouse button, and then click the Edit Relationship option.

Answer 69

on the middle portion of the black line that connects the related tables

Question 70

In a one-to-many relationship, the table containing the “one” is referred to as the _____ table.

Answer 70

primary

Question 71

What happens when you position the mouse pointer on the join line connecting related tables, click the right mouse button, and then click Delete at the shortcut menu?

Answer 71

You are prompted to confirm the deletion

Question 72

In defining a one-to-many relationship between two tables, what is the next step after placing the two tables in the Relationships window?

Answer 72

Drag the common field from the primary table to the related table

Question 73

Access is a(n) _____ database management system in which relationships are defined between sets of data.

Answer 73

relational

Question 74

When you perform a join, you are

Answer 74

establishing a relationship between tables

Question 75

A database table can contain which of the following two types of key fields?

Answer 75

primary and foreign

Question 76

To print a report showing the relationships among tables, click the Relationship Report button, which is in the

Answer 76

Tools group in the Relationships window

Question 77

To display subdatasheets for all records in the primary table, begin by clicking the

Answer 77

More button in the Records group on the Home tab

Question 78

When a relationship is established between two tables, a subdatasheet displays

Answer 78

records in related tables

Question 79

What happens if a primary key field is left blank?

Answer 79

Access will not allow closing the database until a value is entered in the field

Question 80

A one-to-one relationship is _____ a one-to-many relationship.

Answer 80

not as common as

Question 81

Typically, a primary key field in one table becomes _____ in a related table.

Answer 81

the foreign key field

Question 82

Which of the following steps should be performed first to edit a relationship?

Answer 82

Click the Relationships button

Question 83

In planning a database and its related tables, it is important to consider

Answer 83

what each table is about

Question 84

To add a table to the Relationships window, click the table name at the Show Table dialog box and then click the _____ button.

Answer 84

Add

Question 85

For primary key fields, Access enforces entity integrity, which means that

Answer 85

it expects a value in the primary key field(s) for each record in the table.

Question 86

The Relationships window displays _____ that have been defined between tables.

Answer 86

all the relationships

Question 87

The ability to relate, or _____, tables is what makes Access a relational database system.

Answer 87

join

Question 88

A relational database management system eliminates the need for

Answer 88

data redundancy

Question 89

Abbreviate field names so that they are _____ but still easily understood.

Answer 89

as short as possible

Question 90

The plus symbols (+) in a subdatasheet are referred to as

Answer 90

expand indicators

Question 91

Relationships between tables are edited

Answer 91

at the Edit Relationships dialog box

Question 92

To add a new record to an open table, make sure the _____ tab is active and then click the _____ button in the Records group.

Answer 92

Home; New

Question 93

To insert a new field column in a table in Datasheet view, click in the first cell below the

Answer 93

Click to Add heading

Question 94

To create a one-to-many relationship, open the database containing the tables to be related and then click the Relationship button in the _____ group on the _____ tab.

Answer 94

Relationships; Database Tools

Question 95

Changes made to fields in a _____ affect the table and any related tables.

Answer 95

subdatasheet

Question 96

In database design, the lines drawn between tables that represent relationships are called

Answer 96

join lines

Question 97

The Add & Delete group is on the _____ tab and contains five buttons for assigning data types plus a More Fields button.

Answer 97

Table Tools Field

Question 98

Use the keyboard shortcut _____ to display the Open backstage area.

Answer 98

Ctrl + O

Question 99

What happens if you enter four characters into a text field that has a field size of 2?

Answer 99

Access will not accept the additional text.

Question 100

Why would you click the Enable Content button?

Answer 100

to indicate that a file originated from a trusted location on your computer