MS Access 2003, Databases

Question: Which of these functions determines if a phrase exists in a longer string?
A
InStr

B
Len

C
Trim

D
Left

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

Note: Not available
1. Report
Question: If a user has a database opened in the Exclusive mode, what will happen if another user attempts to open the same database?
A
The second user will receive the 'Permission denied' message

B
The second user can make changes to the file that has been opened by the first user, and the first user will receive the "File is being modified by another user" message

C
The second user receives the 'File already in use' message

D
Both users will receive the 'Permission denied' message

Note: Not available
1. Report
Question: What is the advantage of a Class module over Regular module, in Access database solution?
A
Encapsulation, inheritance

B
Data Abstraction

C
Polymorphism

D
Reusability

Note: not sure
1. Report
Question: On which event do you place code to validate the entry of an entire record?
A
BeforeUpdate

B
Initialize

C
Load

D
Click

Note: not sure
1. Report
Question: What does an MDB/ACCDB offer that isn't available in an ADP?
A
It can create client/server applications

B
It can create and modify SQL Server objects

C
It can perform heterogeneous queries across a variety of data sources

D
None of these

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

Note: not sure
1. Report
Question: In which of the following ways does choosing an appropriate datatype help while designing a table in Access?
A
It saves space in your database

B
It can improve join operations

C
It could lead to fast data retrieval and updates

D
All of these

Note: not sure
1. Report
Question: When a user has a database open in Exclusive mode, what will happen when another user attempts to open the database?
A
The second user receives a 'Permission denied' message

B
The second user can make the changes to the file that has already being opened by the first user and first user receives the "File is being modified by another user"

C
The second user receives a 'File already in use' message

D
Both the user will receives a 'Permission denied' message

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

B
CanGrow

C
Control Source

D
Name

Note: not sure
1. Report

First Prev 1 2 3 4 5 Next Last

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

Question: What does an Access Data Projects (ADP) offer that an MDB/ACCDB doesn't?

Question: If a user has a database opened in the Exclusive mode, what will happen if another user attempts to open the same database?

Question: What is the advantage of a Class module over Regular module, in Access database solution?

Question: On which event do you place code to validate the entry of an entire record?

Question: What does an MDB/ACCDB offer that isn't available in an ADP?

Question: How do you prevent a user from skipping the startup routines when opening an application?

Question: In which of the following ways does choosing an appropriate datatype help while designing a table in Access?

Question: When a user has a database open in Exclusive mode, what will happen when another user attempts to open the database?

Question: 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?