VCS with docFX,

Have you tried Database Documenter?

Help System

Right-click on each item on the navigation pane and click Properties, where you can type a custom description (max 255 chars) for that item.  Turn on "detail view" in the navigation pane to see your custom description next to each item.  See Figure 1 below.  

If you have a lot of VBA code, you also need to make ample comments for it.  Type in anything that will jog your memory easily when you haven't seen the code for a long time.  In my VBA code (Figure 2), I comment the date each procedure was created, all the dates it was revised, and the reasons it was revised.

You can also use OneNote, part of Office, for your note-taking (Figure 3).  I use OneNote to record any noteworthy computer issues that arise.  I've been doing that for years.

Yes, all this is time-consuming, but in any professional setting, this is part of the job.