MOS: Using Microsoft Office Access 2007 v6.0 (77-605)

Page:    1 / 8   
Total 127 questions

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named
Employees. You have to add and delete some records in the table according to your requirement. Which of the following views can you use to accomplish this task?

  • A. Design
  • B. Datasheet
  • C. Table
  • D. Pivot Chart


Answer : B

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 Sales. The database contains several tables. James wants to ensure that a tablenamed SalesInfo will be displayed as PivotChart. Which of the following properties of the table will he modify to accomplish the task?

  • A. Default View
  • B. Format
  • C. ivotChart View
  • D. Orientation


Answer : A

Explanation: In order to accomplish the task, James will use the Default View property.
This property contains three settings, which are as follows: Datasheet PivotTable
PivotChart The default setting is Datasheet. James will change the setting to the PivotChart to change the display of the table.

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 Human Resource. The database contains several forms, tables and queries. James has to manually create a report that will display records from EmpDept query, which contains the names of employees in the EmpName column and their concerning departments in the DeptName column. James creates a
TextBox control. He has to bind the TextBox to the EmpName property. Which of the following properties will he use to accomplish the task?

  • A. RowSource
  • B. ControlSource
  • C. TableSource
  • D. RecordSource


Answer : B

Explanation: In order to accomplish the task, James will use the ControlSource property.
The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control. Answer: D is incorrect.
The RecordSource property belongs to the form and report controls. This property is used to connect a form or report to a table or query. After setting the RecordSource property, a user can use the ControlSource property to bind the controls of a form or report. The
RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query.
When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property. Answer: A is incorrect. RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. Answer: C is incorrect. There is no such property as TableSource.

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 a
Microsoft Office Access 2007 database named Human Resource, which contains several tables. Peter has to create a form to display employee details. He creates a TextBox and binds it to a field of the Employees table. He finds that he is unable to populate any recordset from a query. Which of the following is the most likely cause of the issue?

  • A. The Format property of the TextBox is not set.
  • B. The RecordSource property of the form is not set.
  • C. The RowSource property of the TextBox is not set.
  • D. The Validation Rule property of the form is not set.


Answer : B

Explanation: In order to bind the Textbox to a field of the Employee table, Peter should set the ControlSource Property of the TextBox. The ControlSource property of a control
(TextBox, Comboboc, etc.) does not populate any recordset from a query if the
RecordSource property of the form is not set. The RecordSource property of a form should be set to a table in the current database to populate the ControlSource property with the fields of the table. Answer: A is incorrect. If the format property of a TextBox control is not set, the ControlSource property is not affected. Answer: C is incorrect. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. Answer: D is incorrect. A validation rule is a set of rules associated with a column so that a user is restricted from entering invalid data. A user can be restricted from entering data through the following options: Datatypes: When a field is assigned to a datatype, data of another type cannot be inserted in the field. Field size: The field size restricts the amount of data to be inserted in a table. Table Properties: Certain table properties such as Required forces a user to enter data or the Format property forces a user to enter data in a defined format. A validation rule can be applied by using the
Validation Rule property. A user can be intimated about the invalid data through the
Validation Text property.

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 Human Resource. The database contains a table named Employees. James has to create a form with a calculated control. The calculated control will calculate the monthly salary of the employees. Which of the following controls will James use to accomplish the task?

  • A. ComboBox
  • B. TextBox
  • C. Label
  • D. ListBox


Answer : B

Explanation: In order to accomplish the task, James will use the TextBox control. A
TextBox control is an editable control in which a user can edit and modify data. It is of the following types: Unbound: An unbound textbox control is an empty control. It is not bound to any column of any table. It can be bound to a column by using the ControlSource property. Bound: A bound textbox control is bound to a column of a table. It displays a single record of the column. Calculated: It can be used for calculations based on the expression provided in the textbox. Answer: D and A are incorrect. The list box and combo box controls are used to display all the items of one of more fields. These controls can be bound to a table by using the control wizard (Combo Box Wizard and List Box Wizard). The list box and combo box controls can also be bound to an individual column by using the
ControlSource property. In this case only one value will be displayed at a time. To display all the values of a column, a user should bind the list box control to the RowSource property. Answer: C is incorrect. The label control does not have the ControlSource property. So it can neither be bound to any column of any table nor used as a calculated control. A label control is used to provide a name to a bound control.

Which of the following will you use to create a detailed report containing enough information to rebuild the database structure?

  • A. Performance Analyzer
  • B. Database Documenter
  • C. Compact and Repair Database
  • D. Microsoft Office Diagnostics


Answer : B

Explanation: In order to create a report that contains enough information to rebuild the database structure, you should use the Database Documenter tool. It contains all information about the Microsoft Access objects such as tables, reports, macros, modules, forms, and queries in a database. A user can open this report in the Print Preview. Answer:
A is incorrect. The Performance Analyzer utility is used to analyze the performance of the
Microsoft Office Access objects such as tables, forms, macros, modules, reports, and queries in the database. This utility has three types of analysis results: ideas, suggestions, and recommendations. The user can instruct Access to optimize the database file by following through on any of the suggestions and recommendations.
Answer: C is incorrect. The Compact and Repair Database utility optimizes the performance of access files by rearranging how the file is stored on the hard disk and then attempts to remove the issues in tables, forms, reports, and modules. A user should use the Compact and Repair Database utility on a regular basis to ensure optimal performance.
If a major problem occurs while user is working in an Access file and Access attempts to recover it, the user will receive a message that the repair operation is cancelled and he should compact and repair the file. Answer: D is incorrect. The Microsoft Office Diagnostics utility has a series of diagnostic tests that helps a user to discover why the Microsoft Office programs are not working properly. The diagnostic tests provide the information about the problems, and ways to solve these problems. When Microsoft Office Diagnostics determines that data might help diagnose and fix a problem, the system asks the user whether he wants to tell the problem to the Microsoft. After completing all the tests, the user prompts to visit a Web page in order to get advice based the results of the tests.

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named
Employees with the following fields: Employee Name Employee ID Department Salary You want to view a list of fields in the table. In which of the following views will you open the table?

  • A. Layout
  • B. Datasheet
  • C. Pivot Table
  • D. Design


Answer : D

Which of the following sections of the Report Design view is used to print a distribution list, accounting information, or to identify information that is required for the report?

  • A. Detail
  • B. Page Header
  • C. Report Header
  • D. Page Footer


Answer : C

Explanation: Report Header is an optional section of the Report Design view. It is used to print a distribution list, accounting information, or to identify information that is required for the report. Answer: B is incorrect. Page Header is displayed at the top of each page. It includes a logo, column heading, page number, etc. Answer: A is incorrect. The Detail section displays the data and their associated labels that are included for the table or query fields added to the report. Answer: D is incorrect. Page Footer is displayed at the bottom of each page. It includes a report name, date and time, coding, page number, etc.

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 contains several tables, queries, forms, and reports. The database is locked by a user by saving it in .accdr format. Andrew has to unlock the database so that all the database objects can be modified. Which of the following actions will he take to accomplish the task?

  • A. Click the Office button and save the database to .accdb format.
  • B. In Windows Explorer, change the extension of the database to .accdt.
  • C. In Windows Explorer, change the extension of the database to .accdb.
  • D. In Windows Explorer, change the extension of the database to .accde.


Answer : C

Explanation: In order to accomplish the task, Andrew will change the extension of the
.accdr file to .accdb file. After changing the extension, Andrew can create, modify, or delete database objects. Answer: A is incorrect. If a database is saved in .accdr format, the save option is not available in the office button. Answer: D and B are incorrect. Changing the extension to either .accde or .accdt will not accomplish the task. In a .accde file a user cannot modify forms and reports. If the extension is converted to .accdt, invalid format error is displayed and database does not open.

Which of the following types of Microsoft Access object is described in the statement below? "It is a Microsoft Access object used to display specific fields from one or more tables so that the users can view, change, or analyze it in various ways. The users can design it to perform calculations such as sum, average, count, and can save this query for future use."

  • A. Table
  • B. Report
  • C. Form
  • D. Query


Answer : D

Explanation: A query is a Microsoft Access object used to display data from one or more tables so that users can view, change, or analyze it in various ways. The users can design a query to perform calculations such as sum, average, count and can save the query for future use. The queries can be viewed in the Datasheet view or Design view.
The common types of queries in Ms Access are as follows:

Select query -

Duplicate query -

Unmatched query -

Parameter query -

Crosstab query -

Action query -
Answer: A is incorrect. A table is the basic element of a database used to store data. All other objects such as indexes, functions, forms, reports, etc., are based on the table.
Without a table, a database is of no use. Tables can be used to create queries. These queries can retrieve data from one or more tables which are related to one another.
Answer: C is incorrect. A form is a window in which administrator can place controls that either provide information to the users or accept information that the users enter. Form provides an easy way to enter, retrieve, display and print information stored in tables. A user can view forms in Form view, Datasheet view, or Design view. Answer: B is incorrect.
Report is a Microsoft Access object used to display information from the tables in a nicely formatted and easily accessible way. The information can be displayed on computer screen or on paper. A report can contain information from multiple tables and queries, values calculated from information in the database, and formatting elements such as headers, footers, titles, and headings. A user can view reports in Design view, Print view, and Layout view. A user cannot edit data in a report.

Which of the following statements are true about the referential integrity? Each correct answer represents a part of the solution. Choose all that apply.

  • A. It ensures that the relationship between two tables remains synchronized during deletes.
  • B. It ensures that the relationship between two tables remains synchronized during updates.
  • C. It enforces data validity by restricting the datatype.
  • D. The foreign key in any referencing table must always refer to a valid row in the referenced table.


Answer : A,B,D

Explanation: Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table. Referential integrity ensures that the relationship between two tables remains synchronized during updates and deletes. For a foreign key to be valid, it must contain either the value NULL, or an existing key value from the primary or unique key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link to the primary key column should be created in the related table. Answer: C is incorrect. The domain integrity enforces data validity by restricting the datatype.

Peter 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. The database contains two tables named Products and Orders.
Peter creates a relationship between the Products and Orders tables. Which of the following types of data integrity has he applied?

  • A. Domain
  • B. Referential
  • C. Entity
  • D. Primary key


Answer : B

Explanation: Peter has applied a referential integrity. Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table.
Referential integrity ensures that the relationship between two tables remains synchronized during updates and deletes. For a foreign key to be valid, it must contain either the value
NULL, or an existing key value from the primary or unique key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link to the primary key column should be created in the related table. Answer: A is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table. Answer: C is incorrect. Entity integrity enforces the uniqueness of rows in a table.
The uniqueness of rows can be enforced by the identifier column(s) through indexes,
UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties. Answer: D is incorrect. Primary key is not a type of data integrity. A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column
(or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column.

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. Peter has to delete some tables from the database through SQL statements. Which of the following statements will he use to accomplish the task?

  • A. DROP TABLE <table_name> FROM DATABASE
  • B. DROP TABLE <table_name>
  • C. DELETE TABLE <table_name> FROM DATABASE
  • D. DELETE TABLE <table_name>


Answer : B

Explanation: In order to accomplish the task, Peter will use the following statement: DROP
TABLE <table_name> Here, the DROP TABLE statement is used to drop the table and the
<table_name> specifies the name of the table to be deleted. The drop table statement removes the table from the database. It can only be recovered if the backup of the database is present. Answer: A is incorrect. The DROP TABLE <table_name> FROM
DATABASE generates an error. Answer: C and D are incorrect. There is no such statement as DELETE TABLE.

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 wants to establish a relationship between two tables named Employees and Department. Which of the following rules will Andrew take into consideration while establishing this relationship?

  • A. The datatype of the primary key column must be compatible with the datatype of the foreign key column.
  • B. The primary key column name must match with the foreign key column name.
  • C. The NOT NULL attribute should be defined for the primary key column and the foreign key column.
  • D. The name of the primary key table and the foreign table must be the same.


Answer : A

Explanation: When a relationship is to be established between two tables, the datatype of the primary key column and the foreign column must be the same. If the datatypes are not same, the relationship will be established but data cannot be retrieved by creating a query that will join two tables. It will give type mismatch error. Answer: B is incorrect. It is not mandatory to give same names for the primary key and the foreign key columns. But datatype compatibility is mandatory. Answer: D is incorrect. A database cannot have two tables with the same name. Answer: C is incorrect. The NOT NULL attribute is mandatory for the primary key column as it does not accept null values. But the NOT NULL attribute is not mandatory for the foreign key column.

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 2007 database named Human Resource. Users use a Visual basic application to retrieve data from the database. Andrew wants to ensure that users are not directly connected to the tables in a database. Which of the following objects will he create to accomplish the task?

  • A. A form
  • B. A temporary table
  • C. A query
  • D. A report


Answer : C

Explanation: In order to accomplish the task, Andrew will create a query. A query can be created for either a single table or joining two or more tables. The query acts as a virtual table and users can retrieve data from it. The Visual Basic application can be connected to the fields of query to retrieve data. Answer: A, D, and B are incorrect. A Visual Basic application cannot be connected to a form, report, or macro.

Page:    1 / 8   
Total 127 questions