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 all of your needs and ideas and discuss the options. Then I will prepare an itemized fixed rate price quote of what we have discussed. Once you are happy with your quote then we will get started on 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 without any data or code - just mockups of screens and reports so you can "see" what your database will look like.  I will send it to you many times for you to review and give me feedback.  Each time I will revise it and send it to you again 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 prototype as a guide as I build and code your Access database. When finished your database will look almost exactly like your prototype but this time 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 don't provide training to build or code but 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.