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

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

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

Name of author

Name: admin

Leave a Reply