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 1-10

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

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

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 a Microsoft Office Access 2007 database named Human Resource. The database contains several tables and queries. The database contains a query named EmpDept, which displays the names of employees and their concerned departments through EmpName and DeptName columns. The structure of the query is given in the image below:

Ensurepass 2017 PDF and VCE

When James tries to insert data, he receives an error. Which of the following is the most likely cause of the error?

  1. The query does not contain the primary key column.

  2. Insertion of data cannot be done through a query.

  3. The query does not contain the foreign key column.

  4. The query is connected to two tables.

Answer: B

Explanation: The image shows a Select Query. So, James cannot insert data in the table while he is working with the Select Query. He can use this query to retrieve data from one or more tables and display the results in a datasheet. He can also use this to group records and calculate sum, counts, averages, and other types of totals. Answer: C is incorrect. The

insertion of data through a query does not depend on the foreign key column. If a query does not contain a foreign key, data can be successfully inserted. Answer: D is incorrect. Insertion of data through a query does not depend on the number of tables to which the query is connected. Answer: A is incorrect. If a primary key column is included in the query, data can be inserted. A primary key column does not accept blank entries or null values. It must contain valid data. It is important for the user when he is not working with the Select Query.

Question No: 2

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 has a table named OrderDetails. The table has a column named Price. He applies a CHECK constraint on the column to specify that the price of a product should be between $20 and $2000. He inserts data in the table to test the constraint. He finds that the constraint is not working correctly. He wants to modify the CHECK constraint. Which of the following statements will he use to accomplish the task?

  1. ALTER TABLE

  2. ALTER CHECK CONSTRAINT

  3. ALTER COLUMN

  4. ALTER CONSTRAINT

Answer: A

Explanation: In order to accomplish the task, Andrew will use the ALTER TABLE statement. This statement is used to add, modify, delete, enable or disable the CHECK constraint. Andrew will have to delete the existing CHECK constraint and recreate the constraint.Answer: B is incorrect. The ALTER COLUMN statement can be used to add, modify, delete, enable or disable the CHECK constraint, but it is used only within the ALTER TABLE statement.Answer: C and D are incorrect. There are no such statements as ALTER CHECK CONSTRAINT or ALTER CONSTRAINT.

Question No: 3

Which of the following datatypes generates a consecutive number that can be used as the primary key of a table?

  1. OLE Object

  2. Currency

  3. Hyperlink

  4. AutoNumber

Answer: D

Explanation: The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table.

The increment can be changed through the New Values property. This property has the following two values:

Increment Random

The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table.

Answer: B is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows:

General Number Currency

Euro Fixed Standard Percent Scientific

Answer: C is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink. 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.

Question No: 4

You are creating a new report named Report1 in Microsoft Office Access 2007 using the Report Design feature. This feature opens a report layout in the Design view that includes three standard sections by default. What are these three sections? Each correct answer represents a complete solution. Choose three.

  1. Page Footer

  2. Group Header/Footer

  3. Report Header/Footer

  4. Detail

  5. Page Header

    Answer: A,D,E

    Explanation: The following sections are included in the default layout of the Report Design view:

    1. Page Header: It is displayed at the top of each page. Page Header includes a logo, column heading, page number, etc.

    2. Detail: It displays the data and their associated labels that are included for the table or query fields added to the report.

    3. Page Footer: It is displayed at the bottom of each page. Page Footer includes a report name, date and time, coding, page number, etc.

      Answer: B and C are incorrect. These sections are not included in the default layout of the Report Design view. However, they can be added to the Report Design view.

      Question No: 5

      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 has a database named Sales created in Microsoft Office Access 2007. The database contains two tables named Employees and Department. Both the tables are related to each other

      through a column named EmpID. Andrew creates a query to retrieve the records from both tables.

      Ensurepass 2017 PDF and VCE

      When he runs the query he gets the following error: Type mismatch in expression Which of the following is the cause of the error?

      1. The datatype of the EmpID column is different in both tables.

      2. Incorrect table name is used in the query.

      3. The Employees table is damaged.

      4. The record in the EmpID column is deleted in the primary key table.

Answer: A

Explanation: The Type mismatch in expression error occurs when the datatype of a primary key column and the foreign key column joining the two tables is assigned to different datatypes. To troubleshoot this error, both the fields must have same datatype. Answer: B is incorrect. In the query, the actual table names are not provided rather aliases are given to access the tables. Alias is a temporary name assigned to a table, view, column, or value, within a SQL statement. It can either be referred to in the statement in which it is defined or in an associated SQL *PLUS command. Answer: D and C are incorrect. If a record is deleted from a primary key or the foreign key columns or a table is damaged, it does not cause the type mismatch error.

Question No: 6

Which of the following field properties is mainly used for memo fields, and creates a field value history to add new text to the field if it is set to #39;Yes#39;?

  1. Allow Zero Length

  2. Input Mask

  3. Append Only

  4. IME Mode

Answer: C

Explanation: The Append Only property is mainly used for memo fields. When this property is set to #39;Yes#39;, it creates a field value history to add new text to the field. Answer: A is incorrect. The Allow Zero Length property allows a quot;quot; string value when it is set to #39;Yes#39;. Answer: D is incorrect. The IME Mode property is related to East Asian languages. Answer: B is incorrect. The Input Mask property is used to specify that the field value should be confirmed to the pattern set by the mask.

Question No: 7

John 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 db1 created in Microsoft Office Access 2007. John wants to open the database in a shared mode. In which of the following modes will he open the database to accomplish the task?

  1. Open exclusive

  2. Open exclusive read-only

  3. Open

  4. Open read-only

Answer: C

Explanation: When a database is opened using the Open option, it will open in a shared mode. Any user can open the database, insert, modify, and delete data from the database. Answer: A is incorrect. When a database is opened using the Open Read-Only option, the data in the database can be viewed, but the data cannot be inserted, modified, or deleted. Other users can perform all the tasks on the database.

Answer: D is incorrect. When a database is opened using the Open Exclusive option, other users cannot open it unless the current user closes the database and opens it normally.

Answer: B is incorrect. When a database is opened using the Open Exclusive Read-Only option, the data in the database can be viewed, but the data cannot be inserted, modified, or deleted. Other users can also open the database but the database will be opened in the read-only mode.

Question No: 8

Andrew works as a Database Administrator 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. Users complain that they are not able to find an employee name whose Last Name is Jackson. Andrew writes the following query to check the table: SELECT * FROM Employees He finds that Jackson#39;s name is misspelled. What will Andrew do to resolve the issue? Each correct answer represents a complete solution. Choose all that apply.

  1. Use the UPDATE statement to modify the name

  2. Open the table in the Design view to modify the name

  3. Open the table in the PivotTable view to modify the name

  4. Open the table in the Datasheet view to modify the name

Answer: A,D

Explanation: In order to accomplish the task, Andrew will open the table Datasheet view and modify the data. When a table is opened in a datasheet view, a user can add, modify or delete the data from a table. Andrew can also use the UPDATE statement to accomplish the task. The UPDATE statement is used as follows: UPDATE lt;table_namegt; SET

lt;column_name=valuegt; WHERE lt;column_name=valuegt;

Question No: 9

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 Human Resource created in Microsoft Office Access 2007. James has to create a table named Employees. He wants to create a column named Resume in which one or more files can be stored. To which of the following datatypes will James assign the column to accomplish the task?

  1. Hyperlink

  2. OLE Object

  3. Attachment

  4. Memo

Answer: C

Explanation: In order to accomplish the task, James will assign the column to the Attachment datatype. The Attachment datatype can be used to attach one or more files in a single record. 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. Answer: A is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink. Answer: B 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 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.

Question No: 10

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. The database contains a table

named Orders. James wants to ensure that the column named OrderDate should display the current date if the value for that column is not provided. Which of the following functions will James use in the Default Value property to accomplish the task?

  1. Date()

  2. IsDate()

  3. Now()

  4. DateValue()

Answer: A

Explanation: In order to accomplish the task, James will use the Date() function. The Date() function displays the current date in a column in mm-dd-yyyy format. The format of the date can be changed by using the Format property. Answer: C is incorrect. The Now() function displays the current date as well as the current time. According to the scenario James has to display only the date, so this function will not accomplish the task. Answer: D is incorrect. The DateValue() function is used to convert a date to a string format. It cannot be used to display current date. Answer: B is incorrect. The IsDate() function is used to check whether or not the value passed as an argument is a date. The value returned by the function is the boolean value. If a value is date it returns true; otherwise it returns false.

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 11-20
[Free] 2017(Sep) EnsurePass Passguide Microsoft 77-605 Dumps with VCE and PDF 71-80

Name of author

Name: admin

Leave a Reply