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?
Correct Answer: D
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 47
James works 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 Accounts and two tables named Table1 and Table2, which are created in Microsoft Office Access 2010. James wants to apply referential integrity to establish a relationship between these tables. Which of the following are required to accomplish the task? Each correct answer represents a part of the solution. Choose three.
Correct Answer: A,B,C
The following are required for establishing referential integrity between two tables: The common field is the primary key of the primary table. The related fields contain the same format. Both tables are related to the same database. Answer D is incorrect. In order to establish referential integrity, it is required that both tables have the same format.
Question 48
Which of the following is located along the left side of the Access screen and provides an interface for all database objects?
Correct Answer: A
The Navigation Pane provides an interface for all database objects, such as tables, queries, forms, reports, macros, and modules. It is located along the left side of the Access screen. In the Navigation Pane, all items are organized into groups. It is also used to show or hide the database objects. Answer B is incorrect. The Quick Access Toolbar in MS Access 2010 is a customizable toolbar which is displayed in the title bar of the Database window. It has a set of commands or functions (save, undo/redo, and print) that are independent of the tab on the ribbon currently displayed in MS Access. The Quick Access Toolbar can be moved from one of the two possible locations. A user can add any Access command as a button to the Quick Access Toolbar. Answer C is incorrect. The Object Dependencies pane is available on the Relationships group in the Database Tools tab. It demonstrates the interactions or dependencies of all database objects. It helps in preventing record sources from being accidentally deleted. It also displays how other objects are affected by the design change whenever any change is made in the design of an object. Answer D is incorrect. 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.
