77-885
Microsoft
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
Microsoft
77-885
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
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
www.examkill.com
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper
7