Name:     ID: 
 
Email: 

Microsoft Access Skills Assessment - Part I

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 1. 
Just like when used in forms, you can add your name to a report by using the  ____ control.
a.
text
c.
comment
b.
address
d.
label
 

 2. 
A term that indicates which data is being searched in a database table.
a.
relationship
c.
field value
b.
database
d.
criteria
 

 3. 
A feature in a database that lets you connect two or more tables together so you can use their data.
a.
table
d.
report
b.
form
e.
database
c.
relationship
f.
query
 

 4. 
The view of a database table that display records in rows and fields in columns.  New records can be added, edited and deleted in this view.
a.
datasheet view
b.
design view
 

 5. 
A complete set of data for one item in a row in a database table.
a.
record
d.
object
b.
field
e.
relationship
c.
table
f.
field value
 

 6. 
A database object that is used to display data from one or more tables or queries in a format that is usually customized for viewing online.
a.
query
d.
table
b.
relationship
e.
database
c.
report
f.
form
 

 7. 
A database object that stores all the data in the database in a format called a datasheet.
a.
report
d.
relationship
b.
form
e.
query
c.
database
f.
table
 

 8. 
A database object that is used to display summary data from one or more tables or queries in a format that is usually customized for printing.
a.
database
d.
table
b.
form
e.
report
c.
relationship
f.
query
 

 9. 
The view of a database table that allows the user to enter or edit field names, select a fields’s data type, and change a field’s property..
a.
datasheet view
b.
design view
 

 10. 
The specific data stored in a field for a record.
a.
field
d.
table
b.
record
e.
object
c.
field value
f.
relationship
 

 11. 
The descriptive name of a column in a database table.
a.
table
d.
field value
b.
object
e.
record
c.
field
f.
relationship
 

 12. 
A database object that is used to search and retrieve records from tables using a search criteria.
a.
relationship
d.
database
b.
report
e.
query
c.
form
f.
table
 

 13. 
To add a picture to a report, click the Insert ____ button in the Controls group on the Design tab.
a.
Picture
c.
Brand
b.
Logo
d.
Image
 

 14. 
A collection of objects that work together to store, retrieve, display, and summarize data.
a.
report
d.
table
b.
database
e.
form
c.
query
f.
relationship
 

 15. 
You can use a form to ____.
a.
update the records
c.
delete existing records
b.
add new records
d.
all of the above
 



 
         Start Over