MS Access 2003, Databases

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
Question: Which of the given text field properties you should set in order to force a user to enter a date value specifically in MM-DD-YYYY format?
A
Indexed

B
Limit to List

C
Input Mask

D
Allow Value List Edits

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
char

B
varchar

C
hyperlink datatype

D
nchar

E
nvarchar

Note: not sure
1. Report
Question: Password protected databases offer:
A
Only one password with full rights

B
Different user rights for different logins/passwords

C
Options for data editing rights versus the right to change designs

D
Integrated security with Active Directory

Note: not sure
1. Report
Question: An .mde file is a special version of an Access .mdb file and contains information related to a database. Which of the following is true about an .mde file?
A
It contains compiled VBA code to prevent users from viewing code.

B
It allows users to view, but not modify VBA code

C
It can be saved as an .mdb file in order to make design changes.

D
It allows users to import forms and reports from other databases

Note: not sure
1. Report
Question: Which of the following statements about Report Snapshots is untrue?
A
The Snapshot Viewer allows you to share Access reports with people who do not have Access installed.

B
Report Snapshots can only be viewed from within Access or the Access Runtime.

C
A Report Snapshot preserves the two-dimensional layout, graphics, and other embedded objects of the report.

D
Report Snapshots allow you to share reports electronically.

Note: not sure
1. Report
Question: How do you import a portion of an Excel spreadsheet into Access?
A
TransformXML Method

B
ImportXML Method

C
TransferSpreadsheet Method

Note: not sure
1. Report

First Prev 2 3 4 5 6 Next Last

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");

Question: Which of the given text field properties you should set in order to force a user to enter a date value specifically in MM-DD-YYYY format?

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

Question: Password protected databases offer:

Question: An .mde file is a special version of an Access .mdb file and contains information related to a database. Which of the following is true about an .mde file?

Question: Which of the following statements about Report Snapshots is untrue?

Question: How do you import a portion of an Excel spreadsheet into Access?