I haven't done a ton of development for a while now, but I have done some significant development with access in the past. Might go a bit over your head, but the last major project I did was an IT inventory database. The development included lots of tables, queries, reports, and stuff. But beyond that was a lot of scripting that ran on all our managed pc's to collect hardware and software info, and then tools to import that info into the access database.
Pretty crazy stuff, but there's definitely some masochistic fun in figuring out how to make it all fit together and work as a whole.
I just started playing around with a humidor inventory program that has a few things to be desired, and its actually making me think about dusting off some of the old access skills.