Access Q. Why is VBA different to VB? A. VBA is a macro-language verion of VB, VB is used to program applications and VBA is used in applications for automation. Q. What does CurrentDb command do in Access VBA? A. Returns and object that represents current database. Q. What does DoCmd allow you to do in Access? A. Run MS Access actions in VBA modules. eg open forms, open reports etc Q. What command/action would you use in a Macro to execute SQL select statment? A. RunSQL action. Q. Its not possible to use API in VBA, true or false? A. False, you can. Q. In relation to access what do MDW file do? A. Workgroup Database - Access Workgroup Information Database, access system database that stores workgroup/user information and permisions. Q. Why would you use Workgroup Administrator in Access? A. To connect to a different System Database. Q. Why would you convert a database to a MDE format? A. To protect database source code. Excel Q. In Excel what would be an easy way of creating a report on data that is store in an Access Database and what would it be its advatage? A. Easiest - Create a PivotTable on that Access Database. Moderate - Import External Data into a sheet. Easiest - You only need to refresh the PivotTable to update data from Database, Moderate - you need to refresh the Imported Data on a sheet and then the PivotTable Q. What does Vlookup function do? A. Vlookup looksup up a value in a table or array. Q. What does Indirect function do? A. Returns cell value specified by a text string, eg in a cell =Indirect("A1") returns contents of A1 on current sheet. I would recomend not to ask to many tricky questions on function names etc as they are very easy to pick up, what you generaly looking in the applicant is the comprehension that Access and Excel are very flexible and your immagination is the only limit. Let me know how u go. Regards you play with the best... you learn like the rest...

Q. What does VBA stand for? A. Visual Basic for Applications. available in MS Office Q. What is API? A. Aplication Program Interface, provides access to lower level functions of an operating system. Q. What does "OO" stand for in reference to style of programming technique? A. Object Oriented Programming, refers to utilising classes in you applications Q. What does COM stand for? A. Component Object Model. refers to building your applications out of reusable objects such as DLL's, services etc. Q. What is MTS? A. MS Transaction Server. pre COM/COM+ management service for DLL's and services for NT4 and below, allow object pooling and management Q. What do you use to visualy manage COM+ under Windows XP? A. Component Services. DLL and service hosting service, new MTS Q. What is SMTP? A. Simple Mail Transfer Protocol. used to send email on port 25, can be used directly to send mail. Q. What is CDONTS used for? (CDO for NTS - Colloboration Data Object for Win NT Server) A. CDONTS is used to send SMPT primarily on NT 4. Q. What does SDLC stand for? A. Software Development Life Cycle. describes a development project structure Q. What does SQL stand for? A. Structured Query Language. Q. What does DTS stand for? A. SQL Server Data Transformation Service. you create process flow for data manipulation in MSSQL. Q. How do you return last idenity value of a record after an insert query? A. select @@identity or scope_identity(), bonus points for scope_identity() is only avail on SQL2000+. Q. What is VMWare? A. Virtualisation software, software that allows hosting of virtual operating systems, eg development enviroments or production testing envirments. Q. What is DHTML? A. Dynamic HTML. combination of client side java script and html. If you can give a list of technologies you use will be easier to give you some questions. Also what level do you want? Intermediate or Advanced? you play with the best... you learn like the rest...