 |
 |
This week's quiz will test your MS-Access skills.
1. Custom controls are added to Access via which menu?
A. File B. Tools C. Controls D. Help
2. Which of the following properties specifies that a control should appear as a dotted line?
A. BorderColor B. BorderStyle C. BorderWidth D. Class
3. Which of the following statements create a new object variable for an Excel application? Choose all that apply.
A. Set appExcel =
CreateObject("Excel")
B. Set appExcel = CreateObject(Excel.Application)
C. Set appExcel = CreateObject("Excel.Application")
D. Set appExcel =
GetObject("","Excel.Application")
4. What is the shortcut key to display the Object Browser?
A. Shift+F2 B. F2 C. Shift+F5 D. F5
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
B. Error 429 will occur
C. A syntax error will occur
D. A new instance of Excel will be started and a new workbook
will be added.
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?
A. The Open method B. The OpenDatabase method C. The GetObject 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?
A. From code in referencing library
B. From a macro on another form
C. From procedures on Customers
D. From any module in the database
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 >
B. In the report's underlying query, set the column's Format
property to >
C. In the table underlying the report's underlying query, set the
field's Format property to >
D. On the report, set the control's FontStyle property to CAPS
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
B. Me!Control!CustomerState.SetFocus
C. Me!SetFocus
D. 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
B. Screen.ActiveForm.ActiveControl = 1
C. Me.cboProduct = 1
D. Me!cboProduct = 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?
A. Dynaset-type Recordset
B. Forward-only scrolling snapshot-type Recordset
C. Forward-only scrolling table-type Recordset
D. 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?
A. Optimistic locking is in effect.
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 B. X = Y+Z C. "This is a comment" D. MsgBox "This is a message"
14. Which symbol can be used to separate multiple lines of code in the Debug window?
A. : B. ; C. , D. /
15. Which of the following lines, when typed in the Debug window, displays the value of X?
A. Print X B. ShowValue X C. ?X D. X
16. What precaution should a programmer take before issuing a call to a Windows DLL procedure that returns a Null-terminated string?
A. Make sure the string is initialized as empty
B. Make sure the string does not already contain the Null
character
C. Make sure the string is declared as a fixed-length string
D. Make sure the string length is 255
17. Which of the following statements is not true?
A. Permission information about objects, such as
tables and forms, is stored in the user database.
B. Information about passwords is stored in the workgroup
database
C. Permission is allowed or rejected based on a user's PID
D. When new users are added through the Tools menu, they are
automatically added to the Users group.
18. Which of the following tasks is possible in Access?
A. Deleting the Admin user
B. Synchronizing an encrypted database
C. Deleting the Admins group
D. Deleting a group with users assigned to it
19. What is the default recordset for SQL pass-through query?
A. Snapshot-type B. Dynaset-type C. Table-type D. There is no default
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?
A. The properties of the Err object in Visual
Basic for Applications
B. The Errors collection
C. The Err statement and Event variable
D. The ODBCAPI.text type file
