ITSW 1307 Exam 1 -- Closed-Book Portion

 

Number a sheet of paper from 1 to 40.  Beside each number, write the letter corresponding to the best answer to that question.

 

1.  Data from two or more tables can be connected by specifying a

 

A:

common field.

B:

hyperlink.

C:

field value.

D:

primary key.

 

 

2.  A relational database is a collection of

 

A:

field values.

B:

records.

C:

related tables.

D:

common fields.

 

 

3.  A primary key

 

A:

consists of only one field.

B:

has the same value for all records.

C:

must contain a unique value for each record within the table.

D:

is defined automatically.

 

 

4.  A field that is defined in a table and that is also defined as a primary key in a different table is a(n)

 

A:

invalid definition.

B:

primary key.

C:

relational database.

D:

foreign key.

 

 

5.  After a database has been opened, the ____ window becomes the main control center for that database.

 

A:

Access

B:

Wizard

C:

maximized

D:

Database

 

 

6.  Which of the following is NOT an example of an Access object?

 

A:

report

B:

query

C:

form

D:

toolbar

 

7.  A table's contents are displayed as rows and columns (similar to a spreadsheet) in

 

A:

the Query window.

B:

a database form.

C:

Datasheet view.

D:

the export window.

 

 

8.  Diane is working in the customer table and needs to know if any customers are located in Texas. To find this information, she would

 

A:

define a new table.

B:

create a query.

C:

define a new form.

D:

access the Database Wizard.

 

 

9.  A form is used to

 

A:

select records that meet specific criteria.

B:

display records for viewing or editing.

C:

automate the retrieval and update process.

D:

None of the above

 

 

10.  Any object created in Access that you think you will use on a regular basis should be

 

A:

recreated each time you need it.

B:

copied to a holding area.

C:

saved.

D:

copied to the clipboard.

 

 

11.  Which of the following steps do you need to follow when designing a database?

 

A:

Identify the fields that will be needed.

B:

Group the fields into tables that describe the required entities.

C:

Determine the primary key for each table.

D:

All of the above

 

 

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

 

A:

properties.

B:

traits.

C:

values.

D:

qualities.

 

 

13.  The ____ determines what type of values can be entered for a field.

 

A:

data element

B:

data type

C:

data integrity

D:

primary key

 

 

14.  When defining a field, the field ____ determines how much physical storage space the field requires.

 

A:

density

B:

size

C:

placement

D:

wizard

 

 

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

 

 

16.  After a database has been opened, you can determine which tables are defined by selecting Tables in the

 

A:

Objects bar.

B:

Tools menu.

C:

Status bar.

D:

Access window.

 

 

17.  If you do not enter any value for a field, you have given the field a(n) ____ value.

 

A:

blank

B:

redundant

C:

null

D:

illegal

 

 

18.  If you make a mistake when entering data in a field, you can erase the characters to the left of the insertion point by pressing the ____ key.

 

A:

left arrow

B:

Tab

C:

Delete

D:

Backspace

 

 

19.  You can modify an existing table's structure in

 

A:

the Database window.

B:

Form view.

C:

Design view.

D:

the Properties area.

 

 

20.  A field defined as a Yes/No field type will be displayed as a

 

A:

radio button.

B:

Y or N.

C:

check box.

D:

null value.

 

 

21.  Generalized queries that specify fields and records to be selected are called ____ queries.

 

A:

simple

B:

select

C:

criteria

D:

normal

 

 

22.  The order in which fields are displayed in a query depends on

 

A:

the method used to transfer them from the field list to the design grid.

B:

how they are defined in the table.

C:

the selection criteri a.

D:

the type of datasheet selected.

 

 

23.  To see the results of a query, you must ____ it.

 

A:

save

B:

sort

C:

run

D:

catalog

 

 

24.  The fields and selection criteria for a query are defined in the

 

A:

field list.

B:

datasheet.

C:

toolbar.

D:

design grid.

 

 

25.  If a record in one table matches several records in a related table, the relationship is called a(n) ____ relationship.

 

A:

consistent

B:

one-to-many

C:

many-to-one

D:

nonunique

 

 

26.  Access will automatically update foreign key values when the primary key value is changed if the ____ option is chosen when defining a relationship.

 

A:

cascade deletes

B:

data guardian

C:

cascade updates

D:

data consistency

 

 

27.  Before you can click a sort button on the toolbar to sort the data, you must first

 

A:

determine the primary key.

B:

click the View button.

C:

select a column on which to base the sort.

D:

save the query.

 

 

28.  The ____ operator will cause a record to be selected only if two or more conditions are satisfied.

 

A:

Or

B:

If..Or

C:

range

D:

And

 

 

29.  Selection criteria that are placed in different rows in the query design grid indicate an ____ operator.

 

A:

Or

B:

Exclusion

C:

And

D:

Alternate

 

 

30.  When you define a query that performs a calculation, you must add a ____ field.

 

A:

result

B:

control

C:

calculated

D:

dynamic

 

 

31.  A form using all fields in a selected table can be created automatically using the

 

A:

Form Wizard.

B:

AutoForm Wizard.

C:

Select All button.

D:

Database Wizard.

 

 

32.  To create a form in Access, you click

 

A:

the Forms tab in the Access window.

B:

the New button on the toolbar.

C:

Forms in the Object bar of the Database window.

D:

the Design button.

 

 

33.  To move from record to record in a form you can use the

 

A:

Form Wizard.

B:

Record Finder.

C:

Record Navigator.

D:

navigation buttons.

 

 

34.  You can move from field to field within a form by using the

 

A:

navigation buttons.

B:

Page Up or Page Down keys.

C:

Tab key.

D:

Ctrl+Shift keys.

 

 

35.  To see a sample of your form before it is printed you can click the ____ button.

 

A:

Print Preview

B:

Zoom

C:

Maximize

D:

Form View

 

 

36.  A form that accesses data from two tables has a main form and a(n)

 

A:

secondary form.

B:

subform.

C:

related form.

D:

alternate form.

 

 

37.  If you create a form based on two tables, you must first choose the ____ table and select its fields to include in the form.

 

A:

related

B:

largest

C:

primary

D:

datasheet

 

 

38.  In a form created to access two tables, there is/are ____ navigation buttons displayed.

 

A:

one set of

B:

two sets of

C:

no

D:

a user-specified number of

 

 

39.  You can see a list of available reports by clicking

 

A:

the Help button.

B:

the Open button in the Database window.

C:

the Find button in the Database window.

D:

Reports in the Objects bar in the Database window.

 

 

40.  When a picture or other graphic image is placed in the Report header section, it will appear

 

A:

once at the beginning of the report.

B:

at the top of every page.

C:

after every record break.

D:

on the first and last pages of the report.

 

Raise your hand, and your instructor will bring you the diskette and instruction sheet for the open-book hands-on part of the test.