Expert
This test is about 40
multiple choice questions and should take less than 40 minutes to complete
MS Access 2007 Test Contents
Forms
Queries
Tables
Access Interface
Access Database
Reports
File Management and Sorting
Working with SharePoint Sites
and Expressions
Macros and Programmability
MS Access 2007 Test
Question: 1
Which of the following table
properties defines criteria to display only matching rows in the Datasheet
view?
a. SubdatasheetName
b. ValidationText
c. ValidationRule
d. Filter
Question: 2
How do you create a report
for a crosstab query if certain column values are missing?
a. Set the Value field in the
crosstab
b. Set the Column Heading
field in the crosstab
c. Explicitly set the Pivot
list in the crosstab
Question: 3
The Database Splitter is one
of the database utilities. Which of the following is true about the Database
Splitter?
a. This utility segregates
the tables from the queries, forms, reports, macros, modules, and shortcuts to
the Data Access Pages
b. This utility splits a
Microsoft Access database into three files
c. This utility breaks up the
information in the tables into a compacted format for faster retrieval
Question: 4
How do you customize the text
on a form or report's window frame or tab?
a. TabIndex Property
b. Text Property
c. Form Property
d. Caption Property
Question: 5
By using ADO or DAO, how can
you fetch the records from a recordset?
a. By using a For Loop with
Next, without MoveNext, while checking for EOF
b. By using a Do..Loop with
MoveNext, while checking for EOF
c. By using a While Loopwith
Wend, while checking for EOF
Question: 6
Which of the following
clauses is not allowed in a sub-query?
a. is Null
b. where
c. order by
Question: 7
Which of these functions
determines if a phrase exists in a longer string?
a. InStr
b. Len
c. Trim
d. Left
Question: 8
How many databases can be
opened at one time in a single instance of Access 2007?
a. One
b. Two
c. Ten
d. Unlimited
Question: 9
This question is based upon
the figure shown below
What is the function of the
'Single Step' tool in macros as shown in the picture?
a. When the macro is run in
this mode, each expression is saved one at a time
b. When the macro is run in
this mode, each action is performed one at a time
c. When this option is
clicked, all queries are saved in a single step
d. When this option is
clicked, all reports are saved in a single step
Question: 10
In a report with grouping,
how can you display the count of records in each group?
a. Add a text box to the
group's Footer section, and its control source to "=Count(*)"
b. Set the report's
"Group Count" property to True
c. Add a label to the group's
Header section, and set the Caption property to "Count Rows"
d. Add a Summary control to
the report's Footer section.
Question: 11
What type of query do you use
to modify existing records
a. Insert query
b. Delete query
c. Update query
d. Select query
Question: 12
Out of the following, which
one can be used as a comparison operator?
a. &
b. >
c. ^
d. +
Question: 13
How do you import a portion
of an Excel spreadsheet into Access?
a. TransformXML Method
b. ImportXML Method
c. TransferSpreadsheet Method
Question: 14
Which textbox property
determines that the text box is bound?
a. ControlSource
b. RowSource
c. RecordSource
d. FieldSource
Question: 15
Which of the following
functions returns an array, when a string is split using a delimiter?
a. Str function
b. String function
c. StringParts function
d. Split function
Question: 16
Which of the following is not
done when you compact a database?
a. Restructuring table
records and objects, and then stores them in successive memory blocks.
b. Databases linked to the
compacted database are compacted and repaired.
c. Restores table records
into their primary key order, if a primary key exists in the table
d. Reduces the physical size
of your database by making an exact duplicate of the database.
Question: 17
Which Text box property
should be set to expand the text box to display the whole text when there is
too much text to be accommodated in the text box in Access reports?
a. CanGrow
b. Reading Order
c. Display When
d. None of the above
Question: 18
Which of the following
options clears a sort order without affecting the current filter?
a. "Clear All
Sorts" button on the Home tab, in the Sort and Filter group.
b. "Unsort" button
on the Database Tools tab, in the Records group.
c. "Sorted" button
at the bottom of the Object window, next to the Record Navigator.
Question: 19
This question is based upon
the figure shown below
From the figure, how would you
filter the table to return only the students whose last name begins with 'a',
'o', or 'y'?
a. Select lastname from
students where lastname like '[a,o, y]*'
b. Select lastname from
students where lastname like '*[a, o, y]'
c. Select lastname from
students where lastname not like '*[a, o, y]'
d. Select lastname from
students where lastname not like '[a,o, y]*'
e. Select lastname from
students where lastname='a' or lastname='o'or lastname='y'
Question: 20
Which form property
determines whether the current record has been modified since it was last
saved?
a. Cycle property
b. Dirty property
c. Filter property
d. FilterOn property
Question: 21
This question is based upon
the figure shown below
In the given picture, a total
is accumulated from record to record across a group. Which feature has been
used to achieve this result?
a. Cumulative property
b. Totals property
c. Running sum property
d. None of the above
Question: 22
Which of the following is the
easiest and fastest method to manipulate records on a subform?
a. Using a RecordsetType
Property
b. Using a RecordSetClone
Property
c. Using a RecordSelectors
Property
d. Using a References
Property
Question: 23
Which lookup field property
determines the value from the RowSource that is stored in the lookup column?
a. Column Heads
b. Column Widths
c. Column Count
d. Bound Column
Question: 24
Consider the following
tables:
Books
---------
BookId
BookName
AuthorId
SubjectId
PopularityRating (the
Popularity of the book on a scale of 1 to 10)
Language (such
as French, English, German etc)
What is the query to
determine Which German books (if any) are more popular than all the French
books?
a. Select bookname from books
where language='German' and popularityrating =(Select popularityrating from
books where language='French')
b. Select bookname from books
where language='German' and popularityrating > (Select popularityrating from
books where language='French')
c. Select bookname from books
where language='French' and popularityrating > (Select max(popularityrating)
from books where language='German')
d. Select bookname from books
where language='German' and popularityrating >(Select max(popularityrating)
from books where language='French')
Question: 25
What is Option Explicit?
a. It is a Database object
b. Requires variable
declarations
c. It contains all of the
data access pages that are currently open in a Microsoft Access project
d. It contains all open
standard modules and class modules in a Microsoft Access database
Question: 26
How do you prevent a user
from skipping the startup routines when opening an application?
a. Set the database's
AllowBreakIntoCode property to False
b. Set the database's
AllowBypassKey property to False
c. Set the database's
AllowBuiltInToolbars property to False
d. Set the database's
StartupShowDBWindow property to False
Question: 27
Which of the following is
true about the Ribbon interface?
a. Ribbons can be dragged and
dropped to be on the side or the bottom of the screen.
b. Ribbons can be minimized
or collapsed
c. Ribbons can be replaced
with command bars
Question: 28
Which datatype would be the
most suitable to store a Hyperlink in a field of an Access 2007 table?
a. char
b. varchar
c. hyperlink
d. nchar
Question: 29
You want to create a table
that includes a Description field. If you want to ensure that the Description
field accepts rich text formatting, which datatypes should you use?
a. OLE Object
b. Memo
c. Attachment
d. Text
Question: 30
This question is based upon
the figure shown below
Which type of Control Layout
does the given picture display?
a. Tabular
b. Stacked
c. Static
d. Tab
Question: 31
Which of the following is not
true regarding naming a file?
a. File names are case
sensitive
b. File names can be up to
255 characters long including any file name extension
c. Either uppercase or
lowercase letters can be used in file names
d. Some keyboard characters
can cause unexpected results if used in file names
Question: 32
Which of the given text field
properties should you set in order to force a user to enter a date value
specifically in MM-DD-YYYY format?
a. Indexed
b. Limit to List
c. Input Mask
d. Allow Value List Edits
Question: 33
How can you tell if a report
has no records to display or print?
a. NotInList event is
triggered
b. ApplyFilter event is
triggered
c. NoData event is triggered
d. Filter event is triggered
Question: 34
This question is based upon
the figure shown below
Refer to the given picture
and fill up the blank.
"Count Values" are
not available for fields of the _________ data type(s) while using the Layout
view.
a. Memo
b. OLE Object
c. Hyperlink
d. Memo, OLE Object and
Hyperlink
Question: 35
What does an Access Data
Projects (ADP) offer that an MDB/ACCDB doesn't?
a. It can perform
heterogeneous queries across a variety of data sources
b. It is tied directly to one
SQL Server database and can create and modify SQL Server objects
c. It supports temporary
tables or links to other data sources beyond the single SQL Server database
Question: 36
In which of the following
form sections is a Title control placed?
a. Detail
b. Form Header
c. Page Header
d. Page Footer
Question: 37
How do you start an Access
application so that the user can't see or use the Navigation Pane (or database
container)?
a. Set the Access Option to
hide the navigation pane, and press CTRL+F11 special keys.
b. Set the Access Option to
hide the navigation pane, and press ALT+F1 special keys.
c. Set the Access Option to
hide the navigation pane, and turn off special keys to prevent F11.
d. Set the Access Option to
hide the navigation pane, and press CTRL+G special keys.
Question: 38
Choose the appropriate Query
for the Products table where data should be displayed primarily in ascending
order of the ProductGroup column. Secondary sorting should be in the descending
order of the CurrentStock column.
a. Select * from Products
order by CurrentStock,ProductGroup
b. Select * from Products
order by CurrentStock DESC,ProductGroup
c. Select * from Products
order by ProductGroup,CurrentStock
d. Select * from Products
order by ProductGroup,CurrentStock DESC
e. None of the above
Question: 39
State whether the following
statement is true or false:
By default, Access deletes
the related data when records from a table are deleted.
a. True
b. False
Question: 40
State whether true or false.
In Access 2007, a Checkbox
cannot be used as a calculated control
a. True
b. False
No comments:
Post a Comment