Dan,
The temptation for beginners is to use every colour they can find, plus
pictures and animations, and so on. Another great mess-maker is to place on
the form every field you're ever likely to want.
The basic rule-of-thumb is the KISS principle. Keep the user interface
simple and logically ordered!
Use standard colours, control heights and font styles/sizes. Group controls
into logical "chunks" of 5-7 items, but no more than 9. Show the user only
what they are able to use at that time.
As Larry and Klatuu said, there are many examples and references on the net
and in books. Visit your local technical bookshop and pick up a book on User
Interface Design Principles, or if you're game, Human-Computer Interaction
(HCI).
Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia