Databases - Upwork

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
Question: Using ADO or DAO, how are the records fetched from a recordset?
A
Use a For Loop with Next, without MoveNext, while checking for EOF

B
Use a Do..Loop with MoveNext, while checking for EOF

C
Use a While Loop with Wend, while not checking for EOF

Note: not sure
1. Report
Question: Which condition should be satisfied to help create a one-to-one relationship between tables?
A
The Primary key and the Foreign key fields must have a unique index

B
The Indexed property for the Primary key and the Foreign key fields should be set to 'Yes'

C
The common fields must have a unique index

D
All of these above

Note: not sure
1. Report
Question: How a form can be made Read-only?
A
In the form properties window, set the form's Read only property to Yes

B
In the form properties window, set the AllowEdits property to No, set the AllowAdditions to No and set the AllowDeletions property to No

C
In the form properties window set the form's Data entry property to No

Note: not sure
1. Report
Question: What will be the result of the following: SELECT InStr(1, "John", "o");
A
1

B
2

C
True

D
False

Note: not sure
1. Report

First Prev 80 81 82 83 84 Next Last

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?

Question: Using ADO or DAO, how are the records fetched from a recordset?

Question: Which condition should be satisfied to help create a one-to-one relationship between tables?

Question: How a form can be made Read-only?

Question: What will be the result of the following: SELECT InStr(1, "John", "o");