Name:     ID: 
 
Email: 

Microsoft Access Database Terms

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

 1. 

What operator is used to search for records when either one of two conditions is satisfied or when both conditions are satisified.
a.
And Logical Operator
c.
both a & b
b.
Or Logical Operator
 

 2. 

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

 3. 

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

 4. 

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

 5. 

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

 6. 

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

 7. 

The specific data stored in a field for a record.
a.
field
c.
field value
b.
table
d.
record
 

 8. 

When using a Form to add new records, which object is the new data added to?
a.
table
c.
form
b.
query
d.
report
 

 9. 

A database object that allows you to organize and present your data in a  reader-friendly, visually appealing printout or screen display.
a.
table
c.
form
b.
query
d.
report
 

 10. 

The process of relating tables by joining them using a common field.
a.
relationship
c.
primary key
b.
cascade update
d.
foreign key
 

 11. 

A user friendly database object that you use to enter, edit, and view records from the database table.
a.
table
c.
form
b.
query
d.
report
 

 12. 

Data type that would provide a check box in a field.
a.
Date/Time
c.
Yes/No
b.
Short Text
d.
Currency
 

 13. 

Data type for a Invoice Amount field.
a.
Currency
c.
Yes/No
b.
Date/Time
d.
Short Text
 

 14. 

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

 15. 

Data type for a Date of Visit field.
a.
Currency
c.
Yes/No
b.
Date/Time
d.
Short Text
 

 16. 

Comparison relational operator needed to find a exact match.
a.
>
d.
<
b.
< =
e.
< >
c.
=
f.
> =
 

 17. 

A field whose values uniquely identify each record in a table.
a.
Foreign key
c.
Navigation Pane
b.
Primary key
d.
Relational Database
 

 18. 

A tool in Microsoft Access that will ask you a series of questions and then creates the object based on your answers.
a.
Form Wizard
c.
both a & b
b.
Report Wizard
 

 19. 

Database view that is used to view, edit, add and delete records.
a.
SQL View
c.
Datasheet View
b.
Design View
 

 20. 

An option that allows you to modify the design of a form.
a.
Layout View
c.
Form View
b.
Datasheet View
 



 
         Start Over