Answers to "ACCESS" quiz

1. Custom controls are added to Access via which menu?

B. Tools

2. Which of the following properties specifies that a control should appear as a dotted line?

B. BorderStyle

3. Which of the following statements create a new object variable for an Excel application? Choose all that apply.

C. Set appExcel = CreateObject("Excel.Application")
D. Set appExcel = GetObject("","Excel.Application")

4. What is the shortcut key to display the Object Browser?

B. F2

5. Microsoft Excel is currently running. The following code executes from Microsoft Access:

Dim appXL As Object
Set appXL = GetObject(,"Excel.Application")
appXL.Visible = True
appXL.Workbooks.Add

What will happen when this code executes?

A. A new workbook will be added in the current instance of Microsoft Excel

6. Microsoft Word is using Access as an OLE server to print a report. An object reference was created for the Access application. What method must be applied before using the DoCmd.OpenReport method?

D. The OpenCurrentDatabase method

7. The following code is behind a form named Customers:

Private Sub HaltUpdateMsg()
Msgbox "Update has been halted"
End Sub

From where can you call this procedure?

C. From procedures on Customers

8. A control on a report is bound to a field with no format. What should you do to make that control display in all capital letters?

A. On the report, set the control's Format property to >

9. You want to move the cursor to a specified control Customer-State on the active form. What line of code should you use?

A. Me!CustomerState.SetFocus

10.Which statement changes the value of the active combo box, (cboProduct) - on a form that is currently active - to the number 1?

A. Screen.ActiveControl = 1

11. You need to search through data on a local table to return the total number of customers who live in a certain state. Which type of Recordset would yield the fastest possible results?

B. Forward-only scrolling snapshot-type Recordset

12. A Recordset with the LockEdits property set to True is about to be updated. Which of the following statements are true?

B. Executing the Update method will release the record lock
C. Executing the Close method will release the record lock
D. Executing the Seek method will release the record lock

13. Which of the following lines cannot have breakpoints on them? Choose all that apply.

A. Dim X as Integer
C. "This is a comment"

14. Which symbol can be used to separate multiple lines of code in the Debug window?

A. :

15. Which of the following lines, when typed in the Debug window, displays the value of X?

A. Print X
C. ?X

16. What precaution should a programmer take before issuing a call to a Windows DLL procedure that returns a Null-terminated string?

C. Make sure the string is declared as a fixed-length string

17. Which of the following statements is not true?

C. Permission is allowed or rejected based on a user's PID

18. Which of the following tasks is possible in Access?

D. Deleting a group with users assigned to it

19. What is the default recordset for SQL pass-through query?

A. Snapshot-type

20. Your code links to a table to your database by using ODBC at runtime. If this fails, you want to retrieve error messages from the ODBC driver. Where can you retrieve the error information from?

B. The Errors collection

Visit my quiz archive
Return to my homepage

My site is in Geocities.