Job Summary:
We are seeking an experienced MS Access Developer with strong expertise in building and maintaining Access forms, VBA scripting, and database development. The ideal candidate should be proficient in SQL and SSRS for report development and have a solid understanding of data flow and integration across systems.
Key Responsibilities:
- Design, develop, and maintain MS Access databases, including complex forms, queries, and reports.
- Utilize VBA (Visual Basic for Applications) to automate tasks and enhance user interaction.
- Create and manage relational database structures within Access or linked to SQL Server.
- Develop custom solutions based on business requirements and ensure efficient data handling.
- Design and implement SSRS reports, pulling data from MS Access or SQL Server databases.
- Troubleshoot and resolve issues related to Access applications and database performance.
- Collaborate with stakeholders and cross-functional teams to gather requirements and deliver user-friendly solutions.
- Ensure documentation and version control of all database and code changes.
Required Skills:
- Strong hands-on experience with MS Access, including form and report development
- Proficient in VBA (Visual Basic for Applications) for scripting and automation
- Expertise in SQL, including complex queries and database management
- Experience with SSRS (SQL Server Reporting Services) report design and deployment
- Good understanding of database normalization and relational database principles
- Excellent problem-solving and communication skills
Preferred Skills (Nice to Have):
- Experience with MS Excel integration and macros
- Exposure to other reporting tools or BI platforms
- Basic knowledge of Access-to-SQL Server migration strategies
Education:
- Bachelor’s degree in computer science, Information Technology, or a related field (preferred)