Microsoft 77-605 - MOS: Using Microsoft Office Access 2007 Exam

Page:    1 / 24   
Total 120 questions

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:


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

Explanation: The image shows a Select Query. So, James cannot insert data in the table while he is working with the Select Query. He can use this query to retrieve data from one or more tables and display the results in a datasheet. He can also use this to group records and calculate sum, counts, averages, and other types of totals. Answer: C is incorrect. The insertion of data through a query does not depend on the foreign key column. If a query does not contain a foreign key, data can be successfully inserted. Answer: D is incorrect.
Insertion of data through a query does not depend on the number of tables to which the query is connected. Answer: A is incorrect. If a primary key column is included in the query, data can be inserted. A primary key column does not accept blank entries or null values. It must contain valid data. It is important for the user when he is not working with the Select
Query.

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?

  • A. ALTER TABLE
  • B. ALTER CHECK CONSTRAINT
  • C. ALTER COLUMN
  • D. ALTER CONSTRAINT


Answer : A

Explanation: In order to accomplish the task, Andrew will use the ALTER TABLE statement. This statement is used to add, modify, delete, enable or disable the CHECK constraint. Andrew will have to delete the existing CHECK constraint and recreate the constraint.Answer: B is incorrect. The ALTER COLUMN statement can be used to add, modify, delete, enable or disable the CHECK constraint, but it is used only within the
ALTER TABLE statement.Answer: C and D are incorrect. There are no such statements as
ALTER CHECK CONSTRAINT or ALTER CONSTRAINT.

Which of the following datatypes generates a consecutive number that can be used as the primary key of a table?

  • A. OLE Object
  • B. Currency
  • C. Hyperlink
  • D. AutoNumber


Answer : D

Explanation: The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table.
The increment can be changed through the New Values property. This property has the following two values:

Increment -

Random -
The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table.
Answer: B is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows:

General Number -

Currency -

Euro -

Fixed -

Standard -

Percent -

Scientific -
Answer: C is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink. Answer: A is incorrect. The OLE Object datatype is used to attach files and add binary data to a table.
This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.

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.

  • A. Page Footer
  • B. Group Header/Footer
  • C. Report Header/Footer
  • D. Detail
  • E. Page Header


Answer : A,D,E

Explanation: The following sections are included in the default layout of the Report Design view:
1. Page Header: It is displayed at the top of each page. Page Header includes a logo, column heading, page number, etc.
2. Detail: It displays the data and their associated labels that are included for the table or query fields added to the report.
3. Page Footer: It is displayed at the bottom of each page. Page Footer includes a report name, date and time, coding, page number, etc.
Answer: B and C are incorrect. These sections are not included in the default layout of the
Report Design view. However, they can be added to the Report Design view.

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.


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

Explanation: The Type mismatch in expression error occurs when the datatype of a primary key column and the foreign key column joining the two tables is assigned to different datatypes. To troubleshoot this error, both the fields must have same datatype.
Answer: B is incorrect. In the query, the actual table names are not provided rather aliases are given to access the tables. Alias is a temporary name assigned to a table, view, column, or value, within a SQL statement. It can either be referred to in the statement in which it is defined or in an associated SQL *PLUS command. Answer: D and C are incorrect. If a record is deleted from a primary key or the foreign key columns or a table is damaged, it does not cause the type mismatch error.

Page:    1 / 24   
Total 120 questions