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

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

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: 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 2017 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 2017 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 2017 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 2017 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% 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 51-60
[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 31-40

Name of author

Name: admin

Leave a Reply