THE CANDIDATES PRIMARY RESPONSIBILITIES: would be to document and troubleshoot Access databases (MS Access 2007). The databases are a means to automate tasks to enhance data or provide reports with multiple external inputs and Excel spreadsheet output. The candidate will be supporting a team of accountants in the Finance division. A business degree or accounting/finance background would be helpful (not required), but the main focus in skills would be proficiency using advanced features of Access, Excel, and Visual Basic for Applications (VBA).
INTERVIEW QUESTIONS: What are a few of the main groups of objects in Access? Tables, Queries, Forms, Reports, and Macros What are the six types of queries in Access? Append, Crosstab, Delete, Make Table, Select, and Update What is the difference between a VBA procedure and a function? Functions are procedures that can be called by another procedure to perform some task and can return a value to the procedure that called it.
Being able to answer the above questions is not required, but a strong candidate could. A strong candidate would also understand table joins, be comfortable with IF statements, and be able to think through a process to understand how changing one aspect effects the interrelated objects.
Regarding spreadsheets, a strong candidate would be proficient at Pivot tables, defined names, and a variety of Excel functions such as Count, CountIf, Date, Hyperlink, IfError, Index, Indirect, Match, Fixed, Round, SumProduct, and Vlookup.