Question No : 10
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. James has to modify a table named Department. He wants to ensure
that other users could not open the database unless he has finished the work. Which of the following
options will he use to accomplish the task?
A. Open read-Only
B. Open Exclusive Read-Only
C. Open
D. Open Exclusive
Answer: D
Tuesday, 12 December 2017
Microsoft 77-605 Real Exam Dumps - Dumps4download
Question No : 9
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 computer contains a database named HumanResource created in Microsoft Office Access 2007. The database contains several tables. Andrew has to create a form for a table named Employee. He wants to ensure that the data of a table should be visible in the form as well as in the datasheet. He wants to create the form in the minimum possible time. Which of the following tools will he use to accomplish the task?
A. Form Design
B. Blank Form
C. Split Form
D. Form
Answer: C
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 computer contains a database named HumanResource created in Microsoft Office Access 2007. The database contains several tables. Andrew has to create a form for a table named Employee. He wants to ensure that the data of a table should be visible in the form as well as in the datasheet. He wants to create the form in the minimum possible time. Which of the following tools will he use to accomplish the task?
A. Form Design
B. Blank Form
C. Split Form
D. Form
Answer: C
Latest And Actual 77-605 Exam Dumps
Question No : 8
You have a home computer with Microsoft Office 2007 installed on it. Your friend James is working on a database file using Microsoft Office Access 2007. After half an hour, you open MS Access to check the database file. You get only the Home tab on the Office Fluent Ribbon, and other tabs, such as Create, External Data, and Database Tools are not displayed there. What is the cause of this issue?
A. The Allow Default Shortcut Menus check box is unchecked.
B. The Allow Full Menus check box is unchecked.
C. The Use Access Special Keys check box is unchecked.
D. The Display Navigation Pane check box is unchecked.
Answer: B
You have a home computer with Microsoft Office 2007 installed on it. Your friend James is working on a database file using Microsoft Office Access 2007. After half an hour, you open MS Access to check the database file. You get only the Home tab on the Office Fluent Ribbon, and other tabs, such as Create, External Data, and Database Tools are not displayed there. What is the cause of this issue?
A. The Allow Default Shortcut Menus check box is unchecked.
B. The Allow Full Menus check box is unchecked.
C. The Use Access Special Keys check box is unchecked.
D. The Display Navigation Pane check box is unchecked.
Answer: B
Latest 77-605 Exam Question Answers
Question No : 7
You are working on the Date/Time datatype of MS Office Access 2007. You want to add a number to the interval component of the date to yield a new date value. Which of the following functions will you use for this task?
A. DatePart(interval, date)
B. DateAdd(interval, number, date)
C. DateDiff(interval, date1, date2)
D. Date()
Answer: B
You are working on the Date/Time datatype of MS Office Access 2007. You want to add a number to the interval component of the date to yield a new date value. Which of the following functions will you use for this task?
A. DatePart(interval, date)
B. DateAdd(interval, number, date)
C. DateDiff(interval, date1, date2)
D. Date()
Answer: B
Microsoft 77-605 Real Exam Dumps
Question No : 6
Andrew 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 created in Microsoft Office Access 2007. Andrew has to create a table named Products. He has to create a Description column that accepts more than 300 characters. Which of the following datatypes will he use to accomplish the task?
A. Text
B. Attachment
C. OLE Object
D. Memo
Answer: D
Andrew 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 created in Microsoft Office Access 2007. Andrew has to create a table named Products. He has to create a Description column that accepts more than 300 characters. Which of the following datatypes will he use to accomplish the task?
A. Text
B. Attachment
C. OLE Object
D. Memo
Answer: D
Get 77-605 PDF With Actual Questions Answers
Question No : 5
Peter works as a Database Administrator 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 and queries. A table named SalesInfo contains millions of rows. Peter wants to split the table. Mark the tool, which Peter will use to split the table.
Peter works as a Database Administrator 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 and queries. A table named SalesInfo contains millions of rows. Peter wants to split the table. Mark the tool, which Peter will use to split the table.
Answer:
Microsoft 77-605 Real Exam Dumps - Dumps4download
Question No : 4
You work 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 Access1, which is created in Microsoft Access 2007. You have split the database in order to improve the performance. Which of the following information is distributed to the users accessing this database?
A. Back-end database
B. Entire database
C. .mdb file
D. Front-end database
Answer: D
You work 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 Access1, which is created in Microsoft Access 2007. You have split the database in order to improve the performance. Which of the following information is distributed to the users accessing this database?
A. Back-end database
B. Entire database
C. .mdb file
D. Front-end database
Answer: D
Latest And Actual 77-605 Exam Dumps
Question No : 3
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. Peter exports sales data to an Excel file named SalesReport. While exporting the data, the Export wizard asks to replace the existing file. When Peter clicked the Yes button, he got an error and data could not be exported successfully. Which of the following is the most likely cause of the issue?
A. The Excel file is opened.
B. The Excel file is deleted.
C. The Excel file is stored in another location.
D. The Excel file is corrupted.
Answer: A
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. Peter exports sales data to an Excel file named SalesReport. While exporting the data, the Export wizard asks to replace the existing file. When Peter clicked the Yes button, he got an error and data could not be exported successfully. Which of the following is the most likely cause of the issue?
A. The Excel file is opened.
B. The Excel file is deleted.
C. The Excel file is stored in another location.
D. The Excel file is corrupted.
Answer: A
Latest 77-605 Exam Question Answers
Question No : 2
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 HumanResource. 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.?
A. Use the IS NOT NULL clause in the fields.
B. Use the IS NOT EMPTY clause in the fields.
C. Use IsMissing in the fields.
D. Use "" in the fields.
Answer: D
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 HumanResource. 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.?
A. Use the IS NOT NULL clause in the fields.
B. Use the IS NOT EMPTY clause in the fields.
C. Use IsMissing in the fields.
D. Use "" in the fields.
Answer: D
Microsoft 77-605 Real Exam Dumps
Question No : 1
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 a table named Employees. The table contains several fields. James sets the Address field to Memo datatype and the name of the city to bold. Now he creates a form. What will happen when the Address field is displayed in the form?
A. It will generate an error.
B. The Address field will be added to the form and the data will be displayed as plain text.
C. The Address field will be added to the form but no data will be displayed.
D. The Address field will be added to the form and the data will be displayed same as in the table.
Answer: D
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 a table named Employees. The table contains several fields. James sets the Address field to Memo datatype and the name of the city to bold. Now he creates a form. What will happen when the Address field is displayed in the form?
A. It will generate an error.
B. The Address field will be added to the form and the data will be displayed as plain text.
C. The Address field will be added to the form but no data will be displayed.
D. The Address field will be added to the form and the data will be displayed same as in the table.
Answer: D
Subscribe to:
Posts (Atom)