MS Access 2003, Databases

Question: Which of the following statements is correct regarding Crosstab queries?
A
Multiple Value fields can be specified

B
Multiple Column Headings can be specified

C
Multiple Row headings can be specified

Note: not sure
1. Report
Question: Which property of the Group Header, group footer, or detail section should be changed if we want each group or record in a report to start on a new page?
A
NewRowOrCol property

B
ForceNewPage property

C
SetNewPage property

D
ForceNewRow property

Note: not sure
1. Report
Question: If a table named students has a column called Studentname storing the names of the students, what will be the correct query to display the names of the students in reverse alphabetical order?
A
Select Studentname from students reverse

B
Select Studentname from students reverse name

C
Select Studentname from students order by name descending

D
Select Studentname from students order by name Reverse

E
Select Studentname from students order by Studentname desc

F
Select desc Studentname from Students

G
Select Reverse Studentname from Students

Note: not sure
1. Report
Question: What type of query do you use to modify existing records
A
Insert query

B
Delete query

C
Update query

D
Select query

Note: not sure
1. Report
Question: What role does Strcomp function perform in Microsoft Access 2003?
A
It compares the length of two strings and returns the value 1 if the difference is even and the value 0 if the difference is odd

B
It compares the number of capital letters, small letters and spaces in two strings and returns the result as an integer between 0 and 255

C
It compares the number of blank spaces contained in two different strings and returns the difference as an integer

D
It compares two strings for equivalence and returns the integer result of the comparison

Note: not sure
1. Report
Question: Which of the following enhanced security features are included in Access 2003?
A
Enhanced security features to help decrease the chances of Access 2003 being targeted in malicious attacks

B
Enhanced security features for Microsoft Jet functions

C
Digital signatures

D
All of these above

Note: not sure
1. Report
Question: Which form property determines whether the current record has been modified since it was last saved?
A
Dirty property

B
LocationOfComponents Property

C
Dependencies Property

D
ServerFilterByForm Property

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

Note: not sure
1. Report
Question: What property for 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: A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named Query1, which combines the data from the tables. If the Products table is deleted, what will happen when users run Query1?
A
Only the data of the Products table will be retrieved.

B
Only the data of the Orders table will be retrieved.

C
An error will be generated.

D
The data will be successfully retrieved.

Note: not sure
1. Report

First Prev 3 4 5 6 Next Last

Question: Which of the following statements is correct regarding Crosstab queries?

Question: Which property of the Group Header, group footer, or detail section should be changed if we want each group or record in a report to start on a new page?

Question: If a table named students has a column called Studentname storing the names of the students, what will be the correct query to display the names of the students in reverse alphabetical order?

Question: What type of query do you use to modify existing records

Question: What role does Strcomp function perform in Microsoft Access 2003?

Question: Which of the following enhanced security features are included in Access 2003?

Question: Which form property determines whether the current record has been modified since it was last saved?

Question: What is Option Explicit?

Question: What property for a table is used to locate the back-end database, to which the table is linked?

Question: A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named Query1, which combines the data from the tables. If the Products table is deleted, what will happen when users run Query1?