Source
Print direction
Maximum records per page
Minimum Widow records
Column mode
第1题：
You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?（）
第2题：
You create a Web Form that contains a button named btnCancel that enables users to exit the page. When users click this button, validation must not occur. During testing you learn that clicking the Cancel button does not enable users to exit the page. You need to ensure that users can always exit the page. What should you do? （）
第3题：
You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.
A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.
After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.
You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.
What should you do?
A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.
B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.
C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.
D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
第4题：
The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（）
第5题：
You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?（）
第6题：
You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）
第7题：
You are the desktop administrator for your company's sales department. The IT manager for the sales department needs to distribute three custom applications to the department's Windows XP Professional computers. She deploys these applications by using Group Policy. Some users report that they must log on several times before the newly deployed applications are present on their computers. You need to ensure that all software is deployed the next time the users log on. What should you do?（）
第8题：
Your network contains a Windows Server Update Services (WSUS) server.You have an organizational unit (OU) named Sales. The Sales OU contains all of the computer objects for the sales department. You enable client-side targeting for the Sales OU and set the target group name to Sales-Computers.You restart a sales computer.You discover that the computer is not added to the Sales-Computer computer group in WSUS.You need to ensure that all sales computers are added to the Sales-Computers group.Which options should you configure?（）
A. Automatic Approvals
B. Computers
C. Personalization
D. Products and Classifications
第9题：
Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）
第10题：
Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?（）