Purchase Solution

10 M/C Questions on Excel 2003

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

Basic level questions on Excel 2003.

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

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.