Microsoft Access : Chapter 1: Exam



Name: _______________________                                                                                   Date: _______________________


PART I: MATCHING (4 pts each)

Select the term that BEST corresponds to each definition presented below.  Select only ONE term for each definition.  Indicate your selection by printing the corresponding letter in the space provided. GOOD LUCK!

            A. Data Validation                                                                    I. Find Command

B. Query                                                                                  J. Sort

C. Filter by Form                                                                      K. Relational Database

D. Filter by Selection                                                                L. Referential Integrity

E. Report                                                                                 M. Replace Command

F. Form                                                                                    N. Design View

G. Macro                                                                                 O. Field

H. Pencil Symbol                                                                      P. Record

1. ______ Indicates that the user is working on the record and that changes have not yet been saved. 

2. ______ Answers a question about a database. 

3. ______ Presents the data in a table or query in an attractive fashion on the printed page. 

4. ______ Contains multiple tables and enables the user to extract information from those tables in a single query.

5. ______ Displays a subset of records from the table according to a specified criteria. 

6. ______ Anticipates errors that the user might make and rejects them prior to accepting data. 

7. ______ Assures that data is consistent between related databases. 

8. ______ A filter which allows the user to select criteria from a drop-down list, and to apply multiple criteria simultaneously. 

9. ______ Used to automate the performance of any repetitive task. 

10. ______ Used to define the table initially and to specify the fields it will contain.



Circle the letter corresponding to BEST answer choice for each of the questions presented below.  Select only ONE answer for each question.  Make sure your final answer choices are clear. 

11. To create a database to organize the different college books that you must purchase, which of the following is the BEST Microsoft program to use?

a)      Microsoft Access

b)      Microsoft Word

c)      Microsoft Powerpoint

d)      Microsoft Frontpage

 12. The symbol that represents Microsoft Access is a: 

a)      A book

b)      An X

c)      An A

d)      A key

 13. A table consists of: 

a)      Macros

b)      Queries

c)      Records

d)      Modules 

14. The database view is used to: 

a)      Add, Delete or Edit Records

b)      Specify the fields that a table will contain

c)      Initially define the table

d)      Modify the table definition if changes are necessary 

15. Which of the following is NOT true about the open database command? 

a)      You can execute it from the file menu

b)      You can click the open button on the database toolbar

c)      It loads a database from disk into memory

d)      It opens the selected table from the database view

 16. The purpose of a table is to: 

a)      Present a document that can be posted on the internet

b)      Present a document in a professional fashion so it can be printed

c)      Store data about an entity

d)      Answer a question about the database 

17. The correct hierarchy of terms from largest to smallest is: 

a)      field, record, table, database

b)      record, table, database, field

c)      database, table, field, record

d)      database, table, record, field 

18. The easiest way to implement a filter that contains all the desired criteria is to apply a: 

a)      Filter by form

b)      Filter by selection

c)      Filter excluding selection

d)      Sort 

19. If you wanted to display records from highest to lowest value, which one of the following commands would you use? 

a)      Sort ascending

b)      Remove filter

c)      Sort Descending

d)      Referential Integrity 

20. Which of the following is true after you have removed a filter? 

a)      All previously filtered records are again displayed

b)      The filter is not deleted

c)      All of the above

d)      Only a) but not b) 

21. A relational database must have at least how many databases? 

a)      A relational database has no databases

b)      One

c)      Two

d)      Five 

22. How many queries are needed to locate information in a relational database?

a)      Two

b)      One

c)      Three

d)      No queries are needed 

23. Which of the following functions (symbols) enables easy access to all related database of a single entry? 

a)      $

b)      *

c)      +


24. All of the following apply to data validation EXCEPT: 

a)      Anticipates user error

b)      Reject incorrect data prior to entry

c)      Assures consistency between related databases

d)      Is a crucial part of any system 

25. The disadvantage of the undo command is that it: 

a)      Only allows the reversal of the most recent command

b)      Has no shortcut button on the toolbar

c)      Not common to all Microsoft Office applications

d)      Only applies to certain records 


PART III: TRUE OR FALSE (3 pts each)

For the following sentences decide whether the statement is true or false.  Indicate your answer by writing a T or F in the space provided next to each statement. 

26. ______ The shortcut to the find command button is represented on the toolbar by a lightning bolt. 

27. ______ The most useful advantage of filtering by selection is that the user can specify relationships within a given criterion. 

28. ______ Sort ascending is more appropriate to use for numerical values than sort descending. 

29. ______ A module provides a greater degree of automation. 

30. ______ A triangle indicates that the record has been saved to disk.



Back to Main Page

Microsoft Access : Chapter 1 : Exam