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