Microsoft MS Access 2010 - 77-885 FREE EXAM DUMPS QUESTIONS & ANSWERS
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a number of projects. You are required to create a table in Microsoft Office Access 2010 for tracking all projects that are required to be completed. Mark the option that you will choose to accomplish the task.
Correct Answer:
Explanation:
In order to accomplish the task, you should choose the Tasks option. It is available in the Quick Start category as shown in the image given below:
The Tasks option is used to track various tasks and projects that are required to be completed. This option creates a Tasks table and two forms. Key fields of this table have start and due dates for the task and percentage of task completed.
Choose and reorder the steps that you will take to create a database using a template in Microsoft Office Access 2010.
Correct Answer:
1 - Open Microsoft Office Access 2010.
2 - Click the File tab.
3 - Click the New button.
4 - Click a template category.
5 - Choose the template.
6 - Type a name for the database.
7 - Click the Download button.
Explanation:
1.Open Microsoft Office Access 2010.
2.Click the File tab and then click the New button.
3.Click a template category.
4.Choose the template.
5.Type a name for the database and then click the Download button.
You work as a Database Designer for Tech Perfect Inc. The company has a Windows-Vista based computer with Microsoft Office 2010 installed on it. The company uses a Microsoft Office 2010 database named HumanResource. The database contains a table named Employees. You want to define a set of rules for table's column so that the no one can enter invalid data in the table. Which of the following table properties will you use to accomplish the task?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named SalaryData created in Microsoft Office Access 2010. This database has a report named SalaryReport. You have to determine bonuses based on a percentage of sales and display it in the report. For this, you want to insert an arithmetic expression in the report. Mark the tab/button that you will use to accomplish the task.
Correct Answer:
Explanation:
You are working on a home computer with Microsoft Office 2010 installed on it. You want to always open Microsoft Office Access 2010 with the database that you used the last time. Which of the following Access options will you choose to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Which of the following macro options allows MS Access to disable all macros and does not display any security warnings for enabling them?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Where can a user add any Access command as a button in Microsoft Access 2010?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to create a blank report in the Design view. Which of the following tools will you use to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).