Forum Discussion
OneNote To Access
Currently I use OneNote as a Journal as I gather information to order parts for HVAC service techs. So I have notes about who I talked to what they need and then I have data like model numbers, seri...
First, it's usually better to provide more information rather than less information. People are capable of filtering out what they don't need, but they would have no way to know what was left out of a simplified description, so it's good.
Yes, Access handles tasks like this extremely well. Access, however, requires more knowledge and understanding of good, or appropriate database design to enable getting it done right.
I am not sure that you could automate OneNote from Access, but that's not something I've heard of anyone doing, so maybe it's possible, just rare.
Start with a thorough review of Database Normalization. That means the design principles that all relational database applications should be built on.