Braindumps Microsoft MCSD Dumps

70-410,70-411,70-412,70-413,70-414,70-417,70-461,70-462,70-463,70-464,70-465,70-480,70-483,70-486,70-487

Home » [Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 61-70

[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 61-70

EnsurePass
2017 Sep Microsoft Official New Released 77-605
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/77-605.html

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% Free Download!
Download Free Demo:77-605 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass 77-605 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 71-80
[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 51-60

Name of author

Name: admin