I know we're all working from home these days, but in an office environment where many people are working, the sound of tooltips going off around you as your coworkers use this Access database application might not be the most popular feature.
I learned, many many years ago, that having one spot on the screen where an end user can ALWAYS look for help generally works best. I'd suggest having a fairly large text control that you can load with help text when a control gains focus will work far better than tool tips or audio tips. When I've done this, I've always had it load from a "Help" table that has form name / control name / display text. Look up based on form and control, load when control gains focus. End user can then ALWAYS just look at it to see what they need, and I've learned users will AWAYS need more help than just a tool tip!
It was a quiet day so I had time to reply
Your email suggested you wanted to enable or disable sound with tooltips.
On the rare occasions I use balloon tooltips, I never use sound and, as mentioned previously, I doubt you will be popular if you do add sound