About redesign Your MS Access Database to make it More Efficient
The great thing about Access is that almost anyone capable of using Excel can get going with it. The downside is that frequently, proper database design is the last thing on a User's mind. The result is that, instead of a database that assists complete, accurate and consistent data input, you get several different spellings of a customer's name and umpteen different products that really are the...
The great thing about Access is that almost anyone capable of using Excel can get going with it. The downside is that frequently, proper database design is the last thing on a User's mind. The result is that, instead of a database that assists complete, accurate and consistent data input, you get several different spellings of a customer's name and umpteen different products that really are the same. In other words - garbage in, garbage out!
I can remodel your old database so that it contains the necessary number of tables with appropriate relationships between them. What you get is a way to store your data so that it is more consistent, reliable and supports accurate and meaningful reporting.
Without proper reporting, your business is effectively rudderless.
see more