I generally use several fairly simple forms and navigate the user through them in a prescibed order. I also generally base a form on 1 table and then use subforms (within the main form) each based on a related table. You might check out this site for some tutorials. I usually use the form wizard to do the initial setup and then make changes from there.
Now that you have progressed beyond the table structure, I would recommend that you start a new thread related to any specific form design questions that you may have. Much of the form design part is up to your personal preferences, so getting ideas from others on the forum will probably prove more beneficial then my more simplistic approach.