You work as a Database Designer for Tech Perfect Inc. The company has Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer contains a database named
Products created in Microsoft Office Access 2010. You want to add an Access template to the
database in order to extend its functionality. Which of the following Access templates will you use to
accomplish the task?
A.
Northwind
B.
Assets Web Database
C.
Tasks
D.
Application part
Explanation:
In order to accomplish the task, you should use the application part. An application part is a
template available in Microsoft Office Access 2010. It can be added to an existing database. It is used
to extend the functionality of an Access database. It can include only a single table or a number of
database objects, such as tables, forms, reports, and even relationships. A user can open up the
Application Parts gallery in order to view the built-in parts.
Answer B is incorrect. The Assets Web Database template keeps track of assets. It also classifies and
records the status of assets.
Answer A is incorrect. The Northwind template creates an order tracking system that organizes
customers, employees, order details, and inventory.
Answer C is incorrect. The Tasks template tracks a group of work items that need to be completed.
An Application Part is a type of template that lets you quickly add new objects to an Access database. Any objects or data that you can put in an Access database can be saved as an Application Part, allowing for easy reuse of objects that you use frequently.