Important Note, Please Read Carefully
Other prep2pass products
A) Offline Testing engine
Use the offline Testing engine product topractice the questions in an exam environment.
Build a foundation of knowledge which will be useful also after passing the exam.
Latest Version
We are constantly reviewing our products. New material is added and old material is
revised. Free updates are available for 90 days after the purchase. You should check your
member zone at prep2pass and update 3-4 days before the scheduled exam date.
Here is the procedure to get the latest version:
1.Go towww.prep2pass.com
2.Click on Log in
3.The latest versions of all purchased products are downloadable from here. Just click the
links.
For most updates,it is enough just to print the new questions at the end of the new
version, not the whole document.
Feedback
If you spot a possible improvement then please let us know. We always interested in
improving product quality.
Feedback should be send to feedback@prep2pass.com. You should include the following:
Exam number, version, page number, question number, and your login Email.
Our experts will answer your mail promptly.
Copyright
Each iPAD file is a green exe file. if we find out that a particular iPAD Viewer file is
being distributed by you, prep2pass reserves the right to take legal action against you
according to the International Copyright Laws.
Explanations
This product does not include explanations at the moment. If you are interested in
providing explanations for this exam, please contact feedback@prep2pass.com.

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-2-

www.prep2pass.com Q: 1 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
HumanResource. The database contains a table named Employees. The table
contains several fields. James sets the Address field to Memo datatype and the name
of the city to bold. Now he creates a form. What will happen when the Address field
is displayed in the form?
A. It will generate an error.
B. The Address field will be added to the form and the data will be displayed as plain
text.
C. The Address field will be added to the form but no data will be displayed.
D. The Address field will be added to the form and the data will be displayed same as in
the table.

Answer: D
www.prep2pass.com Q: 2 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
HumanResource. A form named EmpForm is connected to the EmpQuery query.
The form contains a listbox that displays the values of a column named PhoneNo of
all the employees. Some of the employees do not have a phone. James wants to
ensure that the field related to those employees does not look blank. Which of the
following actions will he perform to accomplish the task.?
A.
B.
C.
D.

Use the IS NOT NULL clause in the fields.
Use the IS NOT EMPTY clause in the fields.
Use IsMissing in the fields.
Use "" in the fields.

Answer: D

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-3-

www.prep2pass.com Q: 3 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
Sales. Peter exports sales data to an Excel file named SalesReport. While exporting
the data, the Export wizard asks to replace the existing file. When Peter clicked the
Yes button, he got an error and data could not be exported successfully. Which of
the following is the most likely
cause of the issue?
A.
B.
C.
D.

The Excel file is opened.
The Excel file is deleted.
The Excel file is stored in another location.
The Excel file is corrupted.

Answer: A
www.prep2pass.com Q: 4 You work 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 Access1, which is created in Microsoft Access 2007. You
have split the database in order to improve the performance. Which of the following
information is distributed to the users accessing this database?
A.
B.
C.
D.

Back-end database
Entire database
.mdb file
Front-end database

Answer: D
www.prep2pass.com Q: 5 Peter 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
Sales. The database contains several tables and queries. A table named SalesInfo
contains millions of rows. Peter wants to split the table. Mark the tool, which Peter
will use to split the table.

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-4-

Answer: Check prep2pass eEngine, Download from Member Center
www.prep2pass.com Q: 6 Andrew 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 created in Microsoft
Office Access 2007. Andrew has to create a table named Products. He has to create a
Description column that accepts more than 300 characters. Which of the following
datatypes will he use to accomplish the task?
A.
B.
C.
D.

Text
Attachment
OLE Object
Memo

Answer: D
www.prep2pass.com Q: 7 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?
A.
B.
C.
D.

Answer: B
www.prep2pass.com Q: 8 You have a home computer with Microsoft Office 2007
installed on it. Your friend James is working on a database file using Microsoft
Office Access 2007. After half an hour, you open MS Access to check the database
file. You get only the Home tab on the Office Fluent Ribbon, and other tabs, such as
Create, External Data, and Database Tools are not displayed there. What is the
cause of this issue?
A.
B.
C.
D.

The Allow Default Shortcut Menus check box is unchecked.
The Allow Full Menus check box is unchecked.
The Use Access Special Keys check box is unchecked.
The Display Navigation Pane check box is unchecked.

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-5-

Answer: B
www.prep2pass.com Q: 9 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 HumanResource 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.
B.
C.
D.

Form Design
Blank Form
Split Form
Form

Answer: C
www.prep2pass.com Q: 10 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
HumanResource. James has to modify a table named Department. He wants to
ensure that other users could not open the database unless he has finished the work.
Which of the following options will he use to accomplish the task?
A.
B.
C.
D.

Open read-Only
Open Exclusive Read-Only
Open
Open Exclusive

Answer: D
www.prep2pass.com Q: 11 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
HumanResource. The database contains several tables. Peter has to delete the
records of an employee whose last name is Jackson. What will peter do to
accomplish the task?
A. Use the DELETE statement with the ORDER BY clause.
Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-6-

B. Use the DROP TABLE statement.
C. Use the DROP TABLE statement with the WHERE clause.
D. Use the DELETE statement with the WHERE clause.

Answer: D
www.prep2pass.com Q: 12 Which of the following filtering features is used to filter
records based on the values in fields of a table, query, or form?
A.
B.
C.
D.

Filter by Form
Filter by Selection
Filter by group
Advanced Filter

Answer: A
www.prep2pass.com Q: 13 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?

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-7-

A.
B.
C.
D.

The datatype of the EmpID column is different in both tables.
Incorrect table name is used in the query.
The Employees table is damaged.
The record in the EmpID column is deleted in the primary key table.

Answer: A
www.prep2pass.com Q: 14 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 Sales created in Microsoft
Office Access 2007. Andrew wants to ensure that the new databases should be saved
in the previous version of Microsoft Access. Mark the option in the Access Options
dialog box to accomplish the task.

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-8-

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

-9-

Answer: Check prep2pass eEngine, Download from Member Center
www.prep2pass.com Q: 15 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?
A.
B.
C.
D.

Date()
IsDate()
Now()
DateValue()

Answer: A
www.prep2pass.com Q: 16 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
HumanResource, 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.
B.
C.
D.

The Format property of the TextBox is not set.
The RecordSource property of the form is not set.
The RowSource property of the TextBox is not set.
The Validation Rule property of the form is not set.

Answer: B
www.prep2pass.com Q: 17 Andrew works as a Database Designer for AccessSoft
Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is
installed. The computer has a database named Sales, which is built in MS Access
2007. The office is situated in an area prone to power failure. Andrew has to save
the database to prevent any data loss. Which of the following will he use to
accomplish the task?
Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

Answer: A
www.prep2pass.com Q: 18 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. James imports Contacts table into the current database, which already
contains a table by the same name. Which of the following actions will take place in
this scenario?
A.
B.
C.
D.

The database will not import the table as a table with the same name already exists.
The table will be imported successfully with a different name.
The original table will be deleted.
Only data of the table will be imported as a table with the same name already exists.

Answer: B
www.prep2pass.com Q: 19 Choose and re-order the steps that you will take to
create one-to-many relationship in Microsoft Office Access 2007.

Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo

- 11 -

Answer: Check prep2pass eEngine, Download from Member Center
www.prep2pass.com Q: 20 You are working with Microsoft Office Access 2007.
You want to change the macro settings in the Trust Center for the Access 2007
program. Which of the following options will you choose to make your computer
system vulnerable to potentially malicious code?
A.
B.
C.
D.

Disable all macros without notification.
Disable all macros with notification.
Disable all macros except digitally signed macros.
Enable all macros.

Answer: D
Leading the way in IT testing and certification tools, www.Prep2Pass.com Demo