Which of the following are required to accomplish the task?
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. James
wants to apply referential integrity to establish a relationship between these tables. Which of the
following are required to accomplish the task?
Each correct answer represents a part of the solution. Choose three.
Which of the following is the most likely cause of the issue?
Mark works as a System Analyst for Blue Well Inc. He uses Microsoft Outlook for task requesting and
emailing. MS Outlook has been configured to use an IMAP account. Mark has to prepare a business
report of the company. He assigns the task of writing the report to another employee of the
company. However, after assigning the task, he is not receiving updates of the assigned task. Which
of the following is the most likely cause of the issue?
Which of the following restricts a user from entering invalid data in the table columns?
Which of the following restricts a user from entering invalid data in the table columns?
Mark the button that you will click to perform the operations specified by the query.
You are working with a query created in Microsoft Access 2010. Mark the button that you will click
to perform the operations specified by the query.
Which of the following is the most likely cause of the issue?
David works as a Support Analyst for White Well Inc. He uses Microsoft Outlook for messaging and emailing. MS Outlook has been configured to use an IMAP account. He has created a custom field
Relation that represents the relation between the sender and receiver. He wants to find all e-mails
where relation is CEO. He opens the Advanced Find dialog box, clicks on the Advanced tab and then
selects the User defined fields option from the drop-down list. However, the Relation field is not
available to use. Which of the following is the most likely cause of the issue?
Mark the appropriate icon mentioned in the scenario.
You work as a Support Analyst for ABC Inc. You use Microsoft Outlook for e-mailing and scheduling.
You compose an email and set the importance level of the e-mail to high. The Information Bar of the
e-mail shows an icon indicating that the e-mail has a high level of importance. Mark the appropriate
icon mentioned in the scenario.
Which of the following capabilities does this object provide?
You are working on a home computer with Microsoft Office 2010 installed on it. You are creating a
form in Microsoft Office Access 2010 in order to control the execution of Access database
application. Which of the following capabilities does this object provide?
Each correct answer represents a complete solution. Choose all that apply.
Mark the button that you will choose to accomplish the task.
You work as a Database Developer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. You want to create a form that allows users to
browse to different forms and reports created in Microsoft Office Access 2010. Mark the button that
you will choose to accomplish the task.
Which of the following actions will he take to quickly accomplish the task?
Mark works as a System Analyst for Blue Well Inc. He uses Microsoft Outlook for messaging and emailing. MS Outlook has been configured to use an Exchange account. He works in the contacts
folder to create and organize contacts. He wants to create an e-mail message from the contact card
of the CEO of his company. Which of the following actions will he take to quickly accomplish the
task?
Which of the following actions will you perform to accomplish the task?
You have created a table named Books in Microsoft Office Access 2010. You have created a new field
to enter the Book ID. For this purpose, you need to set the Number datatype for the field. Which of
the following actions will you perform to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.