Access 2010 (PDF)

Document Sample
Access 2010 (PDF) Powered By Docstoc
					                                                                                              Microsoft
                                          77-885




Access 2010
                              Click the link below to buy full version as Low as $25

                                      http://www.examkill.com/77-885.html




       ExamKill is team of experienced and educated professionals working day and night to develop
       preparation material for different fields in IT. These industries are including HP, IBM, Comptia,
       Orcale, Apple, Adobe, Nortel, Novell, Checkpoint etc with the following features.

       Free Samples:       Free samples download are available for almost every product to check before
       buy.

       Complete Course Coverage: Experienced professionals are making sure to cover
       complete course so that you pass final exam.

       Updated Material: Preparation material is updated and new; you can compare us with other
       providers in the same industry.

       Privacy Protection:         Examkill team makes sure not to reveal your private information
       including your credit card and other secret information.

       Excellent Customer Support: You will get reply from examkill support within 8 hours
       for all your questions/concerns about anything.




                                                                                        www.examkill.com
                                               Question: 1
James works as a Database Designer for Tech Perfect Inc. He wants to prevent the Navigation Pane from
appearing by default in Microsoft Office Access 2010. Which of the following steps will James take to find
the option for this task?

A. New > Options > Current database
B. Home > View > Options
C. Database Tools > Options > Access Database
D. Create > Options > Templates



                                                Answer: A
Explanation:
James will take the following steps to find the option for the given task:
New > Options > Current database




http://www.examkill.com/77-885.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper                                        2
Answer. options B, C, and D are incorrect. These are not valid steps to find the option for the given task.



                                              Question: 2
You are working on a home computer with Microsoft Office 2010 installed on it. You have created a number
of databases using Microsoft Access 2010. You have also created macros for all these databases. Now, you
want to ensure that the other person who uses your computer system cannot open unsigned Access 2010
databases. Which of the following options will you choose to accomplish the task?

A. Disable All Macros Without Notification
B. Disable All Macros Except Digitally Signed Macros
C. Disable All Macros With Notification
D. Disable All Macros


                                               Answer: B


http://www.examkill.com/77-885.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper                                          3
Explanation:

The various options available in MS Access 2010 to handle macros are as follows:
• Disable All Macros Without Notification: It allows MS Access to disable all macros and does not display
any security warnings for enabling them.
• Disable All Macros With Notification: It is the default setting and allows MS Access to disable all macros
and display the security warnings.
• Disable All Macros Except Digitally Signed Macros: It allows MS Access to automatically enable the
macros that are digitally signed.
• Enable All Macros: It is not a recommended option. The Enable All Macros option allows MS Access to
enable all macros. It decreases security by allowing malicious code to run undetected.
Answer. option D is incorrect. It is not a valid option



                                              Question: 3
James works as a Database Designer for Tech Perfect Inc. He has to create a query that will extract the name
and address of each customer who has made more than one order. Which of the following Query wizards
should he use to accomplish the task?

A. Find Unmatched
B. Crosstab
C. Find Duplicates
D. Simple


                                               Answer: C
Explanation:
In order to accomplish the task, James should use the Find Duplicates Query wizard. This wizard is used to
set up a query in order to locate records. These records contain the same data in one or more specified
fields.
Answer. option D is incorrect. He can use the Simple Query wizard to extract the name and address of each
customer who has ever made an order.
Answer. option A is incorrect. He can use the Find Unmatched Query wizard to locate the customers who
do not have made any order.
Answer. option B is incorrect. He can use the Crosstab Query wizard to calculate and re-organize data for
making the analysis easy.




http://www.examkill.com/77-885.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper                                         4
                                              Question: 4
You work as a Database Documenter for Tech Perfect Inc. You have a database named Database1 created in
Microsoft Office Access 2010. This database contains three tables named Products, Orders, and Order
Details. You want to manage the tables in such a way that each record in the Orders table will have many
records in the Products table and each record in the Products table will have many records in the Orders
table. What should you do to accomplish the task?

A. Create a one-to-many relationship.
B. Create a one-to-one relationship.
C. Create a container-managed relationship.
D. Create a many-to-many relationship.


                                               Answer: D
Explanation:
In order to accomplish the task, you should create a many-to-many relationship between the Orders table
and the Products table. You can define this relationship by creating two one-to-many relationships to the
Order Details table.
Answer. option B is incorrect. A one-to-one relationship is created between two tables in which each record
in one table can have only one related record in another table.
Answer. option A is incorrect. A one-to-many relationship is created between two tables in which a row in
the first table can have one or more matching rows in the second table, but a row in the second table can
have only one matching row in the first table.
Answer. option C is incorrect. The Microsoft Office Access does not have this kind of relationship.



                                              Question: 5
James works as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has a database named Accounts and two
tables named Table1 and Table2, which are created in Microsoft Office Access 2010. He wants to apply
referential integrity to establish a relationship between these tables. Which of the following are required to
accomplish the task?

A. Table1 and Table2 are related to the same database.
B. The common field is the primary key of the primary table.
C. The related fields contain the same format.
D. Table1 and Table2 are related to different databases.


                                             Answer: BCA
Explanation:
The following are required for establishing a referential integrity between two tables:
• The common field is the primary key of the primary table.


http://www.examkill.com/77-885.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper                                          5
• The related fields contain the same format.
• Both tables are related to the same database.
Answer. option D is incorrect. This is not required to establish a relationship between these tables.




http://www.examkill.com/77-885.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper                                           6
                          77-885                                      Microsoft


Access 2010

          Click the link below to buy full version as Low as $25

            http://www.examkill.com/77-885.html




 We also provide PDF Training Material for:


                          Hot Exam

 MB6-870       MB6-869                   70-630          70-445

 MB3-860       70-512                    MB3-862         70-536

 70-860        70-513                    MB3-861         MB6-869

 70-686        70-663                    70-515          MB6-870
                                                                   www.examkill.com
 70-680       70-561                     70-685          70-401

 70-649       70-400                     70-562          70-433

 70-620       70-236                     70-638          70-452




 http://www.examkill.com/77-885.html
 Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper             7

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:4/25/2012
language:English
pages:7