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

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