Introduction to Computers - Week 3 MC Review Test - Microsoft Access

Introduction to Computers - Week 3 MC Review Test - Microsoft Access


Review Test Submission: Week 3 MC Review Test - Microsoft
Access
Cour Introduction to Computers
se
Test Week 3 MC Review Test - Microsoft
Access
 Question 1
0 out of 5 points

In Access, what are the different parts of a database application called?
Selected 4.
Answer: table
s
Answers: 1.
fields
2.
data
3.
objec
ts
4.
table
s
Response A1 4 Hint: In Access, the different parts of a database application
Feedback: are called objects.
 Question 2
0 out of 5 points

In a table, which of the following must be identified as the primary key?
Selected 2.
Answer: record
Answers: 1.
field
2.
record
3.
object
4.
query
Response A1 19 Hint: When a new table is created, Access automatically includes one
Feedback: field, named ID and designates it as the primary key. It is strongly recommended
that you identify a field in each table as the primary key.objects.
 Question 3
5 out of 5 points

, What is a collection of integrated and related tables?
Selected 4.
Answer: datab
ase
Answers: 1.
field
2.
record
3.
table
4.
datab
ase
Response A1 4 Hint: A database is a collection of integrated and
Feedback: related tables.
 Question 4
5 out of 5 points

Which of the following allows you to build or modify the basic structure or functionality of an
object?
Selected 1.
Answer: Design view
Answers: 1.
Design view
2.
Datasheet view
3.
External data
4.
Ctrl+N
Response A1 7 Hint: Design view allows you to build or modify the basic structure or
Feedback: functionality of an object.
 Question 5
5 out of 5 points

Which of the following allows you to enter, modify, delete or view data records?
Selected 2.
Answer: Datasheet vi
ew
Answers: 1.
Design view
2.
Datasheet vi
ew

, 3.
External data
4.
Ctrl+N
Response A1 7 Hint: Datasheet view allows you to enter, modify, delete, or view data
Feedback: records.
 Question 6
5 out of 5 points

Which of the following data types is used to instruct Access to insert a unique, sequential
number each time a record is added?
Selected 2.
Answer: AutoNumber
Answers: 1.
Currency
2.
AutoNumber
3.
OLE Object
4.
Hyperlink
Response A1 14 Hint: The AutoNumber data type is used to instruct Access to
Feedback: insert a unique, sequential number each time a new record is added.
 Question 7
5 out of 5 points

Which of the following is used to find data in a database?
Selected 3.
Answer: query
Answers: 1.
report
2.
form
3.
query
4.
table
Response A1 5 Hint: A query is used to find data in a
Feedback: database.
 Question 8
5 out of 5 points

After you create a query, what must you do in order to see the results?