Name: 
 

Microsoft Access Database Terms



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

 1. 

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
 

 2. 

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
 

 3. 

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

 4. 

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
 

 5. 

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

 6. 

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

 7. 

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
 

 8. 

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

 9. 

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
 

 10. 

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
 

 11. 

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
 

 12. 

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
 

 13. 

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
 

 14. 

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
 

 15. 

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
 



 
Check Your Work     Start Over