Make your own free website on Tripod.com

True/False

Indicate whether the sentence or statement is true or false.

 

____    1.         A single set of field values within a table is a record.

 

____    2.         Although a field has unique values in the table in which it is the primary key, it does not

                        have to have unique values in the table in which it is the foreign key.

 

____    3.         More than one user can enter data into a database.

 

____    4.         To launch Access, click the Start button, point to All Programs, point to Microsoft Office,

                        and then click Microsoft Office Access 2003.

 

____    5.         Only one user can retrieve and analyze data that was entered into a database by others.

 

____    6.         The Access window is the first window that appears when you launch Access.

 

____    7.         The navigation buttons allow you to step through a table record by record, or to quickly

                        go to the first or last record in the table.

 

____    8.         The fastest way to display all fields from an open table on a form is to use the Form

                        Wizard.

 

____    9.         Records in a database can be displayed in a custom format by creating a form.

 

____    10.        By defining a report, you can create a formatted printout or display of the data contained

                        in one or more tables.

 

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

 

____    11.        When you first open a(n) ____, Access selects the first field value in the first record.

a.

object

b.

datasheet

c.

query

d.

macro

 

 

____    12.        All fields for a specific entity can be grouped together as a(n) ____.

a.

table

b.

database

c.

element

d.

object

 

 

____    13.        A field, or a combination of fields, that has a unique value is a ____.

a.

foreign key

b.

primary key

c.

table

d.

relation

 

 

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

a.

common field

b.

hyperlink

c.

field value

d.

primary key

 

 

____    15.        The fastest way to create a form is to use the ____.

a.

AutoForm Wizard

b.

Form Wizard

c.

toolbar

d.

Query Wizard

 

 

 

Figure 1-1

 

____    16.        In Figure 1-1, the last row of data shown (10198, Trudel Spa & Resort, etc.) is a ____.

a.

table

b.

field

c.

record

d.

key

 

 

 

 

Figure 1-5b

____    17.        All screen elements except for the Access window title bar in Figure 1-5 are associated with the ____ window.

 

a.

Database

b.

Access

c.

Microsoft

d.

Objects

 

 

____    18.        You can make a(n) ____ copy of a database file to protect your database against loss or damage.

 

a.

master

b.

backup

c.

restoration

d.

secure

____    19.        The ____ option in the Getting Started task pane provides options for you to create a new database on your own, or to use one of the available online templates and let Access guide you through the steps for creating one of the standard databases provided by Microsoft.

 

a.

New project

b.

Database templates

c.

Create a new file

d.

General Templates

 

 

____    20.        Which extension identifies a file as a Microsoft Access database?

 

a.

.acc

b.

.mdb

c.

.adb

d.

.acx

 

____    21.        A system is defined to have the following components EXCEPT _________. 

 

a.

Input

b.

Output

c.

Control Mechanism

d.

Throughput

 

 

____    22.        A CBIS relies on computer hardware (including telecommunications) and software technology  to process & disseminate information.  What is CBIS?

 

 

a.

Computerized Business Information System

b.

Computer-Based Information System

c.

Commercial Business Information System

d.

Concurrently-Based Information System

 

____    23.        What form of information is at the Operational Level

 

a.

Summary

b.

Detailed

c.

Semi-Detailed

d.

Brief Summary

 

 

____    24.        Information Literacy consist(s) of ___________

 

a.

understanding how to use information at each step of the problem solving process

b.

knowing where the information can be obtained

c.

knowing how to share information with others

d.

all of the above

 

 

____    25.        The 2nd smallest piece of data in a computer is known as ___________

 

a.

bit

b.

character

c.

byte

d.

file