Name:     ID: 
 
Email: 

UNIT 4 Database Development Assessment

True/False
Indicate whether the statement is true or false.
 

 1. 

(1 point) A question that you ask about the data in your database is known to be query object.
 

 2. 

(1 point) A record is made up of lots of individual pieces of information.
 

 3. 

(1 point) Database forms are computerized versions of paper forms, such as a patient record, job application or a class registration form.
 

 4. 

(1 point) To save changes in the database, you must save the objects individually.
 

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

 5. 

(1 point) A _________ is a collection of data or information which is held together in an organized or logical way.
a.
database
c.
wordprocessor
b.
spreadsheet
d.
query
 

 6. 

(1 point) A group of database tables that is connected or linked by a defined relationship.
a.
Relational database
c.
Query object
b.
Relationship
d.
None of the above.
 

 7. 

(1 point) The following table has more than 100 records. You want to change all the instances of the phrase “Half-Dozen”  to “Baker’s Dozen”. What’s the fastest way to do this?

mc007-1.jpg

a.
Sort the Sales Unit field, scroll to Half-Dozen, then use copy and paste
c.
Retype the records
b.
Use the Find and Replace feature
d.
Apply a filter to the Sales Unit field, then retype the records.
 

 8. 

(1 point) Why would you want to create a report?
a.
Reports make it easy to add records to a table.
c.
Reports allow you to present tables and query results in an easy-to-read format.
b.
Reports are used to add data collection fields to forms.
d.
Reports allow you to export a table as an Excel file.
 

 9. 

(1 point) Suppose you created the following query, but later you realize that you really wanted to find the total number of cakes sold instead of cookies. What is the best way to solve this problem?
mc009-1.jpg

a.
Use the Find feature to search for Cake.
c.
Use a filter on the Product Type fie
b.
Delete the query and re-create it
d.
Switch to Design View and edit the criteria
 

 10. 

(1 point) Which is the valid data type in Access?
a.
Number
c.
Currency
b.
Text
d.
All of the above.
 

 11. 

(1 point) Which data type is better to use for storing the price of an item?
a.
Text
c.
Currency
b.
Number
d.
Autonumber
 

 12. 

(1 point) Which of the following data type is used to store picture in MS Access?
a.
Number
c.
Text
b.
OLE object
d.
Picture cannot be stored
 

 13. 

(1 point) Which of the following is NOT a type of MS Access database object?
a.
Queries
c.
Forms
b.
Workbooks
d.
Reports
 

 14. 

(1 point) What is label A?
mc014-1.jpg
a.
Database objects
d.
Field names
b.
Record
e.
Not Applicable
c.
Field
f.
Not Applicable
 

 15. 

(1 point) What is label B?
mc015-1.jpg
a.
Database objects
d.
Field names
b.
Record
e.
Not Applicable
c.
Field
f.
Not Applicable
 

 16. 

(1 point) What is label C?
mc016-1.jpg
a.
Database objects
d.
Field names
b.
Record
e.
Not Applicable
c.
Field
f.
Not Applicable
 

 17. 

(1 point) What is label D?
mc017-1.jpg
a.
Database objects
d.
Field names
b.
Record
e.
Not Applicable
c.
Field
f.
Not Applicable
 

 18. 

(1 point) Identify the datatype of the corresponding field name.

Item
Data Name
Example Date
(a)
Name
“Anthony Globe”
(b)
Height
1.90
(c)
Date of Birth
March 12, 1977
(d)
Phone No.
0123113320
(e)
Pay Rate
$30.00

What is Row A datatype?
a.
Number
d.
Date
b.
Text
e.
OLE object
c.
Currency
f.
None of the above.
 

 19. 

(1 point) Identify the datatype of the corresponding field name.

Item
Data Name
Example Date
(a)
Name
“Anthony Globe”
(b)
Height
1.90
(c)
Date of Birth
March 12, 1977
(d)
Phone No.
0123113320
(e)
Pay Rate
$30.00

What is Row B datatype?
a.
Number
d.
Date
b.
Text
e.
OLE object
c.
Currency
f.
None of the above.
 

 20. 

(1 point) Identify the datatype of the corresponding field name.

Item
Data Name
Example Date
(a)
Name
“Anthony Globe”
(b)
Height
1.90
(c)
Date of Birth
March 12, 1977
(d)
Phone No.
0123113320
(e)
Pay Rate
$30.00

What is Row C datatype?
a.
Number
d.
Date
b.
Text
e.
OLE object
c.
Currency
f.
None of the above.
 

 21. 

(1 point) Identify the datatype of the corresponding field name.

Item
Data Name
Example Date
(a)
Name
“Anthony Globe”
(b)
Height
1.90
(c)
Date of Birth
March 12, 1977
(d)
Phone No.
0123113320
(e)
Pay Rate
$30.00

What is Row E datatype?
a.
Number
d.
Date
b.
Text
e.
OLE object
c.
Currency
f.
None of the above.
 

 22. 

(1 point) It is an access interface element that organizes and lists the database objects.
a.
Navigation Pane
c.
Backstage view
b.
Ribbon tab
d.
None of the above
 

Multiple Response
Identify one or more choices that best complete the statement or answer the question.
 

 23. 

(4 points) Give the main 4 database objects
 a.
Columns
 e.
Database
 b.
Table
 f.
Form
 c.
Rows
 g.
Query
 d.
Report
 h.
Relationships
 

 24. 

(2 points)
Let's say our bakery wants to create a list of customer names and email addresses for customers who pre-ordered an item and picked it up during the month of December. The tables needed for the query are shown below. Aside from First Name and Last Name, what fields must be added to the query? Check all that apply.
mr024-1.jpg
 a.
Pre Order
 d.
Zip Code
 b.
Email
 e.
City
 c.
Pick up Date
 f.
Paid
 

Completion
Complete each statement.
 

 25. 

(1 point) A _________ is all the data or information about one person or one thing.
 

 

 26. 

(1 point) Forms, queries, and reports objects are created based on the information in the ________.
 

 

 27. 

(1 point) The ________   ______ is used to identify each record in the table with a number.
 

 

 28. 

(1 point) A system for managing data that allow users to store, retrieve and analyze information. Write the complete name. ________  ____________  __________
 

 

 29. 

(1 point) A ___________ is a database object that simplifies the process of entering, entering and displaying data.
 

 

 30. 

(1 point) A __________ is a database object that presents information in a format that is easy to read and print.
 

 



 
         Start Over