LAB FINAL EXAM REVIEW STUDY GUIDE EXAM WITH COMPLETE 650 QUESTIONS AND WELL ELABORATED ANSWERS JUST RELEASED

Page 1 of 253



LAB FINAL EXAM REVIEW STUDY GUIDE EXAM
WITH COMPLETE 650 QUESTIONS AND WELL
ELABORATED ANSWERS JUST RELEASED

QUESTION: 1. A collection of related records in database is known as a

A) Table

B) Database

C) File

D) None of the above - ANSWER✔✔A) Table



QUESTION: 2 If task A and task B can be done in parallel but only after task C has finished.
Which one of the following relationships is correct?

A) Task A is a successor of task C

B) Task B is a successor of task C

C) Task C is a predecessor of task A

D) All of the above - ANSWER✔✔D) All of the above



QUESTION: 3. An example of many-to-one relationship is:

A) Student-ID

B) Course-Student

C) Advisor-Student

D) None of the above - ANSWER✔✔D) None of the above

, Page 2 of 253


QUESTION: 4. Match Access objects Form____, Table____, Report____, and Query____ to their
primary usage in the space provided

A) Representing result

B) Easier data entry

C) Storing data

D) Retrieving data - ANSWER✔✔BCAD



QUESTION: 5. In order to do the same thing one can do with VLOOKUP function in Excel, what
would you need in Access?

A) Primary Key

B) Relationship

C) Query

D) All of the above - ANSWER✔✔D) All of the above



QUESTION: 6. Task A and task B can be done in parallel. Task C can only start after both Task A
and B are finished. Which one of the following is correct?

A) Task A is predecessor for Task B and C

B) Task B is successor for Task C and A

C) Task C is a successor for Task A and B

D) None of the above - ANSWER✔✔C) Task C is a successor for Task A and B



QUESTION: 7. Checking "Enforce referential integrity" option makes sure user can't change or
add data accidentally if a matching record is present in a related table. (T/F) - ANSWER✔✔TRUE



QUESTION: 8. In Microsoft Access, a table can only have one primary key. (T/F) -
ANSWER✔✔FALSE

, Page 3 of 253




QUESTION: 9. A field is the smallest unit of information in an Access database. (T/F) -
ANSWER✔✔TRUE



QUESTION: 10. In Access, a row in table represents a single entity while a column represents
the attribute. (T/F) - ANSWER✔✔TRUE




QUESTION:1. ____Uniquely identifies each record.

A) Primary Key

B) Key Record

C) Unique Key

D) Primary ID - ANSWER✔✔A) Primary Key



QUESTION: 2. Which of the following is NOT a database object?

A) Tables

B) Queries

C) Switchboard

D) Reports - ANSWER✔✔C) Switchboard



QUESTION: 3. A ____ enables you to view data from a table based on a specific criterion.

A) Form

B) Query

C) Macro

D) Report - ANSWER✔✔B) Query

, Page 4 of 253




QUESTION: 4. It is an association established between commons

A) Line

B) Relationship

C) Primary Key

D) Records - ANSWER✔✔B) Relationship



QUESTION: 5. Which of the following database object hold data?

A) Forms

B) Reports

C) Queries

D) Tables - ANSWER✔✔D) Tables



QUESTION: 6. Which of the following store command to retrieve data from database?

A) Forms

B) Reports

C) Queries

D) Tables - ANSWER✔✔C) Queries



QUESTION: 7. Which of the following database object produces the final result to present?

A) Forms

B) Reports

C) Queries

D) Table - ANSWER✔✔B) Reports