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

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

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 created in Microsoft Office Access 2007. The database contains a table named Employees. James splits the database and gives the name to the split database as SplitSales. The Employees table in the Sales database exists as a link whereas the actual Employee table will be migrated to the SplitSales database. What will happen in the Sales and SplitSales databases if James creates a new table named Department in the Sales database?

  1. A link of the Department table will be created in the Sales database and the actual table will be created in the SplitSales database.

  2. A link of the Department table will be created in the SplitSales database and the actual table will be created in the Sales database.

  3. The Department table will be created in the SplitSales database and nothing will happen in the Sales database.

  4. The Department table will be created in the Sales database and nothing will happen in the SplitSales database.

Answer: D

Explanation: When the Sales database is split, the tables in the database will exist only as a link in the Sales database. The actual tables will be migrated to the other (SplitSales) database. If a table is created in the Sales database, it will not affect the other (SplitSales) database.

Question No: 32

You have two tables named table1 and table2 in your database, which is stored in Microsoft Office Access 2007. You have to perform the following tasks: Divide table1 with many columns. Isolate part of table1 for security reasons. Store information that applies only to a subset of table2

Which of the following relationships will you build between both tables?

  1. Many-to-many

  2. One-to-many

  3. Container managed

  4. One-to-one

Answer: D

Explanation: You have two tables named table1 and table2 in Microsoft Office Access 2007. In order to perform the given tasks, you will build a one-to-one relationship between both tables. This relationship provides functions to perform all these tasks.

Question No: 33

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office is installed. The computer contains a database named Sales that is created in Microsoft Access 2007. He has to create a table named Products. He wants to ensure that the Description field should accept rich text formatting. Which of the following datatypes will he use to accomplish the task?

  1. OLE Object

  2. Text

  3. Memo

  4. Attachment

Answer: C

Explanation: In order to accomplish the task, Andrew will use the Memo datatype. The Memo datatype stores alphanumeric values. These values can be numbers, alphabets, special characters such as lt;, gt;,?, etc. This datatype is used in place of the Text datatype. It can store 65,535 characters. It also accepts text with rich text format, paragraphs, descriptions, etc. Answer: B is incorrect. The Text datatype is used to store alphanumeric values. These values can be numbers, alphabets, special characters such as lt;, gt;, ?, etc. This datatype accepts values up to 255 characters. The number of characters can be limited to a fixed size by using the field size property. Answer: A is incorrect. The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.

Answer: D is incorrect. The Attachment datatype is used to attach one or more files in a column. The files can be an office 2007 file, an image file, a text file, or a log file. Other types of files cannot be attached to the column. A file can be edited using software that is used for editing the file. If the datatype of a column is Attachment, the datatype for that column cannot be changed.

Question No: 34

Which of the following features are considered as the preventive maintenance tasks for Microsoft Office Access 2007 databases? Each correct answer represents a complete solution. Choose three.

  1. Linked Table Manager

  2. Backup Database

  3. Compact and Repair Database

  4. Filter

Answer: A,B,C

Explanation: The following features are considered as the preventive maintenance tasks for Microsoft Office Access 2007: Backup: It makes copies of data to restore the original data after a loss event. Compact and Repair Database: It is used to perform routine maintenance of a database. Linked Table Manager: It lists the paths to all currently linked tables. Answer: D is incorrect. Filter is not a preventive maintenance tool. It is used to choose one or more of the current values in a table field to select records to display.

Question No: 35

Which of the following macros options are available in the Microsoft Office Access 2007 program? Each correct answer represents a complete solution. Choose all that apply.

  1. Trust access to the VBA project object model.

  2. Disable all macros with notification.

  3. Disable all macros except digitally signed macros.

  4. Disable all macros without notification.

  5. Enable all macros.

    Answer: B,C,D,E

    Explanation: The various macro options available in the MS Office Access 2007 are as follows:

    1. Disable all macros without notification: This option disables all macros and security alerts. The Disable all macros without notification option is used if macros are not digitally signed. The documents that are in trusted locations can run without being checked by the Trust center security system. It does not matter whether they are digitally signed or not.

    2. Disable all macros with notification: This is the default setting. The Disable all macros with notification option disables all macros and provides security alerts if the macros are present there.

    3. Disable all macros except digitally signed macros: This option allows digitally signed macros to run.

    4. Enable all macros: This option allows all macros to run. The Enable all macros option is not recommended and makes the computer system vulnerable to potentially malicious code. Answer: A is incorrect. This option is available in Microsoft Office Excel 2007.

      Question No: 36

      Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office Access 2007 installed on it. The computer has a database named Sales created in Microsoft Office Access 2007. Users use the database to store and retrieve sales data. The database is used to generate various kinds of reports. Peter wants to ensure that printing of blank reports should always be cancelled. Which of the following solutions will he adopt to accomplish the task?Each correct answer represents a complete solution. Choose two.

      1. Use VBA code

      2. Open the report in Layout view

      3. Use a button with the Cancel caption

      4. Use a macro.

Answer: A,D

Explanation: In order to accomplish the task, Peter will adopt one of the following solutions: Use a macro. Use a VBA code. In both cases, Peter will use the On No Data event of the Report object. When a user will open a blank report having no data, the On No Data event will fire and the report will not open. A user can open such reports in the design view only. Answer: C is incorrect. Using a button with the Cancel caption will not accomplish the task. Peter will have to build an event for the button to prevent the printing of reports. Answer: B is incorrect. Opening the report in the Layout View will not prevent the printing of blank report.

Question No: 37

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer that has Microsoft Office 2007 installed. The computer has a database named Sales. The database has two tables named Order and OrderDetails. Both the tables are joined by a column named OrderID. Andrew wants to retrieve data from both the tables such that all data is to be retrieved from the Order table and only matching rows from the OrderDetails table. If the data does not match, NULL should be inserted in the OrderDetails table. Which of the following queries will he use to accomplish the task?

  1. SELECT * FROM Order o CROSS JOIN OrderDetails od ON o.OrderID=od.OrderID

  2. SELECT * FROM Order o LEFT OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID

  3. SELECT * FROM Order o RIGHT OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID

  4. SELECT * FROM Order o FULL OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID

Answer: B

Explanation: In order to accomplish the task, Andrew will use the query having the LEFT OUTER JOIN clause. The query will retrieve all the data from the Order table, and only matching rows from the OrderDetails table. If the rows from the OrderDetails table do not match with the rows of the Order table, NULL is inserted in that row of the OrderDetails table. Answer: C is incorrect. The query will retrieve all the data from the OrderDetails table and matching rows from the Order table. If the rows from the Order table do not match with the rows of the OrderDetails table, NULL is inserted in that row of the Order table.

According to the scenario, all the rows from the Order table are to be retrieved. Therefore, the query should be written in the following way: SELECT * FROM OrderDetails o RIGHT OUTER JOIN Order od ON o.OrderID=od.OrderID Answer: D is incorrect. The FULL OUTER JOIN clause retrieves all rows from the left and right tables in a join expression, even if the data values in the joined columns do not match. Answer: A is incorrect. The CROSS JOIN clause produces the Cartesian product of the joined tables. The result set that is retrieved from the joined tables is the number of rows in the first table multiplied by the number of rows in the second table. The CROSS JOIN clause does not have the WHERE clause.

Question No: 38

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 Sales. James imports Contacts table into the current database, which already contains a table by the same name. Which of the following actions will take place in this scenario?

  1. The database will not import the table as a table with the same name already exists.

  2. The table will be imported successfully with a different name.

  3. The original table will be deleted.

  4. Only data of the table will be imported as a table with the same name already exists.

Answer: B

Explanation: If a table having the same name is imported from the other database into the current database, a new table is created with the same name followed by a number. For example, if Contacts table is imported from the other database into the current database, which already has a table with the same name, Contacts1 table will be created.

Question No: 39

James works as an Access Developer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer contains a database named Sales that is created in Microsoft Office Access 2007. The database contains a table named Orders. He has created a form to update data in the Orders table. He has written a Visual Basic code in which some variables are declared. He wants to check whether or not a variable has been initialized. Which of the following functions will he use to accomplish the task?

  1. IsNull()

  2. IsEmpty()

  3. IsMissing()

  4. IsIntialized()

Answer: B

Explanation: In order to accomplish the task, James will use the IsEmpty function. The

IsEmpty(expr) function is used to verify whether or not a variable is initialized. The expr argument is a required argument and is assigned to the variant datatype. If the variable is initialized, the function returns false; otherwise, it returns true. Answer: C is incorrect. The IsMissing(arg) function is used to verify whether or not an argument has been passed to a procedure. If an argument is passed, the function returns false; otherwise, it returns true. The argument is a variant datatype and is optional. If the function is used without an argument, it returns true. The IsMissing(arg) function does not work on simple datatypes, such as Integer and Double. Answer: A is incorrect. The IsNull(expr) function is used to verify whether or not an expression contains a Null value. The expr argument is a required argument and is assigned to the variant datatype. If an expression contains Null values, the function returns true; otherwise, it returns false. Answer: D is incorrect. There is no such function as IsInitialized() in Microsoft Office Access 2007.

Question No: 40

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 Sales. Peter exports sales data to an Excel file named SalesReport. While exporting the data, the Export wizard asks to replace the existing file. When Peter clicked the Yes button, he got an error and data could not be exported successfully. Which of the following is the most likely cause of the issue?

  1. The Excel file is opened.

  2. The Excel file is deleted.

  3. The Excel file is stored in another location.

  4. The Excel file is corrupted.

Answer: A

Explanation: The cause of the error is that the Excel file is opened. When an Excel file is opened, it can be updated by another program but it cannot be replaced. In order to replace the file by another program, the file must be closed. Answer: D is incorrect. A corrupted file can be replaced by a new file so it is not the cause of the issue. Answer: B and C are incorrect. If a file is deleted or stored in another location, a user is not asked to replace the file.

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