MS Access 2003, Databases

Question: How do you create a report for a crosstab query if certain column headings are missing?
A
Set the Value field in the crosstab

B
Set the Column Heading field in the crosstab

C
Set the Row Heading field in the crosstab

D
Explicitly set the Pivot list in the crosstab

Note: not sure
1. Report
Question: Which clause will be used to display the rows of a table in an ascending order of a particular column?
A
Where

B
Order By

C
Group By

D
Having

Note: not sure
1. Report
Question: 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

Note: not sure
1. Report
Question: Which property of a table is used to locate the back-end database to which the table is linked?
A
Dependencies Property

B
TableDefs Connect property

C
LinkChildFields Property

D
TableDefs orderbyon property

Note: not sure
1. Report
Question: Which datatype would be the most suitable to store a hyperlink in a field of an Access 2003 table?
A
Memo

B
varchar

C
Text

D
Hyperlink

Note: not sure
1. Report
Question: State whether True or False. Access 2003 provides theme support to Microsoft Windows XP.
A
True

B
False

Note: not sure
1. Report
Question: State whether True or False. When a table from an Access database is exported to another database format, Microsoft Access exports the table data and data definitions, as well as its properties (including constraints, relationships, and indexes).
A
True

B
False

Note: Not available
1. Report

First Prev 4 5 6 Next Last

Question: How do you create a report for a crosstab query if certain column headings are missing?

Question: Which clause will be used to display the rows of a table in an ascending order of a particular column?

Question: How can you tell if a report has no records to display or print?

Question: Which property of a table is used to locate the back-end database to which the table is linked?

Question: Which datatype would be the most suitable to store a hyperlink in a field of an Access 2003 table?

Question: State whether True or False. Access 2003 provides theme support to Microsoft Windows XP.

Question: State whether True or False. When a table from an Access database is exported to another database format, Microsoft Access exports the table data and data definitions, as well as its properties (including constraints, relationships, and indexes).