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

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

Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer that has Microsoft Office 2007 installed on it. The computer has a database named Sales created in Microsoft Office Access 2007. The database contains a table named SalesData. Peter uses the Split Database tool to split the database. He named the other database as SplitSales. When the Sales database is split, the SalesData table exists as a link in the Sales database whereas the actual table exists in the SplitSales database. Accidently, Peter deletes the SalesData table from the SplitSales database.

What will happen if he tries to open the table through the link in the Sales Database?

  1. Nothing will happen as there is no table in the SplitSales database.

  2. The SalesData table will be created in the SplitSales database and will be opened.

  3. An error will occur.

  4. The SplitSales database will be deleted and the link will itself act as a table in the Sales database.

Answer: C

Explanation: When a database is split, the link of a table exists in the main database, whereas the actual table exists in the other (SplitSales) database. If the table in the SplitSales database is deleted and the link is clicked from the main database, an error occurs, which says that quot;There is no input table as SalesDataquot;. In order to resolve the issue, a table named SalesData should be created in the SplitSales database.

Question No: 22

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. The database contains several tables. Peter has created a sales report named SalesReport, which is connected to SalesData table. Now, Peter has renamed the table as SalesInfo. Which of the following actions will be performed on the report?

  1. The report will be deleted.

  2. The report will also be renamed.

  3. The report will be disconnected.

  4. The report will work successfully.

Answer: D

Explanation: The report will not get affected in any way because when a table is renamed, the RecordSource property of the report is also changed. The report remains connected to the table and works normally. It is neither deleted nor renamed.

Question No: 23

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named Employees. You have to filter the table to display customers located in two states. You want to work with advanced filters and queries. Which of the following will you use to accomplish this task?

  1. Navigation pane

  2. Lookup wizard

  3. Design grid

  4. Report tool

Answer: C

Explanation: The design grid is a grid in which a user can work with advanced filters and queries. It is available in query Design view or in the Advanced Filter/Sort window. For queries, this grid is known as the QBE grid. An example of the design grid is given in the image below:

Ensurepass 2018 PDF and VCE

Answer: B is incorrect. The Lookup Wizard is used for inserting values manually or taking values from an existing table. A datatype is assigned to a field on the basis of the values inserted in it. The values are displayed in a combo box. Answer: A is incorrect. The Navigation Pane is displayed on the left side in a new or existing database. The pane contains different database objects such as tables, queries, forms, reports, macros, etc. The database can be opened through the pane in different modes such as datasheet view,

design view, and layout view. A user can use the navigation Pane to show or hide the database objects. Answer: D is incorrect. The Report tool in Microsoft Office Access 2007 is used to create reports in the fastest way. A user has to select the table or query for which the report is to be created. Clicking the Report tool creates the report. After creating the report, the user can save it. The report name will be displayed in the Reports section of the Navigation Pane. It can be modified by using the Design view of the report.

Question No: 24

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer contains a database named Sales. James creates a table named Order. He adds a column named OrderID and assigns it to the Number datatype. Now he wants to ensure that the field can accept decimal values. Which of the following properties will he use to accomplish the task?

  1. Caption

  2. Format

  3. Decimal Places

  4. Field Size

Answer: D

Explanation: In order to accomplish the task, James will use the Field Size property. This property contains the following values:

Byte Integer

Long Integer Single Double Replication ID Decimal

Answer: B is incorrect. The Format property is used to format the Date/Time datatype. The date and time can be formatted as follows:

General Date: The date is displayed in the format of mm/dd/yyyy h:m:s. For example, 10/19/2004 6:30:45 PM

Long Date: The date is displayed in the following format:

Friday, October 19, 2004

Medium Date: The date is displayed in the following format: 19-Oct-04

Short Date: The date displayed in the format of mm/dd/yyyy. For example, 10/19/2004

Long Time: The time is displayed in the format of h:m:s. For example, 6:30:45

PM Medium Time: The time is displayed in the format of h:m. For example, 6:30 PM

Short Time: The time is displayed in the following format: 18:30

Answer: C is incorrect. The Decimal Places property is used to set the decimal place of a number in a field. This property works when the format of the Number datatype is changed to Single, Double, or Decimal. Answer: A is incorrect. The value of the Caption property is displayed as text on a Label control in a Form.

Question No: 25

You are working with Microsoft Office Access 2007. You filter the contents of a table in order to display a subset of its records using the Filter by Selection feature. On the Selection menu, you get the following filtering options as displayed in the figure:

Ensurepass 2018 PDF and VCE

You want to return each record in the table that includes an exact data value or an embedded portion of the field content. Which of the following filtering options will you

choose?

  1. Equals quot;data valuequot;

  2. Does Not Equal quot;data valuequot;

  3. Contains quot;data valuequot;

  4. Does Not Contain quot;data valuequot;

Answer: C

Explanation: The Contains quot;data valuequot; option is used to return each record in the table or query. The condition is that the table or query should include an exact data value or an embedded portion of the field content.

Question No: 26

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. Peter has to retrieve all the data from a table named Employees according to the employees whose last name is Mathews. The last name is filled in the LasName column of the table. Which of the following SQL scripts will he use to accomplish the task?

  1. SELECT * Last Name=quot;Mathewsquot; FROM Employees

  2. SELECT * FROM Employees WHERE Last Name=quot;Mathewsquot;

  3. SELECT Last Name FROM Employees

  4. SELECT * FROM Employees WHOSE Last Name IS quot;Mathewsquot;

Answer: B

Explanation: In order to accomplish the task, Peter will use the following script: SELECT * Last Name=quot;Mathewsquot; FROM Employees Here, The SELECT statement is used to retrieve data from a table or query. * is used to tell the SELECT statement that all the data from a table or query is to be retrieved. The FROM clause is used to mention the table name from which data is to be retrieved.

Employees is the name of the table from which data is to be retrieved. The WHERE clause is used to search data according to a given criteria. Last Name is the column in the Employees table according to which the data is to searched

Question No: 27

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer having Microsoft Office 2007 installed on it. The computer contains a database named Sales which is created in Microsoft Access 2007. The Sales database has a table named SalesData. Andrew wants to enforce domain integrity on the SalesData table. Which of the following constraints will he use to accomplish the task?

  1. Check

  2. Unique

  3. Primary

  4. Foreign

Answer: A

Explanation: The CHECK constraint enforces domain integrity by limiting the values that are accepted by a column. Multiple CHECK constraints can be applied to a column. A CHECK constraint can be created using a logical expression to validate the value accepted by a column. It is also possible to use multiple-columns in a CHECK constraint. For example, a CHECK constraint can be used to confirm that the value in the OrderDate column is less than the value in the InvoiceDate column. However, a CHECK constraint cannot be created to enforce a rule that requires a column value from another row in the table or column value from another table. Answer: C is incorrect. A table usually has a column or combination of columns whose values uniquely identify each row in the table.

This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column. Answer: B is incorrect. UNIQUE constraint ensures that no two rows have duplicate values in a specified column or set of columns. Multiple UNIQUE constraints can be defined for a table. The UNIQUE constraint can be created while creating a table, using the CREATE TABLE statement. It can also be created while modifying the table, using the ALTER TABLE statement. The UNIQUE constraint allows NULL values unless the NOT NULL constraint is specified for the same column. Answer: D is incorrect. A foreign key is a column or combination of columns used to establish and enforce a relationship between the data in two tables. This relationship is created by adding a column(s) in one of the tables to refer to the other table#39;s column(s) protected by a PRIMARY KEY or UNIQUE constraint. This column becomes a foreign key in the first table. A foreign key can be created by defining a FOREIGN KEY constraint when creating or altering a table.

Question No: 28

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. A form named EmpForm is connected to the EmpQuery query. The form contains a listbox that displays the values of a column named PhoneNo of all the employees. Some of the employees do not have a phone. James wants to ensure that the field related to those employees does not look blank. Which of the following actions will he perform to accomplish the task?

  1. Use the IS NOT NULL clause in the fields.

  2. Use the IS NOT EMPTY clause in the fields.

  3. Use IsMissing in the fields.

  4. Use quot;quot; in the fields.

Answer: D

Explanation: If James does not want to leave the fields blank that are related to the employees who do not have a phone, he should enter quot;quot; (Empty string) in each field. Answer: A is incorrect. The IS NOT NULL clause is used to check whether or not a column in a table contains NULL values. The IS NOT NULL clause returns all the rows of a column that does not have NULL values. The following example will demonstrate the use of the IS NOT NULL clause: SELECT CustID FROM Employees WHERE Fname IS NOT NULL This statement will retrieve the CstID of all customers whose Fname does not contain any empty string. 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: d is incorrect. There is no such clause as IS NOT EMPTY.

Question No: 29

James works as a Database Designer for AccessSoft Inc. He has to create a query that will count the number of employees in the company. Which of the following query wizards

should he use to accomplish the task?

  1. Crosstab Query

  2. Simple Query

  3. Find Duplicates Query

  4. Find Unmatched Query

Answer: A

Explanation: In order to accomplish the task, James should use the Crosstab Query Wizard. This wizard helps to create a query in which a user can use functions such as Count, Min, Max, etc.Answer: B is incorrect. The Simple Query Wizard helps to create simple queries that are used to display specific or all data. Answer: C is incorrect. The Find Duplicates Query Wizard is used to create queries that display duplicate records.Answer: D is incorrect. The Find Unmatched Query Wizard compares two tables and displays the unmatched data between the two tables.

Question No: 30

Peter works as a Database Designer for AccessSoft Inc. The companies#39; CRM database has a table named Cust. Peter wants to retrieve all the data from the table. He also wants to ensure that no duplicate values are displayed. Which of the following SQL statements will he use to accomplish the task?

  1. SELECT…DISTINCT

  2. SELECT…TOP

  3. SELECT…WHERE

  4. SELECT…ALL

Answer: A

Explanation: In order to accomplish the task, Peter will use the SELECT…DISTINCT statement. The DISTINCT clause is used to eliminate duplicate rows in the specified table. Answer: D is incorrect. The SELECT…ALL statement is used to display all the rows from a table, including duplicate rows. Answer: B is incorrect. The SELECT…TOP statement is used to display the first set of the rows specified in the TOP clause. Answer: C is incorrect. The SELECT…WHERE statement is used to filter the data in a table

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