7 Steps to Your Access Database

Graphic showing seven steps to build a Microsoft Access Database

My process is different because I focus on designing your MS Access Database around your unique business workflow so it fits your business like a glove. I learn how you operate and build a database that works like you do. Start by getting a free consultation and quote.

Number one

Starting With a Free Consultation & Quote

Man holding up a card that says free consultation

During your free consultation we will review the samples you have provided, your unique needs and your ideas.  Then, after our call, I will prepare an itemized fixed rate price quote of what we have discussed. Once you are happy with your quote then we will schedule your project.

Number 2

Mapping Your Workflow

Man drawing workflow diagram on clear glass wall

To start your project, we will first map out your workflow together.  We will identify exactly what roles the database should play in your business. It's essential that we build your database around your business workflow so that your existing business rules and procedures are supported and fulfilled.

Number 3

Using a Prototype to Design Your Database

Screenshot of a Microsoft Access database form from a database prototype

Next, I create a prototype based on your workflow.  The prototype is actually an Access database except without any data or code; just mock-ups of screens and reports.  I will place screenshots of the prototype on an online "design board" where you can see what your database will look like.  You will use the design board to give me feedback so we can refine the design until you are completely happy with all you see.  

Number 4

Building & Coding Your Database

An access database form in design view with fields, tabs and buttons

Next, I will use the design prototype as a guide as I build and code your Access database. When finished your database will look nearly identical to your design prototype with all the fields, tables and code in place and fully functional.

Number 5

Installing Your Database

Street sign that says easy install

I can install your database for you by online screen share so I can see your screen and set up everything properly. Some of my clients choose to install themselves since it's so simple but in most cases I do it for you while you watch.

Number 6

Training You How To Use Your Database

Three happy employees looking at a laptop as they receive online training

Once installed I will train you how to use your database by web meeting.  Most of my Access Databases are designed to be so simple that it takes less than half an hour to go though everything with you.  I will thoroughly train you how to use your database.

Number 7

Making Corrections to Your Database

Badge that says 100% customer satisfaction guarantee around edges with risk free in center

If you find anything in your Access Database that is not working as it was designed in your prototype, then I will make the need corrections at no charge to you for as long as you own your database. Some issues appear early and others show up sometimes years later.  I guarantee it will work as designed.