Microsoft 77-605 - MOS: Using Microsoft Office Access 2007 Exam
Page: 1 / 24
Total 120 questions
Question #1 (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 a
Microsoft Office Access 2007 database named Human Resource. The database contains
several tables and queries. The database contains a query named EmpDept, which
displays the names of employees and their concerned departments through EmpName and
DeptName columns. The structure of the query is given in the image below:
[Microsoft-77-605-6.0/Microsoft-77-605-2_2.png]
When James tries to insert data, he receives an error. Which of the following is the most
likely cause of the error?
Vista-based computer with Microsoft office 2007 installed on it. The company uses a
Microsoft Office Access 2007 database named Human Resource. The database contains
several tables and queries. The database contains a query named EmpDept, which
displays the names of employees and their concerned departments through EmpName and
DeptName columns. The structure of the query is given in the image below:
[Microsoft-77-605-6.0/Microsoft-77-605-2_2.png]
When James tries to insert data, he receives an error. Which of the following is the most
likely cause of the error?
A. The query does not contain the primary key column.
B. Insertion of data cannot be done through a query.
C. The query does not contain the foreign key column.
D. The query is connected to two tables.
Answer: B
Question #2 (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 company uses
Microsoft Office Access 2007 database named Sales. The database has a table named
OrderDetails. The table has a column named Price. He applies a CHECK constraint on the
column to specify that the price of a product should be between $20 and $2000. He inserts
data in the table to test the constraint. He finds that the constraint is not working correctly.
He wants to modify the CHECK constraint. Which of the following statements will he 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 has a table named
OrderDetails. The table has a column named Price. He applies a CHECK constraint on the
column to specify that the price of a product should be between $20 and $2000. He inserts
data in the table to test the constraint. He finds that the constraint is not working correctly.
He wants to modify the CHECK constraint. Which of the following statements will he use to
accomplish the task?
A. ALTER TABLE
B. ALTER CHECK CONSTRAINT
C. ALTER COLUMN
D. ALTER CONSTRAINT
Answer: A
Question #3 (Topic: )
Which of the following datatypes generates a consecutive number that can be used as the
primary key of a table?
primary key of a table?
A. OLE Object
B. Currency
C. Hyperlink
D. AutoNumber
Answer: D
Question #4 (Topic: )
You are creating a new report named Report1 in Microsoft Office Access 2007 using the
Report Design feature. This feature opens a report layout in the Design view that includes
three standard sections by default. What are these three sections? Each correct answer
represents a complete solution. Choose three.
Report Design feature. This feature opens a report layout in the Design view that includes
three standard sections by default. What are these three sections? Each correct answer
represents a complete solution. Choose three.
A. Page Footer
B. Group Header/Footer
C. Report Header/Footer
D. Detail
E. Page Header
Answer: A,D,E
Question #5 (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 has a
database named Sales created in Microsoft Office Access 2007. The database contains
two tables named Employees and Department. Both the tables are related to each other
through a column named EmpID. Andrew creates a query to retrieve the records from both
tables.
[Microsoft-77-605-6.0/Microsoft-77-605-6_2.png]
When he runs the query he gets the following error: Type mismatch in expression Which of
the following is the cause of the error?
Vista-based computer with Microsoft Office 2007 installed on it. The computer has a
database named Sales created in Microsoft Office Access 2007. The database contains
two tables named Employees and Department. Both the tables are related to each other
through a column named EmpID. Andrew creates a query to retrieve the records from both
tables.
[Microsoft-77-605-6.0/Microsoft-77-605-6_2.png]
When he runs the query he gets the following error: Type mismatch in expression Which of
the following is the cause of the error?
A. The datatype of the EmpID column is different in both tables.
B. Incorrect table name is used in the query.
C. The Employees table is damaged.
D. The record in the EmpID column is deleted in the primary key table.
Answer: A
