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

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

Peter 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 that is created in Microsoft Office Access 2007. Peter has opened a table in DataSheet view. He has created a column and wants to set the numeric datatype for the column. Which of the following actions will he perform to accomplish the task?

  1. Click on the column header, it will display a drop-down list. Choose the numeric data type from the dropdown list.

  2. Right click on the column and choose the numeric data type from the pop up menu.

  3. Write quot;Numberquot; in the column.

  4. Insert a number in the column.

Answer: D

Explanation: In order to accomplish the task, Peter will insert a number in the column. When the number is inserted in the DataSheet view, Access assigns the Number datatype to that column. The datatypes assigned to the columns in DataSheet view are as follows:

Text Date/Time Number Currency

The datatypes can also be explicitly added to a column by selecting the datatype in the Data Type list on the DataSheet tab.

Ensurepass 2018 PDF and VCE

Question No: 42

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 a Microsoft Office Access 2007 database named Library. The database contains a table named Books. Andrew wants to write a query to select all the books whose author#39;s information is available in the table. Which of the following SQL scripts will he use to accomplish the task?

  1. SELECT BookName FROM Books WHERE AuthNamelt;gt;quot;NULLquot;

  2. SELECT BookName FROM Books WHERE AuthName NOT EQUALS NULL

  3. SELECT BookName FROM Books WHERE AuthNamelt;gt;NULL

  4. SELECT BookName FROM Books WHERE AuthName IS NOT NULL

Answer: D

Explanation: In order to select those books whose author information is available in the table, Andrew should use the IS NOT NULL operator. The IS NOT NULL operator is a comparison operator that is used to compare a value with a NULL value. It evaluates to FALSE if the value is NULL, otherwise it evaluates to TRUE. Answer: C is incorrect.

However, if the quot;is not equal toquot; (lt;gt;) operator is used, it will not return any rows and will also not display any error message. Therefore, the following SQL statement should be used to fetch the names of those books whose author name is not NULL: SELECT BookName FROM Books WHERE AuthName IS NOT NULL

Answer: A is incorrect. It will search the AuthName containing the string quot;NULLquot;. Answer: B is incorrect. This is not a valid syntax to accomplish the task.

Question No: 43

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 data1 that is created in Microsoft Access 2007. Which of the following Access objects can he create in the database? Each correct answer represents a complete solution. Choose all that apply.

  1. Macros

  2. Reports

  3. Modules

  4. Ribbons

    Answer: A,B,C

    Explanation: Microsoft Office Access 2007 has the following access objects:

    1. Tables

    2. Queries

    3. Forms

    4. Reports

    5. Macros

    6. Modules

      Question No: 44

      Jack works as 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 Production. The database contains several tables.

      When Jack opens a table, a blank work area displays and the columns of the table display in the Chart Field List window. He has to drag and drop the fields to view the desired result. In which of the following views has Jack opened the table?

      1. Design

      2. Pivot Table

      3. Datasheet

      4. Pivot Chart

Answer: D

Question No: 45

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 Manufacture in Microsoft Office Access 2007. This database contains two tables – Cars and Dealers. The Cars table contains the following columns:

Car ID Car name Car price

Car model

The Dealers table contains the following columns: Dealer name

Dealer ID

Address Mobile no. Car ID Commission

The Car ID column in the Cars table is defined as the primary key, and the Car ID column in the Dealers table is defined as the foreign key. You want to retrieve the car name, car price, car model, dealer name, and commission. Which of the following queries will you execute to accomplish this task?

  1. SELECT c.Car name, c.Car model, c.Car price, d.Dealer name, d.Commission FROM Cars c INNER JOIN Dealers d ON c.Car ID=d.Car ID

  2. SELECT c.Car name, c.Car model, c.Car price, d.Dealer name, d.Commission FROM Cars c JOIN Dealers d WHERE Cars.Car ID=Dealers.Car ID

  3. SELECT Car name, Car model, Car price, Dealer name, Commission FROM Cars JOIN Dealers WHERE Cars.Car ID=Dealers.Car ID

  4. SELECT c.Car name, c.Car model, c.Car price, d.Dealer name, d.Commission FROM Cars c CROSS JOIN Dealers d ON c.Car ID=d.Car ID

Answer: C

Explanation: In this scenario, you have two tables named Cars and Dealers in the Manufacture database. Both tables have some columns in which Car ID column is common. The Car ID column in the Cars table is defined as the primary key, and the Car ID column in the Dealers table is defined as the foreign key. If you want to retrieve the car name, car price, car model, dealer name, and commission, you should use the JOIN clause and execute the following query: SELECT Car name, Car model, Car price, Dealer name, Commission FROM Cars JOIN Dealers WHERE Cars.Car ID=Dealers.Car ID Answer: B is incorrect. You can use this query if any alias is defined for both tables.

Answer: A is incorrect. This query is used when you are working with the inner join. In this type of join, data in various columns are compared by using the comparison operators. The inner joins are also known as equi-joins. It returns only those rows that have an equal value. Answer: D is incorrect. This query is used when you are working with the cross join. When this join is used in a query, the result is the multiplication of the number of rows from

the left table with the number of rows from the right table.

Question No: 46 CORRECT TEXT

Fill in the blank with the appropriate words. The property allows a control to adjust its dimensions according to the contents present in the control.

Answer: Can Grow

The Can Grow property allows a control to adjust its dimensions according to the contents present in

Explanation: the control. A control grows vertically to adjust its contents so that all the contents can be displayed. The default value of the Can Grow property is false.

Question No: 47

Which of the following filtering features is used to filter records based on the values in fields of a table, query, or form?

  1. Filter by Form

  2. Filter by Selection

  3. Filter by group

  4. Advanced Filter

Answer: A

Explanation: The Filter by Form feature is used to filter records based on the values in fields of a table, query, or form. It displays a filtering datasheet with blank fields. Each blank field is a combo box that contains a list of all the entries made in those fields. A user can select a value from this list or enter a new value. It is easy to use the Filter by Form feature when a table contains only a few fields. Answer: C is incorrect. There is no such feature as Filter by Group in Access 2007. Answer: B is incorrect. The Filter by Selection feature is

used to filter records based on the current selection in a field. Answer: D is incorrect. The Advanced Filter feature is used to create a simple query on a single table.

Question No: 48

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. A table named Customer contains the following data as shown in the image below:

Ensurepass 2018 PDF and VCE

Peter wants to retrieve the names of only those customers whose name starts with quot;Marquot;. Which of the following scripts will he use to accomplish the task?

  1. SELECT CustomerName FROM Customer WHERE CustomerName LIKE #39;Ma#39;

  2. SELECT CustomerName FROM Customer WHERE CustomerName LIKE #39;Ma*#39;

  3. SELECT CustomerName FROM Customer WHERE CustomerName LIKE #39;Mar*#39;

  4. SELECT CustomerName FROM Customer WHERE CustomerName LIKE #39;Mar#39;

Answer: C

Explanation: In order to accomplish the task, Peter will use the following script: SELECT CustomerName FROM Customer WHERE CustomerName LIKE #39;Mar*#39; Here, the LIKE operator searches the string according to the given criteria in the above mentioned query (LIKE #39;Mar*#39;). It will give the following result: Answer: B is incorrect. This query will not give the desired result. The result contains the names containing quot;Marquot; but it also contains the names starting with quot;Manquot;. The result displayed by the query is as follows:

Ensurepass 2018 PDF and VCE

Answer: A and D are incorrect. Both the queries will not display anything. These queries will find the whole word only. Since the table does not have the values as quot;Maquot; or quot;Marquot;, these queries will display nothing.

Ensurepass 2018 PDF and VCE

Question No: 49

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office installed on it. The computer contains a database named Sales that is created in Microsoft Access 2007. The database contains some records. You want to locate records containing certain information but you are not sure of all the

characters. Which of the following will you include in your search criteria to accomplish this task?

  1. Identifiers

  2. Expressions

  3. Wildcards

  4. Operators

Answer: C

Explanation: If you want to locate records containing a certain information but you are not sure of all the characters, you can include wildcards in your search criteria. You can also use wildcards when you search to return multiple variations of a base character set.

Question No: 50

Andrew works as a Database Designer for AccessSoft Inc. He has created a database named Customers. The database contains a tablenamed CustData. The CustData table contains the following columns: cust_name cust_age cust_order Andrew wants to ensure that when users retrieve data, the column names are in the following form: Customer_Name Customer_Age Customer_Order Which of the following statements can he use to accomplish the task? Each correct answer represents a complete solution.

Choose two.

  1. SELECT Customer_Name, Customer_Age, Customer_Order FROM Customers

  2. SELECT cust_name AS Customer_Name, cust_age AS Customer_Age, cust_order AS Customer_Order FROM Customers

  3. SELECT Customer_Name AS cust_name, Customer_Age AS cust_age, Customer_Order AS cust_order FROM Customers

  4. SELECT cust_name AS quot;Customer_Namequot;, cust_age AS quot;Customer_Agequot;, cust_order AS quot;Customer_Orderquot; FROM Customers

Answer: A,B

Explanation: Andrew can use any of the following statements to accomplish the task: SELECT cust_name AS Customer_Name, cust_age AS Customer_Age, cust_order AS Customer_Order FROM Customers SELECT cust_name AS quot;Customer_Namequot;, cust_age AS quot;Customer_Agequot;, cust_order AS quot;Customer_Orderquot; FROM Customers Customer_Name, Customer_Age, and Customer_Order are known as column_aliases. A column_alias can be used to display a column name other than what is defined in the 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