Make your own free website on Tripod.com

 Home to Victor Choong


 

 

BUSI 335 - Management Information Systems Quiz #1
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
 
 
q_files/i0180000.jpg

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
 

 17. 

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
 

 18. 

Which extension identifies a file as a Microsoft Access database?
a.
.acc
b.
.mdb
c.
.adb
d.
.acx
 
 
q_files/i0220000.jpg

Figure 1-5b
 

 19. 

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
 

 20. 

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