MS Access 2007 Test

MS Access 2007 Test

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

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

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

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

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

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

Which of the following clauses is not allowed in a sub-query?

a. is Null

b. where

c. order by

Which of these functions determines if a phrase exists in a longer string?

a. InStr

b. Len

c. Trim

d. Left

How many databases can be opened at one time in a single instance of Access 2007?

a. One

b. Two

c. Ten

d. Unlimited

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

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.

What type of query do you use to modify existing records

a. Insert query

b. Delete query

c. Update query

d. Select query

State whether true or false.

In Access 2007, a Checkbox cannot be used as a calculated control

a. True

b. False

Out of the following, which one can be used as a comparison operator?

a. &

b. >

c. ^

d. +

How do you import a portion of an Excel spreadsheet into Access?

a. TransformXML Method

b. ImportXML Method

c. TransferSpreadsheet Method

Which textbox property determines that the text box is bound?

a. ControlSource

b. RowSource

c. RecordSource

d. FieldSource

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

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.

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

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.

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'

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

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

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

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

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')

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

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

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

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

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

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

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

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

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

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

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

In which of the following form sections is a Title control placed?

a. Detail

b. Form Header

c. Page Header

d. Page Footer

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.

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