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 11-20

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

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: 11

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 Microsoft Office Access 2007 database named Human Resource. The database contains a table named Employees. He wants to help users to select an employee name while filling a form.. Which of the following controls will he use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

  1. Combobox

  2. Listbox

  3. Textbox

  4. Label

Answer: A,B

Explanation: In order to accomplish the task, Peter will use the listbox and the combobox controls. When these controls are bound to a column of a table, all the data of that column is displayed in these controls. A user cannot edit or delete the data from these controls. He

can only view the data. Answer: C is incorrect. The textbox control is bound to a column but it displays one record at a time. According to the scenario, Peter wants to ensure that all the names of the employees should be displayed, the textbox control will not accomplish the task. Answer: D is incorrect. The label control does not have ControlSource property.

So it cannot be bound to any column of any table. A label is used to provide a name to a bound control.

Question No: 12

You are working on the Date/Time datatype of MS Office Access 2007. You want to add a number to the interval component of the date to yield a new date value. Which of the following functions will you use for this task?

  1. DatePart(interval, date)

  2. DateAdd(interval, number, date)

  3. DateDiff(interval, date1, date2)

  4. Date()

Answer: B

Explanation: The DateAdd(interval, number, date) function is used to adjust a specific date by adding a new integer to a Date/Time component. The number added to the interval component of the date yields a new date value.

Question No: 13

Andrew works as a Database Designer for Access Soft 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. Andrew has to set a Default Value for a column named OrderDate in a table named Orders. Which of the following views of the table will Andrew use to accomplish the task?

  1. PivotTable

  2. Datasheet

  3. PivotChart

  4. Design

Answer: D

Question No: 14

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 computer contains a database named Human Resource created in Microsoft Office Access 2007. The database contains several tables. Andrew has to create a form for a table named Employee. He wants to ensure that the data of a table should be visible in the form as well as in the datasheet. He wants to create the form in the minimum possible time. Which of the following tools will he use to accomplish the task?

  1. Form Design

  2. Blank Form

  3. Split Form

  4. Form

Answer: C

Explanation: In order to accomplish the task, Andrew will use the Split Form tool. In this tool, all the fields in the form will automatically be mapped to the fields of the table and the table will be split in two parts showing the form and the datasheet view simultaneously.

Question No: 15

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 computer contains a database named Human Resource created in Microsoft Office Access 2007. The database contains a table named Employees. The table contains a field named Resume, which is set to the Attachment datatype. Peter has to convert the database to the format of Microsoft Access 2003. What will happen when Peter tries to accomplish this task?

  1. The database will be successfully converted to the .mdb file.

  2. The database will be successfully converted to the .mdb file but Resume field will be deleted as older version does not support the Attachment datatype.

  3. The database will be successfully converted to the .mdb file but Resume field will be set

    to the OLE Object datatype.

  4. An error will occur and no conversion will take place.

Answer: D

Explanation: When a Microsoft Office Access 2007 database is to be converted to the Microsoft Access 2003, an error will be generated and the conversion will not take place if a table contains multi-valued feature and the Attachment datatype. The multi-valued feature and the Attachment datatype are not supported by Microsoft Access 2003. To complete the task successfully, Peter will have to remove the Resume field from the Employees table.

Question No: 16

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. The table contains several fields. James sets the Address field to Memo datatype and the name of the city to bold. Now he creates a form.

What will happen when the Address field is displayed in the form?

  1. It will generate an error.

  2. The Address field will be added to the form and the data will be displayed as plain text.

  3. The Address field will be added to the form but no data will be displayed.

  4. The Address field will be added to the form and the data will be displayed same as in the table.

Answer: D

Explanation: When James adds the Address field to the form the data will be displayed in the same format as it is in the table. According to the scenario, the field has been formatted in the table. Since the form#39;s control is connected to the Address field, it will display the data in the same format as it is in the table. Similarly, if any changes are made in the form, the changes will also be reflected in the table.

Question No: 17

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 Microsoft Office Access 2007 database named Human Resource. The database contains several tables and queries. Peter creates a query named EmpDept, which is connected to the Employee and the Department table. It displays the name of an employee and his concerning department. The structure of the query is given in the image below.

Ensurepass 2017 PDF and VCE

When Peter opens the query, he finds incorrect results. Now, he wants to delete the query. When he tries to delete the query, an error is generated. Which of the following is the most likely cause of the error?

  1. The query is connected to the Employees and Department tables

  2. The query is opened in Datasheet View

  3. The query does not have the primary key column

  4. The query displays incorrect results

Answer: B

Explanation: The cause of the error is that the query is opened in the Datasheet view. When a query is opened in Design View, Datasheet View, or Layout View, it cannot be deleted. In order to delete the query all the views must be closed. Answer: A is incorrect. A query can be deleted successfully when it is connected to two or more tables. Answer: D is incorrect. A query can be deleted successfully whether it shows correct or incorrect results.

Answer: C is incorrect. A query can be deleted successfully whether or not it contains the primary key.

Question No: 18

You are working with Microsoft Office Access 2007. You want to change the macro settings in the Trust Center for the Access 2007 program. Which of the following options will you choose to make your computer system vulnerable to potentially malicious code?

  1. Disable all macros without notification.

  2. Disable all macros with notification.

  3. Disable all macros except digitally signed macros.

  4. Enable all macros.

Answer: D

Explanation: The Enable all macros option allows all macros to run. This option is not recommended and makes the computer system vulnerable to potentially malicious code.

Question No: 19

You work 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 Access1, which is created in Microsoft Access 2007. You have split the database in order to improve the performance. Which of the following information is distributed to the users accessing this database?

  1. Back-end database

  2. Entire database

  3. .mdb file

  4. Front-end database

Answer: D

Explanation: After splitting a database, you will get the following two databases: 1.Front- end database 2.Back-end database The front-end database contains the data and it is

distributed to the users. Answer: A is incorrect. The back-end database is not distributed to the users. It contains formatting elements, such as queries, forms, and reports. Answer: B and C are incorrect. The entire database and .mdb file are not distributed to the users.

Question No: 20

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 computer has a database named Sales created in Microsoft Office Access 2007. Peter has to create a table named user, which will contain two fields as follows: UserID Password Peter wants to ensure that data in the Password field will be displayed in the form of *. Which of the following properties will Peter use to accomplish the task?

  1. Input Mask

  2. Validation Text

  3. Format

  4. Caption

Answer: A

Explanation: In order to accomplish the task, Peter will use the Input Mask property. The Input Mask property is used to change the format of a field having the Text or Date/Time datatype. This property provides the formats for different types of data such as zip-code, phone, date, time, password etc. When the Input Mask property is set for a field, a user should fill the data in the same format. Any other format is either converted to the given format or remains as it is. Answer: C is incorrect. The Format property is used to change the format of the fields having Number, Date/Time, Currency, Yes/No datatypes. It does not work on the Text datatype so the field assigned to the Text datatype cannot be formatted.Answer: D is incorrect. The value of the Caption property is displayed as text on a Label control in a Form.Answer: B is incorrect. The Validation Text property is used to provide an error to a user if data has not been filled as per the Validation Rule.

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 21-30
[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 1-10

Name of author

Name: admin