最新的Microsoft MS Access 2010 - 77-885免費考試真題
James works as a Database Designer for Tech Perfect Inc. He wants to prevent the Navigation Pane from appearing by default in Microsoft Office Access 2010. Which of the following steps will James take to find the option for this task?
正確答案: C
說明：（僅 Fast2test 成員可見）
Where can a user add any Access command as a button in Microsoft Access 2010?
正確答案: A
說明：（僅 Fast2test 成員可見）
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 Database1 created in Microsoft Office Access 2010. The database includes two tables named Table-A and Table-B. You want to divide Table-A with many columns and isolate a part of Table-A for security reasons. Which of the following types of relationship will you create between both tables to accomplish the task?
正確答案: A
說明：（僅 Fast2test 成員可見）
Choose and re-order the steps that you will take to create a report based on the Staffs table in Microsoft Office Access 2010.
正確答案:
1 - In the Navigation pane, click the Staffs table.
2 - Click the Create tab.
3 - Click the Report tool.
4 - Click the Save button.
5 - Type a name for the report.
6 - Click the OK button.
Explanation:
Take the following steps to create a report in Microsoft Office Access 2010:
In the Navigation pane, click the table that is required to be used in the report.
Click the Create tab.
You work as a Database Developer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to create a form that allows users to browse to different forms and reports created in Microsoft Office Access 2010. Mark the button that you will choose to accomplish the task.
正確答案:
Explanation:
In order to accomplish the task, you should choose the Navigation button in the Forms group. It allows a user to browse to different forms and reports created in Microsoft Office Access 2010. The Navigation button has various options as shown in the image given below:
You have a form named Annexure-1 created in Microsoft Office Access 2010. You have to split a cell horizontally into two smaller cells. The cell has a control. You want the control to be moved to the left cell of the two resulting cells. Which of the following steps will you take to accomplish the task?
正確答案: A
說明：（僅 Fast2test 成員可見）
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?
正確答案: B
說明：（僅 Fast2test 成員可見）
James works as a Database Designer for Tech Perfect Inc. He has to create a query that will extract the name and address of each customer who has made more than one order. Which of the following Query wizards should he use to accomplish the task?
正確答案: D
說明：（僅 Fast2test 成員可見）
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.
正確答案:
Explanation:
