Home   Register   Sign In
 
Company Info

Modis


United States

Phone:
Web Site: www.modis.com

Company Profile


Systems Analyst


col-narrow-left   

Job ID:

1405

Location:

West Des Moines, IA, United States 

Category:

Information-Technology, Other
col-narrow-right   

Job Views:

320

Employment Type:

Full time, Part time, Contract to Hire - W2, Contract - W2

Posted:

06.27.2014
col-wide   

Job Description:

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. 


© 2017 Powered by Rootjobs     About Us   Sitemap   Terms and Conditions   Privacy Policy   Mobile Version     Twitter RSS LinkedIn Facebook