I've been using Access for the past 3 years. I am not able to design the forms because I am not a programmer but I really like the query interface. And I understand the logic of the relationships and can design the tables and relationships, and have a good idea of what is needed in order to get the product that I need.
So, in short, I wouldn't be designing the UI but I would be managing all the data and doing the data analysis, creating reports, etc. And I would be able to work with the programmers to explain what we needed.
My question is: What is the next logical progression to move to if I wanted to migrate our data from Access to another RDMS?