Microsoft 77-605 - MOS: Using Microsoft Office Access 2007 Exam
Page: 3 / 24
Total 120 questions
Question #11 (Topic: )
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 Human Resource. The database contains a
table named Employees. He wants to help users to select an employee name while filling a
form.. Which of the following controls will he use to accomplish the task? Each correct
answer represents a complete solution. Choose all that apply.
Vista-based computer with Microsoft Office 2007 installed on it. The company uses
Microsoft Office Access 2007 database named Human Resource. The database contains a
table named Employees. He wants to help users to select an employee name while filling a
form.. Which of the following controls will he use to accomplish the task? Each correct
answer represents a complete solution. Choose all that apply.
A. Combobox
B. Listbox
C. Textbox
D. Label
Answer: A,B
Question #12 (Topic: )
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?
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
Question #13 (Topic: )
Andrew works as a Database Designer for Access Soft 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. Andrew has to set a Default Value for a column named OrderDate in a table named
Orders. Which of the following views of the table will Andrew use to accomplish the task?
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. Andrew has to set a Default Value for a column named OrderDate in a table named
Orders. Which of the following views of the table will Andrew use to accomplish the task?
A. PivotTable
B. Datasheet
C. PivotChart
D. Design
Answer: D
Question #14 (Topic: )
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 Human Resource 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?
Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a
database named Human Resource 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
Question #15 (Topic: )
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 Human Resource created in Microsoft Office Access 2007. The database
contains a table named Employees. The table contains a field named Resume, which is set
to the Attachment datatype. Peter has to convert the database to the format of Microsoft
Access 2003. What will happen when Peter tries to accomplish this task?
Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a
database named Human Resource created in Microsoft Office Access 2007. The database
contains a table named Employees. The table contains a field named Resume, which is set
to the Attachment datatype. Peter has to convert the database to the format of Microsoft
Access 2003. What will happen when Peter tries to accomplish this task?
A. The database will be successfully converted to the .mdb file.
B. The database will be successfully converted to the .mdb file but Resume field will be deleted as older version does not support the Attachment datatype.
C. The database will be successfully converted to the .mdb file but Resume field will be set to the OLE Object datatype.
D. An error will occur and no conversion will take place.
Answer: D
