Access Exam UPDATED Exam Questions and CORRECT Answers

Access Exam UPDATED Exam Questions
and CORRECT Answers
In Access, what are the different parts of a database application called?
A. fields
B. data
C. objects

D. tables - CORRECT ANSWER - C. objects


In a table, which of the following must be identified as the primary key?
A. field
B. record
C. object

D. query - CORRECT ANSWER - A. field


To initiate the automatic saving of data, what must be done to your table at least once?
A. opened
B. saved
C. backed up

D. deleted - CORRECT ANSWER - B. saved


What is a collection of integrated and related tables?
A. field
B. record
C. table

D. database - CORRECT ANSWER - D. database


What is a collection of related fields called?

, A. field
B. record
C. table

D. database - CORRECT ANSWER - B. record


What is another name for a single unit of data?
A. field
B. record
C. table

D. database - CORRECT ANSWER - A. field


Where can you view each object in your database?
A. Navigation Pane
B. File tab
C. datasheet

D. Navigation menu - CORRECT ANSWER - A. Navigation Pane


Which of the following allows you to build or modify the basic structure or functionality of an
object?
A. Design view
B. Datasheet view
C. External data

D. Ctrl+N - CORRECT ANSWER - A. Design view


Which of the following data types is used for storing text longer than 255 characters?
A. Short Text
B. Long Text
C. Number