MS Access 2003, Databases

Question: A query that uses the BETWEEN syntax for two numbers is identical to:
A
>= and <=

B
> and <

C
>= and <

D
> and <=

E
No such syntax

Note: Not available
1. Report
Question: How can the duplicate data on a report be hidden?
A
By Setting the HideDuplicates property to Yes

B
By Setting the DuplicateRecords property to No

C
By Setting the DuplicateRecords property to No and setting the GrpKeepTogether property to Per Page

D
Duplicate Data should be handled at the time of data entry and cannot be controlled while reporting

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: How do you start an Access application so that the user can't see or use the 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 .

Note: Not available
1. Report
Question: How is data in a single record kept together on a page (for a report) or on a column (for a form)?
A
By setting the KeepTogether property to Yes

B
By setting the SinglePagePrint property to Yes

C
By setting the DataTogether property to Yes

D
This feature is currently not available in Access

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: What is the function of a Format Painter?
A
It copies a Table Design to the buffer for later use

B
It copies a control's format to another control

C
It helps to format a report so that it looks tidy and presentable

D
It copies a report design to the buffer for later use

Note: Not available
1. Report
Question: Under the Advanced options for the Access system, there is an option entitled Open Databases Using Record Level Locking. Which of the following are true when this option is checked?
A
Microsoft Access locks the row that is being updated

B
Microsoft Access locks the page that is being updated

C
Microsoft Access locks the table that is being updated

D
Microsoft Access locks the database that is being updated

Note: Not available
1. Report
Question: Which of the following is not a section of a report?
A
Summary

B
Detail

C
Group Footer

D
Report Footer

Note: Not available
1. Report
Question: The primary key index does not allow ________ data in a field.
A
numeric

B
character

C
date

D
duplicate

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: A query that uses the BETWEEN syntax for two numbers is identical to:

Question: How can the duplicate data on a report be hidden?

Question: Which of the following is the easiest and fastest method to manipulate records on a subform?

Question: How do you start an Access application so that the user can't see or use the database container?

Question: How is data in a single record kept together on a page (for a report) or on a column (for a form)?

Question: How do you customize the text on a form or report's window frame or tab?

Question: What is the function of a Format Painter?

Question: Under the Advanced options for the Access system, there is an option entitled Open Databases Using Record Level Locking. Which of the following are true when this option is checked?

Question: Which of the following is not a section of a report?

Question: The primary key index does not allow ________ data in a field.