Ensuring the right data goes into Access

A Microsoft Access database is a great place to store and organize information since it gives you an unlimited number of ways to look at that data later. But what you can do with that data is limited by the quality of your data entry. This can be a challenge, especially if you’re going to…


Setting up your Access database for success

I recently shared some guidance on when to use Microsoft Access vs. Excel for storing your data. Regardless of which tool you use, the quality of your data is critically important. So it’s vital that everyone who enters data does it in the same way. If they don’t, you won’t be able to do any…


Where should I put my data, Excel or Access?

When you have a lot of data and it needs to be organized, do you use Excel or Access? I get this question a lot when talking to people and I wish I could give you a short answer. Well, I guess I can: It depends. I understand why people are confused. In Access, you…