[Free] 2018(Aug) Ensurepass Microsoft 77-605 Dumps with VCE and PDF 61-70

Ensurepass.com : Ensure you pass the IT Exams
2018 Aug Microsoft Official New Released 77-605
100% Free Download! 100% Pass Guaranteed!

MOS: Using Microsoft Office Access 2007

Question No: 61

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named Employees. You have to add and delete some records in the table according to your requirement. Which of the following views can you use to accomplish this task?

  1. Design

  2. Datasheet

  3. Table

  4. Pivot Chart

Answer: B

Question No: 62

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Sales. The database contains several tables. James wants to ensure that a tablenamed SalesInfo will be displayed as PivotChart. Which of the following properties of the table will he modify to accomplish the task?

  1. Default View

  2. Format

  3. ivotChart View

  4. Orientation

Answer: A

Explanation: In order to accomplish the task, James will use the Default View property. This property contains three settings, which are as follows: Datasheet PivotTable

PivotChart The default setting is Datasheet. James will change the setting to the PivotChart to change the display of the table.

Question No: 63

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Human Resource. The database contains several forms, tables and queries. James has to manually create a report that will display records from EmpDept query, which contains the names of employees in the EmpName column and their concerning departments in the DeptName column. James creates a TextBox control. He has to bind the TextBox to the EmpName property. Which of the following properties will he use to accomplish the task?

  1. RowSource

  2. ControlSource

  3. TableSource

  4. RecordSource

Answer: B

Explanation: In order to accomplish the task, James will use the ControlSource property. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control. Answer: D is incorrect. The RecordSource property belongs to the form and report controls. This property is used to connect a form or report to a table or query. After setting the RecordSource property, a user can use the ControlSource property to bind the controls of a form or report. The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property. Answer: A is incorrect. RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. Answer: C is incorrect. There is no such property as TableSource.

Question No: 64

Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses a Microsoft Office Access 2007 database named Human Resource, which contains several tables. Peter has to create a form to display employee details. He creates a TextBox and binds it to a field of the Employees table. He finds that he is unable to populate any recordset from a query. Which of the following is the most likely cause of the issue?

  1. The Format property of the TextBox is not set.

  2. The RecordSource property of the form is not set.

  3. The RowSource property of the TextBox is not set.

  4. The Validation Rule property of the form is not set.

Answer: B

Explanation: In order to bind the Textbox to a field of the Employee table, Peter should set the ControlSource Property of the TextBox. The ControlSource property of a control (TextBox, Comboboc, etc.) does not populate any recordset from a query if the RecordSource property of the form is not set. The RecordSource property of a form should be set to a table in the current database to populate the ControlSource property with the fields of the table. Answer: A is incorrect. If the format property of a TextBox control is not set, the ControlSource property is not affected. Answer: C is incorrect. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. Answer: D is incorrect. A validation rule is a set of rules associated with a column so that a user is restricted from entering invalid data. A user can be restricted from entering data through the following options: Datatypes: When a field is assigned to a datatype, data of another type cannot be inserted in the field. Field size: The field size restricts the amount of data to be inserted in a table. Table Properties: Certain table properties such as Required forces a user to enter data or the Format property forces a user to enter data in a defined format. A validation rule can be applied by using the Validation Rule property. A user can be intimated about the invalid data through the Validation Text property.

Question No: 65

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses

Microsoft Office Access 2007 database named Human Resource. The database contains a table named Employees. James has to create a form with a calculated control. The calculated control will calculate the monthly salary of the employees. Which of the following controls will James use to accomplish the task?

  1. ComboBox

  2. TextBox

  3. Label

  4. ListBox

Answer: B

Explanation: In order to accomplish the task, James will use the TextBox control. A TextBox control is an editable control in which a user can edit and modify data. It is of the following types: Unbound: An unbound textbox control is an empty control. It is not bound to any column of any table. It can be bound to a column by using the ControlSource property. Bound: A bound textbox control is bound to a column of a table. It displays a single record of the column. Calculated: It can be used for calculations based on the expression provided in the textbox. Answer: D and A are incorrect. The list box and combo box controls are used to display all the items of one of more fields. These controls can be bound to a table by using the control wizard (Combo Box Wizard and List Box Wizard). The list box and combo box controls can also be bound to an individual column by using the ControlSource property. In this case only one value will be displayed at a time. To display all the values of a column, a user should bind the list box control to the RowSource property. Answer: C is incorrect. The label control does not have the ControlSource property. So it can neither be bound to any column of any table nor used as a calculated control. A label control is used to provide a name to a bound control.

Question No: 66

Which of the following will you use to create a detailed report containing enough information to rebuild the database structure?

  1. Performance Analyzer

  2. Database Documenter

  3. Compact and Repair Database

  4. Microsoft Office Diagnostics

Answer: B

Explanation: In order to create a report that contains enough information to rebuild the database structure, you should use the Database Documenter tool. It contains all information about the Microsoft Access objects such as tables, reports, macros, modules, forms, and queries in a database. A user can open this report in the Print Preview. Answer: A is incorrect. The Performance Analyzer utility is used to analyze the performance of the Microsoft Office Access objects such as tables, forms, macros, modules, reports, and queries in the database. This utility has three types of analysis results: ideas, suggestions, and recommendations. The user can instruct Access to optimize the database file by following through on any of the suggestions and recommendations.

Answer: C is incorrect. The Compact and Repair Database utility optimizes the performance of access files by rearranging how the file is stored on the hard disk and then attempts to remove the issues in tables, forms, reports, and modules. A user should use the Compact and Repair Database utility on a regular basis to ensure optimal performance. If a major problem occurs while user is working in an Access file and Access attempts to recover it, the user will receive a message that the repair operation is cancelled and he should compact and repair the file. Answer: D is incorrect. The Microsoft Office Diagnostics utility has a series of diagnostic tests that helps a user to discover why the Microsoft Office programs are not working properly. The diagnostic tests provide the information about the problems, and ways to solve these problems. When Microsoft Office Diagnostics determines that data might help diagnose and fix a problem, the system asks the user whether he wants to tell the problem to the Microsoft. After completing all the tests, the user prompts to visit a Web page in order to get advice based the results of the tests.

Question No: 67

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named Employees with the following fields: Employee Name Employee ID Department Salary You want to view a list of fields in the table. In which of the following views will you open the table?

  1. Layout

  2. Datasheet

  3. Pivot Table

  4. Design

Answer: D

Question No: 68

Which of the following sections of the Report Design view is used to print a distribution list, accounting information, or to identify information that is required for the report?

  1. Detail

  2. Page Header

  3. Report Header

  4. Page Footer

Answer: C

Explanation: Report Header is an optional section of the Report Design view. It is used to print a distribution list, accounting information, or to identify information that is required for the report. Answer: B is incorrect. Page Header is displayed at the top of each page. It includes a logo, column heading, page number, etc. Answer: A is incorrect. The Detail section displays the data and their associated labels that are included for the table or query fields added to the report. Answer: D is incorrect. Page Footer is displayed at the bottom of each page. It includes a report name, date and time, coding, page number, etc.

Question No: 69

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Sales. The database contains several tables, queries, forms, and reports. The database is locked by a user by saving it in .accdr format. Andrew has to unlock the database so that all the database objects can be modified. Which of the following actions will he take to accomplish the task?

  1. Click the Office button and save the database to .accdb format.

  2. In Windows Explorer, change the extension of the database to .accdt.

  3. In Windows Explorer, change the extension of the database to .accdb.

  4. In Windows Explorer, change the extension of the database to .accde.

Answer: C

Explanation: In order to accomplish the task, Andrew will change the extension of the

.accdr file to .accdb file. After changing the extension, Andrew can create, modify, or delete database objects. Answer: A is incorrect. If a database is saved in .accdr format, the save option is not available in the office button. Answer: D and B are incorrect. Changing the extension to either .accde or .accdt will not accomplish the task. In a .accde file a user cannot modify forms and reports. If the extension is converted to .accdt, invalid format error is displayed and database does not open.

Question No: 70

Which of the following types of Microsoft Access object is described in the statement below? quot;It is a Microsoft Access object used to display specific fields from one or more tables so that the users can view, change, or analyze it in various ways. The users can design it to perform calculations such as sum, average, count, and can save this query for future use.quot;

  1. Table

  2. Report

  3. Form

  4. Query

Answer: D

Explanation: A query is a Microsoft Access object used to display data from one or more tables so that users can view, change, or analyze it in various ways. The users can design a query to perform calculations such as sum, average, count and can save the query for future use. The queries can be viewed in the Datasheet view or Design view.

The common types of queries in Ms Access are as follows: Select query

Duplicate query Unmatched query Parameter query Crosstab query

Action query

Answer: A is incorrect. A table is the basic element of a database used to store data. All other objects such as indexes, functions, forms, reports, etc., are based on the table.

Without a table, a database is of no use. Tables can be used to create queries. These queries can retrieve data from one or more tables which are related to one another.

Answer: C is incorrect. A form is a window in which administrator can place controls that either provide information to the users or accept information that the users enter. Form provides an easy way to enter, retrieve, display and print information stored in tables. A user can view forms in Form view, Datasheet view, or Design view. Answer: B is incorrect. Report is a Microsoft Access object used to display information from the tables in a nicely formatted and easily accessible way. The information can be displayed on computer screen or on paper. A report can contain information from multiple tables and queries, values calculated from information in the database, and formatting elements such as headers, footers, titles, and headings. A user can view reports in Design view, Print view, and Layout view. A user cannot edit data in a report.

100% Ensurepass Free Download!
77-605 PDF
100% Ensurepass Free Guaranteed!
77-605 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No


Leave a Reply

Your email address will not be published. Required fields are marked *

  • Categories

  • Tags

  • Hot Exams

  • Hot Exams

  • Hot Catageories

  • microsoft dumps

    62-193 Dumps
    70-243 Dumps
    70-246 Dumps
    70-247 Dumps
    70-331 Dumps
    70-332 Dumps
    70-333 Dumps
    70-334 Dumps
    70-339 Dumps
    70-341 Dumps
    70-342 Dumps
    70-345 Dumps
    70-346 Dumps
    70-347 Dumps
    70-348 Dumps
    70-354 Dumps
    70-355 Dumps
    70-357 Dumps
    70-383 Dumps
    70-384 Dumps
    70-385 Dumps
    70-398 Dumps
    70-410 Dumps
    70-411 Dumps
    70-412 Dumps
    70-413 Dumps
    70-414 Dumps
    70-417 Dumps
    70-461 Dumps
    70-462 Dumps
    70-463 Dumps
    70-464 Dumps
    70-465 Dumps
    70-466 Dumps
    70-467 Dumps
    70-469 Dumps
    70-470 Dumps
    70-473 Dumps
    70-475 Dumps
    70-480 Dumps
    70-481 Dumps
    70-482 Dumps
    70-483 Dumps
    70-484 Dumps
    70-485 Dumps
    70-486 Dumps
    70-487 Dumps
    70-488 Dumps
    70-489 Dumps
    70-490 Dumps
    70-491 Dumps
    70-492 Dumps
    70-494 Dumps
    70-496 Dumps
    70-497 Dumps
    70-498 Dumps
    70-499 Dumps
    70-517 Dumps
    70-532 Dumps
    70-533 Dumps
    70-534 Dumps
    70-535 Dumps
    70-537 Dumps
    70-640 Dumps
    70-642 Dumps
    70-646 Dumps
    70-673 Dumps
    70-680 Dumps
    70-681 Dumps
    70-682 Dumps
    70-684 Dumps
    70-685 Dumps
    70-686 Dumps
    70-687 Dumps
    70-688 Dumps
    70-689 Dumps
    70-692 Dumps
    70-694 Dumps
    70-695 Dumps
    70-696 Dumps
    70-697 Dumps
    70-698 Dumps
    70-703 Dumps
    70-705 Dumps
    70-713 Dumps
    70-734 Dumps
    70-735 Dumps
    70-740 Dumps
    70-741 Dumps
    70-742 Dumps
    70-743 Dumps
    70-744 Dumps
    70-745 Dumps
    70-761 Dumps
    70-762 Dumps
    70-764 Dumps
    70-765 Dumps
    70-767 Dumps
    70-768 Dumps
    70-773 Dumps
    70-774 Dumps
    70-775 Dumps
    70-776 Dumps
    70-778 Dumps
    70-779 Dumps
    70-980 Dumps
    70-981 Dumps
    70-982 Dumps
    74-343 Dumps
    74-344 Dumps
    74-409 Dumps
    74-678 Dumps
    74-697 Dumps
    77-418 Dumps
    77-419 Dumps
    77-420 Dumps
    77-421 Dumps
    77-422 Dumps
    77-423 Dumps
    77-424 Dumps
    77-425 Dumps
    77-426 Dumps
    77-427 Dumps
    77-428 Dumps
    77-600 Dumps
    77-601 Dumps
    77-602 Dumps
    77-603 Dumps
    77-604 Dumps
    77-605 Dumps
    77-725 Dumps
    77-726 Dumps
    77-727 Dumps
    77-728 Dumps
    77-729 Dumps
    77-730 Dumps
    77-731 Dumps
    77-853 Dumps
    77-881 Dumps
    77-882 Dumps
    77-883 Dumps
    77-884 Dumps
    77-885 Dumps
    77-886 Dumps
    77-887 Dumps
    77-888 Dumps
    77-891 Dumps
    98-349 Dumps
    98-361 Dumps
    98-362 Dumps
    98-363 Dumps
    98-364 Dumps
    98-365 Dumps
    98-366 Dumps
    98-367 Dumps
    98-368 Dumps
    98-369 Dumps
    98-372 Dumps
    98-373 Dumps
    98-374 Dumps
    98-375 Dumps
    98-379 Dumps
    98-380 Dumps
    98-381 Dumps
    98-382 Dumps
    98-383 Dumps
    98-388 Dumps
    AZ-100 Dumps
    AZ-101 Dumps
    AZ-102 Dumps
    INF-203x Dumps
    INF-204x Dumps
    INF-205x Dumps
    INF-206x Dumps
    MB2-700 Dumps
    MB2-701 Dumps
    MB2-702 Dumps
    MB2-703 Dumps
    MB2-704 Dumps
    MB2-706 Dumps
    MB2-707 Dumps
    MB2-708 Dumps
    MB2-709 Dumps
    MB2-710 Dumps
    MB2-711 Dumps
    MB2-712 Dumps
    MB2-713 Dumps
    MB2-714 Dumps
    MB2-715 Dumps
    MB2-716 Dumps
    MB2-717 Dumps
    MB2-718 Dumps
    MB2-719 Dumps
    MB2-877 Dumps
    MB5-705 Dumps
    MB6-700 Dumps
    MB6-701 Dumps
    MB6-702 Dumps
    MB6-703 Dumps
    MB6-704 Dumps
    MB6-705 Dumps
    MB6-884 Dumps
    MB6-885 Dumps
    MB6-886 Dumps
    MB6-889 Dumps
    MB6-890 Dumps
    MB6-892 Dumps
    MB6-893 Dumps
    MB6-894 Dumps
    MB6-895 Dumps
    MB6-896 Dumps
    MB6-897 Dumps
    MB6-898 Dumps