Access-2010-(77-885).pdf - Microsoft 77-885 Access 2010 http\/killexams.com\/exam-detail\/77-885 QUESTION 126 Which of the following contextual tabs

Access-2010-(77-885).pdf - Microsoft 77-885 Access 2010...

This preview shows page 1 - 4 out of 9 pages.

77-885 Microsoft Access 2010
Image of page 1
QUESTION: 126 Which of the following contextual tabs consists of controls to select the initial layout of a form and the default positions of controls on the form? A. Page Setup B. Format C. Design D. Arrange Answer: D Explanation: The Arrange contextual tab is highly context sensitive. It consists of controls to select the initial layout of a form and the default positions of controls on the form. Answer: C is incorrect. The Design contextual tab is used to add new elements, change the header/footer, and apply themes to the form. Answer: B is incorrect. The Arrange tab has various layout options. Answer: A is incorrect. This contextual tab is not available on the form. QUESTION: 127 Which of the following are the benefits of specifying a primary key for a table in Microsoft Office Access 2010? Each correct answer represents a complete solution. Choose all that apply. A. MS Access restricts the data type, valid values, and range of possible values for columns in a table. B. MS Access ensures that each record consists of a value in the primary key field. C. MS Access improves the database performance. 131
Image of page 2
D. MS Access ensures that each value in the primary key field is unique. Answer: C, B, D Explanation: The various benefits of specifying a primary key for a table are as follows: MS Access improves the database performance by automatically generating an index for the primary key. MS Access ensures that each record consists of a value in the primary key field. MS Access ensures that each value in the primary key field is unique. Answer: A is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table. QUESTION: 128 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 contains a database named Products created in Microsoft Office Access 2010. You are adding the application part template to the database. You want to apply a setting that displays the template both in the Access Getting Started place and in the Application Parts Gallery. Which of the following actions will you take to accomplish the task?
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture