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

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: 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 2018 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% 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