Microsoft 77-605 - MOS: Using Microsoft Office Access 2007 Exam
Page: 2 / 24
Total 120 questions
Question #6 (Topic: )
Which of the following field properties is mainly used for memo fields, and creates a field
value history to add new text to the field if it is set to 'Yes'?
value history to add new text to the field if it is set to 'Yes'?
A. Allow Zero Length
B. Input Mask
C. Append Only
D. IME Mode
Answer: C
Question #7 (Topic: )
John 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 db1 created in Microsoft Office Access 2007. John wants to open the
database in a shared mode. In which of the following modes will he open the database to
accomplish the task?
Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a
database named db1 created in Microsoft Office Access 2007. John wants to open the
database in a shared mode. In which of the following modes will he open the database to
accomplish the task?
A. Open exclusive
B. Open exclusive read-only
C. Open
D. Open read-only
Answer: C
Question #8 (Topic: )
Andrew 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 Human Resource. The database
contains a table named Employees. Users complain that they are not able to find an
employee name whose Last Name is Jackson. Andrew writes the following query to check
the table: SELECT * FROM Employees He finds that Jackson's name is misspelled. What
will Andrew do to resolve the issue? Each correct answer represents a complete solution.
Choose all that apply.
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. Users complain that they are not able to find an
employee name whose Last Name is Jackson. Andrew writes the following query to check
the table: SELECT * FROM Employees He finds that Jackson's name is misspelled. What
will Andrew do to resolve the issue? Each correct answer represents a complete solution.
Choose all that apply.
A. Use the UPDATE statement to modify the name
B. Open the table in the Design view to modify the name
C. Open the table in the PivotTable view to modify the name
D. Open the table in the Datasheet view to modify the name
Answer: A,D
Question #9 (Topic: )
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 computer contains a
database named Human Resource created in Microsoft Office Access 2007. James has to
create a table named Employees. He wants to create a column named Resume in which
one or more files can be stored. To which of the following datatypes will James assign the
column 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. James has to
create a table named Employees. He wants to create a column named Resume in which
one or more files can be stored. To which of the following datatypes will James assign the
column to accomplish the task?
A. Hyperlink
B. OLE Object
C. Attachment
D. Memo
Answer: C
Question #10 (Topic: )
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 Sales. The database contains a table
named Orders. James wants to ensure that the column named OrderDate should display
the current date if the value for that column is not provided. Which of the following functions
will James use in the Default Value property 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 a table
named Orders. James wants to ensure that the column named OrderDate should display
the current date if the value for that column is not provided. Which of the following functions
will James use in the Default Value property to accomplish the task?
A. Date()
B. IsDate()
C. Now()
D. DateValue()
Answer: A
