1. What properties need to be set to bind a text box control to an ADO data
control?
a. DataSource and DataField
b. DataSource, DataField and DataMember
c. DataSource, RecordSource and DataField
d. DataSource, Connection and DataField
2. When using a data environment in a project what are the DataSource and
DataMember properties set to?
a. The DataEnvironment and Connection
b. The Connection and Command
c. The Connection and Database Name
d. The DataEnvironment and Command
3. How do you open a recordset using the execute method with an existing
connection object?
a. Set rsName = cnName.Execute("SELECT FName FROM Students")
b. rsName = cnName.Execute "SELECT FName FROM Students"
c. Set rsName = cnName.Execute "SELECT FName FROM Students"
d. rsName = cnName.Execute("SELECT FName FROM Students")
4. How do you open a recordset using the open mehtod with an existing
connection object? Users need to detect changes, additions and deletions of
records that other users have made in a multi-user environment.
a. rsName.Open "SELECT * FROM Publishers", cnName, adOpenKeyset
b. rsName.Open "SELECT * FROM Publishers", cnName, adOpenDynamic
c. rsName.Open "SELECT * FROM Publishers", adOpenDynamic, cnName
d. rsName.Open rsName.Open "SELECT * FROM Publishers", adOpenKeyset, cnName
