Share
Explore BrainMass

10 M/C Questions on Excel 2003

1. The primary object in a MS Access database for collecting and storing data is a:
a. record
b. field
c. file
d. table
e. database

2. Each individual entry in a database is stored as a:
a. field
b. table
c. record
d. file
e. page

3. Records are stored in a database file as a:
a. row
b. column
c. sheet
d. page
e. it depends on how the database is set up

4. Which of the following is not one of the database objects available in the Access database window?
a. Programs
b. Forms
c. Reports
d. Pages
e. Tables

5. Which of the following is a question you ask of your database?
a. Form
b. Query
c. Table
d. Page
e. Macro

6. Which of the following is used to present, summarize, and print data from the database?
a. Table
b. Form
c. Report
d. Query
e. Module

7. The first step in designing high quality databases is to:
a. determine your input requirements
b. determine your table structures
c. determine your output requirements
d. determine the amount of funding available
e. determine the priority of the project

8. The second step in designing high quality databases is to:
a. determine your input requirements
b. determine your table structures
c. determine your output requirements
d. determine the amount of funding available
e. determine the priority of the project

9. Dividing and grouping data into separate tables and fields for flexibility in searching, sorting, and calculating is which step of planning a database?
a. 1st
b. 2nd
c. 3rd
d. 4th
e. 5th

10. Adding sample records to the table using both datasheets and forms, running queries, and producing reports to test the application occurs in which step of planning a database?
a. 1st
b. 2nd
c. 3rd
d. 4th
e. 5th

Solution Preview

1. The primary object in a MS Access database for collecting and storing data is a table.
2. Each individual entry in a database is stored as a record
3. Records are stored in a database file as a row
4. Which of the following is not one of the database ...

Solution Summary

Basic level questions on Excel 2003.

$2.19