If there is a need to build a custom database, then it's probably safe to say using Microsoft Office is the best among all. Once it is determined that the customer needs a custom database, the next step is to advise them on the best way to plan, design, and possibly create the database.
Here are 5 basic tips that customers should know and meet with a custom MS Access database developer before they start building your database.
1. The ultimate goal in sight – report!
Find and identify which reports you need to achieve. Ultimately, this is what every database system should serve and strive for. List the basic reporting requirements that will actually help the consultant formalize the database architecture throughout the project.
2. Who will use the database?
Define the user roles in your database application that are responsible for running the day-to-day Access database. It should be broken down into different usage categories, namely end-users who are responsible for data entry, users authorized to generate reports, etc.
3. Migration of data from the old system – tables!
You will most likely need to populate data from other systems in the newly created Access database in their "normalized" tables. This means two things; a) Clear data ready for import and b) Import actual data into the Access table and set the correct index.