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

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

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

Name of author

Name: admin