Forum Discussion
mhboise5766
Nov 03, 2022Copper Contributor
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...
George_Hepworth
Nov 03, 2022Silver Contributor
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.
mhboise5766
Nov 03, 2022Copper Contributor
Okay great, I will check "Database Normalization", And I will continue to explore Access. I don't think I would need to "Automate" OneNote but I was thinking if I could have a link in Access to the Journal entry in OneNote... that sort of thing. Thank you!
- George_HepworthNov 03, 2022Silver Contributor"I was thinking if I could have a link in Access to the Journal entry in OneNote." I don't really think so, but no one I know has tried. It might be doable via automation.
- mhboise5766Nov 03, 2022Copper ContributorOkay, I will keep that term in mind as well. Thanks for your advice!
Leslie