Mastin Gallery

Mastin Espanol Gallery - All photos: © Copyright by the owners!
Prepare Pass4sure shortest Braindumps of 77-605 exam with reading practice test, test questions, assessment test sample

How to prepare for 77-605 exam?

77-605 reading practice test | 77-605 test questions | 77-605 assessment test sample | 77-605 pass marks | 77-605 real test - Officialcerts.com



77-605 - MOS Using Microsoft Office Access 2007 - Dump Information

Vendor : Microsoft
Exam Code : 77-605
Exam Name : MOS Using Microsoft Office Access 2007
Questions and Answers : 134 Q & A
Updated On : August 18, 2017
PDF Download Mirror : 77-605 Brain Dump
Get Full Version : Officialcerts 77-605 Full Version


It is unbelieveable, but 77-605 Latest Braindumps are availabe here.

This is my first time that I took this service. I feel very confident in 77-605 but. I prepare my 77-605 using questions and answers with exam simulator softare by Officialcerts team.

Try out these real 77-605 Latest Braindumps.

I thank you Officialcerts Brain dumps for this incredible success. Yes, it is your question and answer which helped me pass the 77-605 exam with 91% marks. That too with only 12 days preparation time. It was beyond my imagination even three weeks before the test until I found the product. Thanks a lot for your invaluable support and wish all the best to you team members for all the future endeavors.

I feel very confident by preparing 77-605 real questions.

Heres yet another vote for Officialcerts as the best way to prepare for 77-605 exam. I opted for this kit to prepare for my 77-605 exam. I didnt set my hopes too high and kept an eye on the official syllabus to make sure I do not miss any topics, and it turned out that Officialcerts had them all covered. The preparation was very solid and I felt confident on the exam day. And what really made Officialcerts awesome was the moment when I realized their questions were exactly the same as what real exam had. Just as promised (which I didnt really expect to be true - you know how it works sometimes!). So, this is great. Dont hesitate, go for it.

Dont forget to try these real exam questions for 77-605 exam.

I just required telling you that I have topped in 77-605 exam. All the questions on exam table were from Officialcerts. It is said to be the genuine helper for me on the 77-605 exam bench. All praise of my achievement goes to this guide. This is the actual reason behind my success. It guided me in the correct way for attempting 77-605 exam questions. With the help of this study stuff I was talented to effort to all the questions in 77-605 exam. This study stuff guides a person in the right way and guarantees you 100% accomplishment in exam.

Got no problem! 3 days preparation of 77-605 braindumps is required.

The answers are explained briefly in simple language and still make quite an impact thats easy to understand and follow. I took the help of Officialcerts Q&A and passed my 77-605 exam with a healthy score of 69. Thanks to Officialcerts Q&A. I would like to suggest in favor of Officialcerts Q&A for the preparation of 77-605 exam

It is great ideal to prepare 77-605 exam with Latest Braindumps.

I have cleared the 77-605 exam in the first try. I could achieve this success because of Officialcerts question bank. It helped me to apply my work book knowledge in the question & answer format. I solved these question papers with exam simulator and got full idea of the exam paper. So I would like to thank Officialcerts.

Got no problem! 3 days preparation of 77-605 real questions is required.

I would often miss classes and that would be a huge hindrance for me if my parents found out. I needed to cover my mistakes and make sure that they could believe in me. I knew that one way to cover my mistakes was to do well in my 77-605 test that was very near. If I did well in my 77-605 test, my parents would love me again and that they did because I was able to clear the test. It was this Officialcerts that gave me the perfect instructions. Thank you.

Dont forget to try these Actual Questions questions for 77-605 exam.

HI, I had enroll for 77-605. Though I had read all chapters in depth, but your question bank provided enough practise. I cleared this exam with 99 % yesterday, Thanks a lot for to the point question bank. Even my doubts were clarified in minimum time. I wish to use your service in future as well. You guys are doing a great job. Thanks and Regards.

I feel very confident by preparing 77-605 braindumps.

I have earned better scores in 77-605 certification with the help of highly affordable products. I got 77-605 exam engine to get rid of difficult concepts of this certification. I had bought 77-605 exam braindump to have bright grades in the certification. It was good decision because these products are designed according to my mindset. It helped me to get read in fifteen days and after this short time I had scored good with the help of these sensible products therefore I am writing to say thanks to all of you for your great services.

Exam questions are changed, where can i find new questions and answers?

I passed the 77-605 exam with this bundle from Officialcerts. Im not sure I would have done it without it! The thing is, it covers a huge range of topics, and if you prepare for the exam on your own, without a proven strategy, chances are that some things can fall through the cracks. These are just a few areas Officialcerts has really helped me with there is just too much info! Officialcerts covers everything, and since they use real exam questions passing the 77-605 with less stress is a lot easier.

Latest Exams added on Officialcerts

1Z0-453 | 210-250 | 300-210 | 500-205 | 500-210 | 70-765 | 9A0-409 | C2010-555 | C2090-136 | C9010-260 | C9010-262 | C9020-560 | C9020-568 | C9050-042 | C9050-548 | C9050-549 | C9510-819 | C9520-911 | C9520-923 | C9520-928 | C9520-929 | C9550-512 | CPIM-BSP | C_TADM70_73 | C_TB1200_92 | C_TBW60_74 | C_TPLM22_64 | C_TPLM50_95 | DNDNS-200 | DSDPS-200 | E20-562 | E20-624 | E_HANABW151 | E_HANAINS151 | JN0-1330 | JN0-346 | JN0-661 | MA0-104 | MB2-711 | NSE6 | OMG-OCRES-A300 | P5050-031 |

See more dumps on Officialcerts

LOT-915 | HP2-B99 | GB0-180 | HP0-310 | 922-097 | HP0-S16 | 000-532 | HP0-066 | PEGACBA001 | MORF | 1Y0-A01 | 9A0-318 | 920-331 | 642-188 | PARCC | 000-657 | HP0-921 | HP0-921 | 000-085 | 312-50 | ST0-119 | 1Y0-401 | 642-383 | 000-025 | HP0-648 | HP2-Z27 | EE0-503 | 1Z0-560 | A2090-612 | 3306 | FM0-304 | DC0-260 | Property-and-Casualty | NS0-101 | 000-906 | 642-278 | A2040-412 | 9L0-622 | COMPASS | 300-206 | 1Z0-226 | 190-831 | 3103 | 000-864 | C2090-913 | HP0-J48 | 000-050 | SPS-201 | HP2-B61 | 00M-225 |

77-605 Questions and Answers

h1 { color: #F00; font-family:"Times New Roman", serif; font-style: normal; font-weight: bold; text-decoration: none; font-size: 12pt; } .p, p { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; margin:0pt; } li {display: block; } #l1 {padding-left: 0pt;counter-reset: c1 0; } #l1> li:before {counter-increment: c1; content: counter(c1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l2 {padding-left: 0pt;counter-reset: d1 0; } #l2> li:before {counter-increment: d1; content: counter(d1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l3 {padding-left: 0pt;counter-reset: e1 0; } #l3> li:before {counter-increment: e1; content: counter(e1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l4 {padding-left: 0pt;counter-reset: f1 0; } #l4> li:before {counter-increment: f1; content: counter(f1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l5 {padding-left: 0pt;counter-reset: g1 0; } #l5> li:before {counter-increment: g1; content: counter(g1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l6 {padding-left: 0pt;counter-reset: h1 0; } #l6> li:before {counter-increment: h1; content: counter(h1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l7 {padding-left: 0pt;counter-reset: i1 0; } #l7> li:before {counter-increment: i1; content: counter(i1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l8 {padding-left: 0pt;counter-reset: j1 0; } #l8> li:before {counter-increment: j1; content: counter(j1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l9 {padding-left: 0pt;counter-reset: k1 0; } #l9> li:before {counter-increment: k1; content: counter(k1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l10 {padding-left: 0pt;counter-reset: l1 0; } #l10> li:before {counter-increment: l1; content: counter(l1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l11 {padding-left: 0pt;counter-reset: m1 0; } #l11> li:before {counter-increment: m1; content: counter(m1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l12 {padding-left: 0pt;counter-reset: n1 0; } #l12> li:before {counter-increment: n1; content: counter(n1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l13 {padding-left: 0pt;counter-reset: o1 0; } #l13> li:before {counter-increment: o1; content: counter(o1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l14 {padding-left: 0pt;counter-reset: p1 0; } #l14> li:before {counter-increment: p1; content: counter(p1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; } li {display: block; } #l15 {padding-left: 0pt;counter-reset: q1 0; } #l15> li:before {counter-increment: q1; content: counter(q1, upper-latin)". "; color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 12pt; }


QUESTION: 120

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 a Microsoft Office 2007 database named HumanResource. The database contains a table named Employees. The table contains a column named JoinDate. Peter wants to ensure that the column automatically gets the current date if the date for a record is not mentioned. Which of the following table properties will he use to accomplish the task?


  1. Validation Rule

  2. Default Value

  3. Format

  4. Input Mask


Answer: B


Explanation:

In order to accomplish the task, Peter will use the Default Value property. The value of the Default Value property is given to a column if the value for that column is unknown. If a user does not provide any value for that column, the default value is automatically inserted. Answer C is incorrect. The Format property is used to change the format of the fields having Number, Date/Time, Currency, Yes/No datatypes. A value provided in this property cannot be displayed in a column if a value for that

column is not provided.

Answer A is incorrect. A validation rule is a set of rules associated with a column so that a user is restricted from entering invalid data. A user can be restricted from entering data through the following options:

Datatypes: When a field is assigned to a datatype, data of another type cannot be inserted in the field. Field size: The field size restricts the amount of data to be inserted in a table. Table Properties: Certain table properties such as Required forces a user to enter data or the Format property forces a user to enter data in a defined format. A validation rule can be applied by using the Validation Rule property. A user can be intimated about the invalid data through the Validation Text property.

Answer D is incorrect. The Input Mask property is used to change the format of a field having the Text or Date/Time datatype. This property provides the formats for different types of data such as zip-code, phone, date, time, password etc. When the Input Mask property is set for a field, a user should fill the data in the same format. Any other format is either converted to the given format or remains as it is.


QUESTION: 121

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

James 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. The database contains four tables that are related to each other through the primary and foreign keys. The database is not normalized. In order to normalize the database, James has to delete some columns from the tables. Which of the following syntaxes will he use to accomplish the task?


  1. DROP COLUMN <column;_name>

  2. ALTER TABLE <table_name>DROP COLUMN <column_name>

  3. ALTER TABLE <table_name>ALTER COLUMN <column_name> DROP

  4. ALTER DATABASE <database_name>DELETE COLUMN <column_name>


Answer: B


Explanation:

In order to accomplish the task, James will use the following syntax: ALTER TABLE

<table_name>

DROP COLUMN <column_name>

The properties of a column can be modified by using the ALTER TABLE statement.

This statement can be used to accomplish the following tasks:

Add and drop columns Add and drop constraints


Answer C is incorrect. The following syntax will generate an error: ALTER TABLE

<table_name>

ALTER COLUMN <column_name> DROP

Answer A is incorrect. The DROP COLUMN clause works inside the ALTER TABLE statement. If it is used without the ALTER TABLE statement, it will generate an error.

Answer D is incorrect. There is no such clause as DELETE COLUMN in the ALTER TABLE statement.


QUESTION: 123

You are working with Microsoft Office Access 2007. You have created two tables named students and student_courses. You have binded both tables by creating a one- to-many relationship between them. You want to change the value on one side of the relationship. What will you do to accomplish the task? Each correct answer represents a part of the solution. Choose three.


  1. Select the Cascade Update Related Fields.

  2. Select the Enforce Referential Integrity.

  3. Select the Show/Hide group of the Database Tools tab.

  4. Select the Cascade Delete Related Records.


Answer: B, A, D


Explanation:

In order to accomplish the task, you should take the following steps: 1.Select the Enforce Referential Integrity.

2.Select the Cascade Update Related Fields. 3.Select the Cascade Delete Related Records.


QUESTION: 124

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 computer contains a database named Sales created in Microsoft Office Access 2007. The database contains several tables. Two tables named Employees and Department are joined with each other through a column named EmpID . The EmpID column is a primary key column in the Employees table and a foreign key column in the Department table. Peter has to delete the Employees table. What will happen when he tries to delete the Employees table?


  1. The Employees and the Department tables with the relationship will be deleted.

  2. The Employees table and the relationship will be deleted.


  3. The Employees table will not be deleted as it contains primary key.

  4. All columns except the EmpID column will be deleted.


Answer: B


Explanation:

When Peter deletes the Employees table, Microsoft Access asks to delete the relationships also. If Peter clicks the Yes button, the Employees table with the relationship will be deleted.


QUESTION: 125

Which of the following characteristics is the most important characteristic of a field that is elected as a primary key in a table?


  1. Unique

  2. Easily remembered

  3. Small in size

  4. Simple datatype


Answer: A


Explanation:

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 C is incorrect. It is not important to consider the size of a primary key. Answer B is incorrect. For using a database, it is not necessary to remember record keys.

Answer D is incorrect. A simple datatype is helpful in the key indexing, but it is not a primary characteristic.


QUESTION: 126

Which of the following features are considered as the preventive maintenance tasks for Microsoft Office Access 2007 databases? Each correct answer represents a complete solution. Choose three.


  1. Linked Table Manager

  2. Backup Database

  3. Compact and Repair Database

  4. Filter


Answer: B, C, A


Explanation:

The following features are considered as the preventive maintenance tasks for Microsoft Office Access 2007:

Backup: It makes copies of data to restore the original data after a loss event. Compact and Repair Database: It is used to perform routine maintenance of a database. Linked Table Manager: It lists the paths to all currently linked tables. Answer D is incorrect. Filter is not a preventive maintenance tool. It is used to choose one or more of the current values in a table field to select records to display.


QUESTION: 127

You are working with Microsoft Office Access 2007. You are creating a query using the Design view. You want that the extracted data will display in a specific order. Which of the following properties will you configure in order to accomplish the task?


  1. Show

  2. Or

  3. Sort

  4. Criteria


Answer: C


Explanation:

In order to accomplish the task, you should configure the Sort property. This property displays the extracted data in a specific order. The Sort property sets the data in ascending or descending order.

Answer A is incorrect. The Show property is used to include a field in the query. Answer D is incorrect. The Criteria property defines various specifications for the query.

Answer B is incorrect. The Or property defines the optional entries that create OR elements of the selection criteria of the query.


QUESTION: 128

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer, which has a database named Orders. The database


contains a table named OrderDetails. Users run queries against the database to place orders of customers. They also retrieve data related to the processing of orders and information about the customers who place orders. Users complain that the retrieval of data is very slow. James opens the following query:

SELECT * FROM OrderDetails;

What should he do to enhance the performance of the query?


  1. Use the WHERE clause with the SELECT statement.

  2. Use the GROUP BY clause with the SELECT statement.

  3. Use the DISTINCT clause with the SELECT statement.

  4. Use the TOP clause with the SELECT statement.


Answer: A


Explanation:

In order to enhance the performance of the query, James will use the WHERE clause with the SELECT statement as follows:

SELECT * FROM OrderDetails WHERE custname='customer name';

The WHERE clause is used to filter data given in the table. The filter is based on one or more columns given after the SELECT statement. The columns are separated by commas.

Answer C is incorrect. The DISTINCT clause is used to prevent rows from getting duplicated in the result set. It can only be used with the SQL SELECT statement. The syntax for the DISTINCT clause is as follows: SELECT DISTINCT <columns> FROM <table_name> WHERE <conditions>

Answer D is incorrect. The TOP clause is used to retrieve data for the first set of rows. The example is as follows:

SELECT * TOP 10 FROM OrderDetails;

The statement will retrieve only the top ten rows from the OrderDetails table.

Answer B is incorrect. The GROUP BY clause groups selected rows on the basis of values of specified column(s) for each row, and returns a single row of summary information for each group. Rows that have the same values in the specified grouping column(s) are grouped together. The GROUP BY clause suppresses duplicate rows for the grouping column(s). It does not guarantee the order of the result set. Therefore, an ORDER BY clause should be used with the GROUP BY clause to sort the result set in the desired order.


QUESTION: 129

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 HumanResource. The database contains several forms, tables and queries. James has to manually create a report that will display records from EmpDept query, which contains the names of


employees in the EmpName column and their concerning departments in the DeptName column. James creates a TextBox control. He has to bind the TextBox to the EmpName property. Which of the following properties will he use to accomplish the task?


  1. RowSource

  2. ControlSource

  3. TableSource

  4. RecordSource


Answer: B


Explanation:

In order to accomplish the task, James will use the ControlSource property. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control.

Answer D is incorrect. The RecordSource property belongs to the form and report controls. This property is used to connect a form or report to a table or query. After setting the RecordSource property, a user can use the ControlSource property to bind the controls of a form or report. The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be

retrieved. This source can be a table or a query. When a form or a report is bound to a

table or a query, the controls can be bound to a column of the table through the ControlSource property.

Answer A is incorrect. RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box.

Answer C is incorrect. There is no such property as TableSource.


QUESTION: 130

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

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 Sales that is created in Microsoft Access 2007. The database contains five tables. You are working with SELECT statement to retrieve data from all the tables. You want to generate a table, which contains the columns from all the tables. Which of the following clauses will you use to accomplish this task?


  1. DISTINCT

  2. JOIN

  3. GROUP BY

  4. WHERE


Answer: B


Explanation:

The JOIN clause is used with the SELECT statement to retrieve data from more than one table. This clause matches data from multiple tables. This results in the creation of a table, which is a combination of columns from multiple tables. It joins the tables by combination of a primary key and a foreign key. The result of the query generates a temporary table containing the columns from two or more tables. Answer A is incorrect. The DISTINCT clause is used to prevent rows from getting duplicated in the result set. It can only be used with the SQL SELECT statement.

The syntax for the DISTINCT clause is as follows: SELECT DISTINCT <columns> FROM <table_name> WHERE <conditions>

Answer D is incorrect. The WHERE clause is used with the SELECT statement to search records in one or more tables. This clause is also used to update or delete records through the UPDATE and DELETE statements. When the WHERE clause is used with the SELECT statement, it displays the records as per the criteria defined


using the WHERE clause. When this clause is used with the UPDATE or DELETE statements, the records are updated and deleted as per the criteria. Data once updated or deleted cannot be undone.

Answer C is incorrect. The GROUP BY clause groups selected rows on the basis of values of specified column(s) for each row, and returns a single row of summary information for each group. Rows that have the same values in the specified grouping column(s) are grouped together. The GROUP BY clause suppresses duplicate rows for the grouping column(s). It does not guarantee the order of the result set. Therefore, an ORDER BY clause should be used with the GROUP BY clause to sort the result set in the desired order.


QUESTION: 132

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 HumanResource. The database contains a table named Employees. Andrew wants to retrieve the records of those employees whose salary is greater than $20000. The Salary field in the table is set to the Currency datatype. Which of the following scripts will he use to accomplish the task?


  1. SELECT * FROM Employees WHERE Salary>20000

  2. SELECT * FROM Employees WHERE Salary>'20000'

  3. SELECT * FROM Employees WHERE Salary>'$20000'

  4. SELECT * FROM Employees WHERE Salary>$20000


Answer: A


Explanation:

In order to accomplish the task, Andrew will use the following script: SELECT * FROM Employees WHERE Salary>20000 When a query is created with the Currency datatype in the WHERE clause, the value of the currency datatype must be a number. The number must be neither enclosed in single or double quotes nor prefixed by a dollar or other currency signs.


QUESTION: 133

Andrew works as a Database Administrator for Softech Inc. The company has a database named Sales. The database contains a table named SalesData. Andrew wants to ensure that multiple columns in the table do not contain duplicate values, and each column should allow a single NULL value. Which of the following constraints will he use to accomplish the task?


  1. FOREIGN KEY

  2. UNIQUE

  3. CHECK

  4. PRIMARY KEY


Answer: B


Explanation:

In order to accomplish the task, Andrew will use the UNIQUE CONSTRAINT. The UNIQUE CONSTRAINT does not allow duplicate values. It can be implemented on multiple columns in a table. Since UNIQUE CONSTRAINT does not allow duplicate values, it allows only a single NULL value in the columns on which it is implemented. 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. The PRIMARY KEY CONSTRAINT does not allow duplicate values and NULL values in a column on which it is defined. The PRIMARY KEY CONSTRAINT can be implemented only on a single column in a table. 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 C is incorrect. The CHECK CONSTRAINT can be used to check for the insertion of only valid values in a column. It can be applied on multiple columns to check the entry of valid values. 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 A 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'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: 134

James works as an Access Developer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer contains a database named Sales created in Access 2007. The database contains a table named Orders. James has to create a form which will display the data from the table one at a time. He wants to access the controls programmatically so that he can connect them to the table. Which of the following properties will he use to access the controls?


  1. Name

  2. ControlSource

  3. Can Grow

  4. TextFormat


Answer: A


Explanation:

The name property refers to the name given to a control in a form or a report. The default name of the control is the control name plus 1, 2, 3, etc. The name of the control should be meaningful so that it can be easily used during programming. The value of this property cannot be changed programmatically. It can be changed only in design view.

Answer B is incorrect. The ControlSource property bounds a control to a field of a

table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control.

Answer D is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting. Answer C is incorrect. The Can Grow property allows a control to adjust its dimensions according to the contents present in 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.


Microsoft 77-605 Exam (MOS Using Microsoft Office Access 2007) Detailed Information

77-605 - MOS Using Microsoft Office Access 2007


77-605 Test Objectives


Structure a database (10‒15%)
  • Define data needs and types; define and print table relationships; add, set, change, or remove primary keys; split databases
Preparation resources
  • Create or remove a primary key
  • Split an Access database
Create and format database elements (35‒40%)
  • Create databases, create tables, modify tables, create fields and modify field properties, create forms, create reports, modify the design of reports and forms
Preparation resources
  • Create a new database
  • Create tables for a new Access 2007 database
  • Create forms for a new Access 2007 database
Enter and modify data (5‒10%)
  • Enter, edit, and delete records; navigate among records; find and replace data; attach documents to and detach from records; import data
Preparation resources
  • Add one or more records to a database
  • Attach files and graphics to the records in your database
  • Learn how to import or link to data
Create and modify queries (15‒20%)
  • Create queries, modify queries
Preparation resources
  • Introduction to queries
  • Tips and techniques for queries in Access 2007
  • Create queries for a new Access 2007 database
Present and share data (10‒15%)
  • Sort data, filter data, create and modify charts, export data, save database objects as other file types, print database objects
Preparation resources
  • Datasheets II: Sum, sort, filter, and find your data
  • Export a database object to another Access database
  • Export data to Excel
Manage and maintain databases (15%)
  • Perform routine database operations, manage databases
Preparation resources
  • Datasheets III: Make data easier to read by formatting columns and rows
  • Easy Access with templates II: Modify a database
  • Encrypt a database by using a database password



HGCSOFT Sitemap
HGCSOFT PDF SITEMAP
AT-Capital
Top Softwares for Download
Pass4sure
Certification Exams Database