Free Microsoft 77-885 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 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.  One-to-many relationship
• B.  Container managed relationship
• C.  One-to-one relationship
• D.  Many-to-many relationship

Which of the following are the ways to create a join between two tables in Microsoft Access 2010?
Each correct answer represents a complete solution. Choose all that apply.

• A.  Modify the default join behavior.
• B.  Select two tables for the query that have a field in common.
• C.  Create relationships between the tables while designing the database.
• D.  Use the Object Dependencies pane available on the Relationships group.

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 Order1 created in Microsoft Office Access 2010. You want to open the database in shared mode so that all users can insert, modify, and delete data from the database. In which of the following modes will you open the database to accomplish the task?

• A.  Open exclusive read-only
• B.  Open read-only
• C.  Open exclusive
• D.  Open

You work as a Database Designer for Tech Perfect Inc. The company has 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 want to add an Access template to the database in order to extend its functionality. Which of the following Access templates will you use to accomplish the task?

• A.  Assets Web Database
• B.  Northwind
• C.  Tasks
• D.  Application part

Mark the option that you will choose to adjust control height and width for the font of the text of your Access object.

Correct Answer:

Explanation:
To Fit: It is used to adjust control height and width for the font of the text.
To Tallest: It is used to make selected controls the height of the tallest selected control.
To Shortest: It is used to make selected controls the height of the shortest selected control.
To Grid: It is used to move all sides of selected controls in or out to meet the nearest point on the grid.
To Widest: It is used to make selected controls the width of the widest selected control.
To Narrowest: It is used to make selected controls the height of the narrowest selected control.