I like nice designs, but I have no artistic talent or formal training, so take this advice with a grain of salt. And the links are just to give you an idea of what I'm talking about.
Some design theory is the first part, just to understand that there's a reason one thing looks good and another doesn't, why one way is clear and the other is jumbled.
Some usability theory is the second part. You want to have some understanding on how people think vs. how Access "thinks".
The next part is planning. You want to draw some storyboards. Just rough sketches that consider different layouts. It really helps over trying to lay everything out with the built in tools. If you like Apple's stuff, their big secret is that careful planning is what allows them to *remove* stuff and still make it work.
Then you do the aggravating twiddling to convince Access to lay things out the way you want it to. There are no cheap tricks to make Access look good... some of its widgets are just ugly, and most of the third-party libraries are expensive and not much better looking. This is just my personal taste, but generally a nice, clean, simple design with one or two accent colors makes the best design.
Finally... the most important part that no one (myself generally included) ever does is
usability testing.
Now, I'm presenting the ideal case where you have lots and lots of time (but it doesn't cost much money, really!) but any part of this can help make your app tighter.