First, a recruiter contacted me. He set up an interview with a department manager.

I passed the first interview (phone screening). They asked me about my previous experience using Access, VBA, and Excel. The interview went really well.

Next, they gave me an assignment: build a prototype database with forms, reports, and many other functionalities, and walk them through the VBA code. I had more than one week to do it. It was great; I did more than they expected.

I got the job. They pressured me to accept the offer because they wanted me on the team. I accepted the offer and canceled other interviews.

Two days later, they told me there would be some changes in the department and the position, and they canceled the offer.

Be careful; some managers are not serious. I lost a couple of interviews because of them.

Build an access database prototype, and explain where I used VBA code.