Furman



Exploring Getting Started VBA for Microsoft Office 2010, Chapter 3 TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 1) Visual Basic for Applications (VBA) is a scripting language that can be used to customize Office applications to enhance their functionality. 1) _______ Answer: True False Diff: 1 Objective: App Chap: VBA 3 Ref: Introduction to VBA and Access 2) When creating code in Access, you can use one of three modules: standard, Access object, and class module. 2) _______ Answer: True False Diff: 2 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 3) You can create a module by inserting a procedure, then creating the VBA code. 3) _______ Answer: True False Diff: 2 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 4) When the VB Editor opens, if no procedures have been created, no code will show. 4) _______ Answer: True False Diff: 2 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 5) When creating VB code for a form or a report, the form or report should be open in Design view. 5) _______ Answer: True False Diff: 1 Objective: Write code for forms and reports App Chap: VBA 3 Ref: Introduction to VBA and Access 6) VBA works with the objects in various option libraries that are available in the applications that support VBA programming. 6) _______ Answer: True False Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 7) An object is a physical attribute of a property. 7) _______ Answer: True False Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 8) Among the actions a user can take when working with a form are changing a record, opening and/or closing a form, and filtering the records in the form. 8) _______ Answer: True False Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 9) Once a module has been created, a custom function cannot be inserted in the code window. 9) _______ Answer: True False Diff: 2 Objective: Create functions App Chap: VBA 3 Ref: Introduction to VBA and Access 10) A recordset uses the same data source as a table or a query. 10) ______ Answer: True False Diff: 2 Objective: App Chap: VBA 3 Ref: Working with Recordsets 11) The DAO (Data Access Objects) library was first released in 1997 and is not the object library of choice for many Access developers. 11) ______ Answer: True False Diff: 1 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 12) The Do Loop clause is used to end the loop when the End of File is reached. 12) ______ Answer: True False Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 13) Memory resources can be tied up with too many large recordsets are open. 13) ______ Answer: True False Diff: 3 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 14) Backing up your database is not necessary when updating using a recordset. 14) ______ Answer: True False Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 15) ADO (ActiveX Data Objects) was designed to connect to external data sources. 15) ______ Answer: True False Diff: 2 Objective: Use ADO to access data App Chap: VBA 3 Ref: Working with Recordsets 16) A link to a library must be created before you can use the ADO object library. 16) ______ Answer: True False Diff: 2 Objective: Use ADO to access data App Chap: VBA 3 Ref: Working with Recordsets 17) One of the most common features of VBA in Access is to enhance the functionality of forms and reports. 17) ______ Answer: True False Diff: 1 Objective: App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 18) Nearly all of VBA code that is added to a form is triggered by an event. 18) ______ Answer: True False Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 19) Each object on a form has its own set of events, and the form also has another set of events. 19) ______ Answer: True False Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 20) While editing a record on a form, the arrow appears in the record selector on the right. 20) ______ Answer: True False Diff: 3 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 21) The Before Update feature notifies the user that fields are blank or that data is outside the normal boundaries. 21) ______ Answer: True False Diff: 3 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 22) VBA code can be created to hide sections of a report that are not needed before the report prints. 22) ______ Answer: True False Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 23) When you run a report, the On Open, On Load, and On Activate events do not have to fire in the same order every time. 23) ______ Answer: True False Diff: 3 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 24) Letting the user set one or more parameters before opening a report makes the report less versatile. 24) ______ Answer: True False Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 25) There are two types of errors in VBA: handled and unhandled. 25) ______ Answer: True False Diff: 1 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 26) ________ is a statement used to declare that string comparisons are not case sensitive when the data is compared. 26) _____________ Answer: Option Compare Database Diff: 3 Objective: Write code for forms and reports App Chap: VBA 3 Ref: Introduction to VBA and Access 27) ________ is a statement used to require that all variables are declared before they are used. 27) _____________ Answer: Option Explicit Diff: 3 Objective: Write code for forms and reports App Chap: VBA 3 Ref: Introduction to VBA and Access 28) ________ contain the objects available in applications that support VBA. 28) _____________ Answer: Object libraries Diff: 1 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 29) A(n) ________ is a physical attribute of an object. 29) _____________ Answer: property Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 30) A(n) ________ is what happens when a user takes an action. 30) _____________ Answer: event Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 31) A(n) ________ is a procedure that performs an action and returns a value. 31) _____________ Answer: function Diff: 2 Objective: Create functions App Chap: VBA 3 Ref: Introduction to VBA and Access 32) A(n) ________ is a set of records in memory that are selected from a table or query. 32) _____________ Answer: recordset Diff: 2 Objective: App Chap: VBA 3 Ref: Working with Recordsets 33) ________ refers to an object library that has been specifically created to work with Access databases. 33) _____________ Answer: DAO (Data Access Objects) Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 34) The ________ method is used to advance through the records of a recordset. 34) _____________ Answer: MoveNext Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 35) The two methods used to edit recordsets are ________ and ________. 35) _____________ Answer: edit; update Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 36) ________ was designed to connect a wide range of external data sources with Access. 36) _____________ Answer: ADO (ActiveX Data Objects) Diff: 2 Objective: Use ADO to access data App Chap: VBA 3 Ref: Working with Recordsets 37) ________ is the process of intercepting and handling errors at run time. 37) _____________ Answer: Error trapping Diff: 3 Objective: App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 38) ________ is an event that is triggered by a record being loaded into a form. 38) _____________ Answer: On Current Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 39) ________ is triggered when a record is being edited. 39) _____________ Answer: On Dirty Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 40) ________ is triggered before a record is saved. 40) _____________ Answer: Before Update Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 41) When you run a report in Access which events fire in succession? 41) _____________ Answer: On Open, On Load, and On Activate Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 42) ________ event occurs when the report is open and its records are displayed. 42) _____________ Answer: On Load Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 43) Two types of errors exist in VBA. They are ________ and ________. 43) _____________ Answer: handled; unhandled Diff: 2 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 44) The ________ statement directs the code to skip to a particular line in the procedure. 44) _____________ Answer: On Error Diff: 3 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 45) Error numbers range from ________ to ________ with gaps between some numbers. Errors can also fall between 31001 and 31037. 45) _____________ Answer: 3; 746 Diff: 3 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 46) The ________ statement directs the code to jump to the exit routine. 46) _____________ Answer: Resume Exit_Routine Diff: 3 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 47) The ________ enables the programmer to temporarily stop the execution of code. 47) _____________ Answer: VBA debugger Diff: 2 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 48) To use the debugger, set a(n) ________ by clicking in the left margin next to any line of executable code. 48) _____________ Answer: breakpoint Diff: 2 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 49) To stop the debugger, click _________ on the Debug toolbar. 49) _____________ Answer: Reset Diff: 2 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 50) One way to watch the procedure one line at a time is to press the ________ key. 50) _____________ Answer: F8 Diff: 3 Objective: Handle errors in VBA App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 51) Match the following terms with their definitions:I. Stores procedures that are available to any event in the applicationII. Stores procedures that are available to a specific form or reportIII. Advanced programs that are used to create custom objectsIV. A special type of procedure that performs an action and returns a value from within a moduleV. A separate program from AccessA. VB EditorB. Class moduleC. FunctionD. Standard moduleE. Access object module 51) _____________ Answer: D, E, B, C, A Diff: 3 Objective: App Chap: VBA 3 Ref: Introduction to VBA and Access 52) Match the following terms with their definitions:I. A statement that is used in a module to declare the default comparison method to use when string data is comparedII. A statement that is used in a module to require that all variables be declared before they are usedIII. Contains the objects that are available in the applications that support VBAIV. A physical attribute of an objectV. An action that is performed by an objectA. Object librariesB. Option ExplicitC. PropertyD. MethodE. Option Compare Database 52) _____________ Answer: E, B, A, C, D Diff: 3 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 53) Match the following User Action with the Event Triggered:I. Change and save a record in a formII. Find records in a form with certain criteriaIII. Click a button to open a formIV. Click the Close button to close a formA. Before UpdateB. On OpenC. On CloseD. On Filter 53) _____________ Answer: A, D, B, C Diff: 3 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 54) Put the following procedures in the correct order:A. The function returns a different value to the calling procedure by assigning the result to the function name.B. The procedure calls the function and passes one or more values to it.C. The procedure runs and encounters the function.D. The function receives the values and processes them according to the function code.E. A procedure contains a function. 54) _____________ Answer: E, C, B, D, A Diff: 3 Objective: Create functions App Chap: VBA 3 Ref: Introduction to VBA and Access 55) B, Match the following methods with their procedure:I. A method used to advance through the records of a recordsetII. A method used in with Move Next to cycle through recordsIII. A clause used to end the loop when the End of File is reachedIV. A method that enables you to change the data in a recordsetV. A method that enables you to save the changes in a recordsetA. EditB. Do LoopC. UpdateD. MoveNextE. While 55) _____________ Answer: D, B, E, A, C Diff: 3 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 56) Match the following with their definitions:I. The process of intercepting and handling errors at run timeII. The event triggered by a record being loaded into a formIII. The act of placing the insertion point in a text boxIV. Triggered when a record is being editedV. Triggered after a record is savedA. On EnterB. After UpdateC. Error trappingD. On CurrentE. On Dirty 56) _____________ Answer: C, D, A, E, B Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 57) 57) Match the following with the correct procedure.I. Triggered before a record is savedII. Triggered when the report is open but before the first record is displayedIII. Occurs when the report is open and its records are displayedIV. Occurs when the window of your report becomes the active windowV. Directs the code to skip to a particular line in the procedureA. On LoadB. Before UpdateC. On Error statementD. On OpenE. On Activate 57) _____________ Answer: B, D, A, E, C Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 58) Visual Basic for Applications can be used to: 58) ______ A) customize Office applications to enhance their functionality. B) create standard forms and reports in Access. C) create a special type of program. D) run the program in a different file format. Answer: A Diff: 1 Objective: App Chap: VBA 3 Ref: Introduction to VBA and Access 59) Since the VB Editor is a separate program from Access, how does it open? 59) ______ A) In the background B) In a new window C) In the same window as Access D) As part of Run Answer: B Diff: 3 Objective: App Chap: Ref: 60) When you create VBA code in Access, you can create code in three modules. Which of the following is NOT one of the modules? 60) ______ A) Standard module B) Code module C) Class module D) Access object module Answer: B Diff: 2 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 61) To create a procedure, insert a module and then 61) ______ A) create a function using Access code. B) create the VBA code. C) add an event to the application. D) store procedures available in the program. Answer: B Diff: 2 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 62) If procedures have not been created, you can create one by: 62) ______ A) inserting a class module and creating the VBA code. B) inserting an event property in an event procedure. C) double-clicking a module in the Navigation Pane. D) typing the code between the End Sub and Sub statements. Answer: A Diff: 2 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 63) The Choose Builder dialog box has three options. Which of the following is NOT one of those options? 63) ______ A) Macro Builder B) Expression Builder C) Code Builder D) Function Builder Answer: D Diff: 1 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 64) When a new form module is created, which statements are automatically inserted into the code window by the VB Editor? 64) ______ A) Private Sub Form_Current() and End Sub B) On Got Form and End Sub C) On Click and On Load D) Option Compare Database and Option Explicit Answer: A Diff: 3 Objective: Write code in modules App Chap: VBA 3 Ref: Introduction to VBA and Access 65) Which of the following type of libraries is available in the applications that support VBA? 65) ______ A) Object B) Messenger C) Adobe D) Fax Answer: A Diff: 1 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 66) Which of the following is the VBA code to refresh a form? 66) ______ A) Refresh_Private B) MsgBox Refresh C) Refresh_Option D) Me.Refresh Answer: D Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 67) Which of the following does the Me prefix refer to? 67) ______ A) The current property you are in. B) The current instance of the object you are in. C) The current method you are in. D) The current event you are in. Answer: B Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 68) What is an event? 68) ______ A) The difference between a method and property. B) What happens when a user takes an action? C) What happens when a user uses a property incorrectly? D) What happens when a method is used improperly? Answer: B Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 69) The message "Do you want to save your changes" is an example of which type of event? 69) ______ A) On Close B) On filter C) Before Update D) On Open Answer: C Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 70) What is a function? 70) ______ A) A value that performs an action and returns a procedure B) A statement in the code C) A procedure that performs an action and returns a value D) A value assigned to a function name Answer: C Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 71) When creating a function, the VB Editor automatically adds which statement after you press Enter? 71) ______ A) End Sub B) End Name C) End Argument D) End Function Answer: D Diff: 2 Objective: Work with objects App Chap: VBA 3 Ref: Introduction to VBA and Access 72) Which of the following is a recordset similar to in Access? 72) ______ A) A table or a query B) A form or a report C) A blank database D) An SQL statement Answer: A Diff: 2 Objective: App Chap: VBA 3 Ref: Working with Recordsets 73) Which of the following describes the benefit of the recordset? 73) ______ A) The versatility of working with records and data programmatically B) You can use all records regardless of the criteria set. C) It does not require code. D) You do not have to connect to a database. Answer: A Diff: 1 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 74) What must you do to find records that meet certain criteria after creating a recordset? 74) ______ A) Identify the report or query that contains the initial recordset B) Identify the table or query that contains the initial recordset C) Identify the form or report that contains the initial recordset D) Identify the form or query that contains the initial recordset Answer: B Diff: 3 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 75) Which of the following is used to advance through the records of a recordset? 75) ______ A) MoveWhen B) MoveIf C) MoveNow D) MoveNext Answer: D Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 76) Which of the following could happen if you leave several large recordsets open when you are finished with them? 76) ______ A) Recordsets close automatically when the End of File is reached. B) Nothing C) Your computer can become sluggish because recordsets tie up memory resources. D) Other procedures and applications will close the recordsets. Answer: C Diff: 3 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 77) Which of the following must you do to update the field values in a recordset? 77) ______ A) Don't save the changes to the recordsets. B) Close the recordset to further edits. C) Open the recordset for edits. D) Delete changes to the recordset. Answer: C Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 78) Which of the following are the two methods needed to accomplish a recordset edit? 78) ______ A) Edit and update B) Update and save C) Edit and change D) Modify and close Answer: A Diff: 1 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 79) Which of the following should you do before you update to a recordset? 79) ______ A) Create a run procedure. B) Delete records meeting specified criteria. C) Back up your database. D) Run an Access update. Answer: C Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 80) Creating a procedure to remove records that meet predefined criteria is called ___________. 80) ______ A) delete method B) rename method C) recycle method D) remove method Answer: A Diff: 1 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 81) How does the Delete method delete records in a recordset? 81) ______ A) The same way as a Delete query B) Records are deleted one by one using the record selector to select the record. C) As the Do Loop cycles through the records in a table D) Using the MoveNext procedure. Answer: C Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 82) Which method provides permission for a new record to be inserted in a recordset? 82) ______ A) UpdateNew B) AddUpdate C) Update D) AddNew Answer: D Diff: 2 Objective: Use DAO to access data App Chap: VBA 3 Ref: Working with Recordsets 83) Which of the following was designed for connecting a wide range of external data sources? 83) ______ A) ISAM data sources B) Access ISAM sources C) ActiveX Data Objects (ADO) D) Data Access Objects (DAO) Answer: C Diff: 2 Objective: Use ADO to access data App Chap: VBA 3 Ref: Working with Recordsets 84) Which of the following must be done before using the ADO object library? 84) ______ A) ActiveX Objects are ready to use; nothing needs to be done. B) References will need to be downloaded. C) Create a link to the library by selecting the Reference in the objects library. D) Code must be created first to use ActiveX Data Objects. Answer: C Diff: 2 Objective: Use ADO to access data App Chap: VBA 3 Ref: Working with Recordsets 85) Which of the following should be done before changing the references in a database? 85) ______ A) Nothing needs to be done. B) Make a copy of the table you will be working with. C) Create a code reference for your database. D) Make a copy of your database. Answer: D Diff: 2 Objective: Use ADO to access data App Chap: VBA 3 Ref: Working with Recordsets 86) Error trapping is __________________. 86) ______ A) finding solutions to errors before they happen B) counting the errors as they are found C) testing and correcting errors before running the procedure D) the process of intercepting and handling errors at run time Answer: D Diff: 1 Objective: App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 87) Nearly all of the VBA code added to a form is triggered by which of the following? 87) ______ A) A format B) A filter C) An event D) A procedure Answer: C Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 88) How is the On Current event triggered? 88) ______ A) By a record being loaded into a form B) Text boxes overlap with the form On Current object C) By a text box object D) A text box can trigger the On Current event. Answer: A Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 89) The act of placing the insertion point in a text box is which of the following? 89) ______ A) On Load B) On Enter C) On Current D) After Update Answer: B Diff: 1 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 90) Which of the following is triggered when a record is being edited? 90) ______ A) On Dirty B) On Current C) After Update D) On Enter Answer: A Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 91) Which of the following is triggered after a record is saved? 91) ______ A) On Enter B) On Current C) On Dirty D) After Update Answer: D Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 92) Which event is used to intercept the saving of a record if any key fields are blank or if any fields contain data outside the acceptable boundaries? 92) ______ A) Before Update B) On Current C) On Enter D) On Load Answer: A Diff: 2 Objective: Add VBA to forms App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 93) Which events fire in succession when you run a report? 93) ______ A) On Load, On Click, and On Duty B) On Open, On Load, and On Activate C) On Resize, On Open, and On Load D) On Current, On Open, and On Load Answer: B Diff: 3 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 94) Reports events are similar to form events except: 94) ______ A) once the report runs, the user can specify to hide unnecessary information. B) once the report runs, the On Activate procedure can be used. C) once a report runs, the events can happen in the order specified by the user. D) once a report runs, most of the events happen in succession with very little intervention by the user. Answer: D Diff: 3 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 95) Which event is triggered when the report is open but before the first record is displayed? 95) ______ A) On Load B) On Open C) On Click D) On Activate Answer: B Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 96) Which event occurs when the report is open and its records are displayed? 96) ______ A) On Open B) On Load C) On Activate D) On Click Answer: B Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 97) Which of the following occurs when the window of a report becomes the active window? 97) ______ A) On Activate B) On Open C) On Load D) On Click Answer: A Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 98) How can you set parameters? 98) ______ A) Using a blank report that contains no data B) Using a blank form that contains no record source C) Using an existing form D) Using an existing report Answer: B Diff: 1 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 99) Which of the following are the two types of errors in VBA? 99) ______ A) fixed and removed B) handled and unhandled C) selected and deleted D) used and unused Answer: B Diff: 1 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA 100) Which statement directs the code to skip to a particular line in the procedure? 100) _____ A) On Load B) On Click C) On Close D) On Error Answer: D Diff: 2 Objective: Add VBA to reports App Chap: VBA 3 Ref: Forms, Reports, and Errors in VBA ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download