Tried and failed to use Access after 8 years without touching it

I spent about six hours today trying to build a form that would prompt me to take a survey about my day every night, then compile the data and email me a weekly report. It's supposed to be a mechanism for maintaining self-care when I don't have the energy to think about it: Off-loading the responsibility for remembering that I'm supposed to be paying attention to overall trends in my life.

My effort included extensive googling, building two Google Forms, downloading Microsoft Office via my school's free MS agreement, attempting to re-learn Microsoft Access, building the whole form again in Access, using four inter-referential tables, then giving up.

Now I've set my To-Do list app to remind me at 11 p.m. with a link to the Google Form, and I guess I'll have to manually dig through the data, which is less than ideal. Hopefully I'll be able to figure out a better solution before the next time it gets too overwhelming for me to keep up with it.

If anybody knows any good tips on how to set something like this up, let me know.