Access VBA Programming
Interview Questions
You'll Most Likely Be Asked
Job Interview Questions Series
*****
Access VBA Programming Interview Questions You'll Most Likely Be Asked
Published by Vibrant Publishers at Smashwords
Copyright 2012 Vibrant Publishers, USA.
Smashwords Edition, License Notes
This ebook is licensed for your personal use only. This ebook may not be re-sold or given away to other people. If you would like to share this book with another person, please purchase an additional copy for each recipient. If you’re reading this book and did not purchase it, or it was not purchased for your use only, then please return to Smashwords.com and purchase your own copy. Thank you for respecting the hard work of this author.
This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. The author has made every effort in the preparation of this book to ensure the accuracy of the information. However, information in this book is sold without warranty either expressed or implied. The Author or the Publisher will not be liable for any damages caused or alleged to be caused either directly or indirectly by this book.
Vibrant Publishers books are available at special quantity discount for sales promotions, or for use in corporate training programs. For more information please write to bulkorders@vibrantpublishers.com
Please email feedback / corrections (technical, grammatical or spelling) to spellerrors@vibrantpublishers.com
To access the complete catalogue of Vibrant Publishers, visit www.vibrantpublishers.com
*****
1. VBA Programming Fundamentals
11. Collections And Class Modules
12. APIs –Application Programming Interfaces
*****
Access VBA Programming Interview Questions
Review these typical interview questions and think about how you would answer them. Read the answers listed; you will find best possible answers along with strategies and suggestions.
*****
1: What does the acronym VBA stand for?
Answer:
It is short for Visual Basic for Applications and it is the programming language built into Access and all the other Microsoft applications.
2: What is a procedure in VBA?
Answer:
It is a grouped collection of statements that perform a certain task. There are two types of procedures: subroutines and functions. They essentially perform the same tasks, but functions return a value, whereas subroutines do not.
3: What is a module in VBA?
Answer:
A module is a grouping of number of procedures and other elements (such as variable declarations or database connection strings) into a single entity.
4: What is a variable in VBA?
Answer:
A variable is a name applied to a value from the database.For example:
Dim a As String
a = ObjectFromDatabase.Value
5: Name some advantages of using macros.
Answer:
Macros have the advantage that you can build applications faster, you do not have to remember complex syntax and some actions are easier to do with a macro, such as opening or closing forms or reports.
6: What would be some advantages of using VBA code?
Answer:
With VBA you can create custom functions, you can handle errors better, you can use Automation to communicate to other applications, you can use the Windows API, you can loop through records, the application is easier to maintain, you can create your own objects and work with them directly in the code.
7: What is an embedded macro?
Answer:
Normal macros are separate objects in the database, but embedded macros are attached to the forms, reports or controls on which they operate, and travel with the objects if they are copied to another object.
8: How do you automatically convert a macro to VBA code?
Answer:
In the Save As dialog box, you select Save As module and then you click Convert. You can also choose to add handling options and include comments by checking the appropriate check boxes in the Save As module.
9: What is a continuation character?
Answer:
It is an underscore character that is put on the end of a line to instruct the engine to include the next line as part of the same statement.
10: What is the difference between standard modules and form and report modules?
Answer:
Standard modules, also known as global or public modules, are accessible to all elements in an application and are stand-alone objects (they are not related to other objects in the database). Form and report modules are integrated into forms and reports and support events (the code they contain can trigger automatically in response to an action).
11: When is a form or report not allowed to have VBA code module integrated into it?
Answer:
When the Has Module property is set to No