Go to Top

10 Questions you Should Ask your Access Developer

Companies are constantly looking for quality Microsoft Access developers, here are some questions to help you evaluate one:

MS Access Consulting

1. Do you provide quotes or estimates?

If the MS Access consultant does not provide estimates, it’s a major red flag. Quotes and proposals are a great way to get on the same page as your developer, otherwise you may be asking for trouble. Shy away from people that only offer a handshake to do your work.

2. What kind of certifications do you have?

This is a trick question since there are no Access Developer certifications in existence. If a developer has a related certification, as in .Net or MCP, ask them whether the skills gained from the certification are useful with Access. If they quote an Access developer certification, you have to wonder what else they will fib about.

UPDATE: As several readers have pointed out, there were certifications in the past provided by Microsoft and third parties, such as Brainbench, but they are no longer offered. 

3. What is your backup strategy during development? What is your backup strategy when the app is installed at my company?

If you get blank stares from this question, you need to head towards the bright, green exit lights. Backup strategies are a must during development and deployment. An Access developer worth his/her salt will be glad that you asked this question and will discuss and develop strategies with you.

4. Do you consider yourself a macro developer or VBA developer?

There is nothing wrong just using macros in Access, but I don’t believe a macro-only developer can deliver as great of a solution as VS a VBA developer. Hands down the VBA guy will do a better job every time.

5. What version of Access do you love using?

If someone says they love Access ’97 or 2000 and you have 2007 or even 2010, you should consider going with someone who uses a more recent version. Why? The newer versions use tab view and can create PDFs directly from the application. Someone stuck in the past may not know or be willing to use these features.

6. Do you have a website? Do you have a calling card?

In this day and age of getting a website for $300, no self-respecting professional should go without one. Yes, there are great developers with no website, but do you want your business to trust someone who will not bother to have a professional calling card?

7. Do you have references?

It’s important you talk with other businesses that have worked with the consultant before, even if they have glowing reviews. (They all should be, otherwise they should not be a reference). Ask them how responsive your consultant was, whether they accommodated to emergency requests or whether they disappeared for weeks on end.

8. What has been your most challenging Access problem, and how did you solve it?

Granted you may not understand all of the techno babble, but what you are looking for is to gain insight on how the developer handles problems and whether he/she tends to formulate a plan of attack.

9. What has been your greatest work?

With this response, you want to listen in on the features and accomplishments that make your consultant proud. Do the features sound useful from a business perspective? Does the quoted work sound like a great solution? I use this question to highlight wonderful solutions I’ve built for companies in the past.

10. Are you going to charge me for bug fixing?

This is a great way to clear up the atmosphere before work gets started. The answer to this question will let you know the frame of mind a consultant has in regard to the project and your business.

I hope this helps you evaluate your MS Access consultant, and I look forward to new clients asking me these questions going forward. As you can imagine, I have some great responses lined up!

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

5 Responses to "10 Questions you Should Ask your Access Developer"

  • Kairi Gainsborough
    November 18, 2017 - 3:23 am Reply

    These are really smart questions to help a company select the most qualified and up-to-date candidate for the job. I think asking about their VBA skills is a good suggestion, but I wouldn’t rule out those who use macros. If they can use VBA to make custom macros, the chances are that they will be more efficient at their job. Of course, like you said, if they are a macro-only user, they probably aren’t as good. That’s why I agree it is a good thing to ask about. http://www.rptsoftware.com/products/

  • QuestionBoy
    March 7, 2013 - 8:37 am Reply

    Item 4 is wrong especially considering Web App do not allow VBA so it becomes crucial to find an extremely competent Macro developer!

    Item 6 is wrong, once again looks ahead of actual competence. I would much prefer seeing demo of past work that checking out a website that he paid to have someone put together. Also, there are numerous top notch professional developers without websites… even MVPs!

    Items 7,9 & 10 are the key points!

  • Ryder Daniels
    January 23, 2013 - 3:35 pm Reply

    this ten question is always comes in mind that but every time Business developer is solved my problem.

  • Graham R Seach
    January 18, 2013 - 1:31 pm Reply

    Juan, you said “If they quote an Access developer certification you gotta wonder what else they will fib about.”. Unfortunately you’re wrong. There were two Access certifications from Microsoft (one MCP for A97 and a beta MCP for A2000) and a few others from BrainBench. I have all three. Arvin Meyer has the A97 MCP too. Does that mean we’re fibbing?

    Graham R Seach (former Access MVP)

    • Juan Soto
      January 23, 2013 - 10:40 pm Reply

      No, I will update the post accordingly.

Leave a Reply

Your email address will not be published. Required fields are marked *


Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.