Name:     ID: 
 
Email: 

Microsoft Access Database Terms

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

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

 2. 
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
 

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

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

 5. 
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
 

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

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

 8. 
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
 

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

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

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

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

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

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

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

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

 17. 
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
 

 18. 
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
 

 19. 
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
 

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



 
         Start Over