3 years ago I started on a access project. Throughout that time my dB has grown from 3 tables for one job to over 30 for multiple, because I saw the "power" of how I could track anything I wanted and built it to work for my business.
I can honestly say that I think it's normilized to the best of my ability, and not entering data twice when it can be done once.
However one thing I just dont understand - I have alot of queries. It just seems like I have to many, everytime I want to create a new report I build a query for it.
Is this wrong design? I have seen that you can have multiple criteria on queries. Can I use the the same queries multiple times?
I can honestly say that I think it's normilized to the best of my ability, and not entering data twice when it can be done once.
However one thing I just dont understand - I have alot of queries. It just seems like I have to many, everytime I want to create a new report I build a query for it.
Is this wrong design? I have seen that you can have multiple criteria on queries. Can I use the the same queries multiple times?