Name:     ID: 
 
Email: 

Microsoft Access Database Terms

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

 1. 

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
 

 2. 

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

 3. 

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

 4. 

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

 5. 

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
 

 6. 

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

 7. 

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

 8. 

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

 9. 

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

 10. 

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
 

 11. 

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

 12. 

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

 13. 

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
 

 14. 

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

 15. 

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

 16. 

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
 

 17. 

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

 18. 

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

 19. 

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
 

 20. 

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



 
         Start Over