pictorial view of different data tables

[ntambomvu]

Hello Chaps,
I am new at this and I hope that someone is able to assist me in finding nice looking
forms for the data base I am writing.
I have followed the tutorial guidelines about how to create forms and now i want to go a step
further by designing nice looking user interfaces.
Is there anywhere that i can look at sample tables and then see how they are put together.
I have opened some of the template tables that come with access ( under "New" in options )
and I would like to know how the writer gets them to look so nice .

I would really like some help
regards
fred

[dashiellx]

Form design is really just trial and error.

One things to keep in mind is making sure your form controls are properly aligned. Another is to keep it simple. Try not to make a form too busy when just opening new form to interact with a specific function can be cleaner and easier.

[orange]

You may get some interface design ideas from this link.

The more common terminology is "designing a database" rather than " data base I am writing" -- but we understand.
It seems you are concentrating on interface, and haven't described the business involved, nor the tables and relationships which are the heart of a database.

[Micron]

designing nice looking user interfaces.

I have opened some of the template tables that come with access ( under "New" in options ) and I would like to know how the writer gets them to look so nice .

Those 2 points are somewhat counter-intuitive. Users shouldn't ever see tables, so how nice they look is irrelevant. How they are normalized and related definitely is important. The best looking form/report is useless if it doesn't do the job, so once the tables look like they're designed and related correctly, I'll create the query for that form and test it. If it isn't updatable and needs to be, then the form I might have created for this is useless, so for me, queries before forms/reports. I seldom base a form on a table, and if a form's records come from 2 or more tables, it's impossible anyway unless you want to have a main form and enough subforms to cover all the tables involved. To me, that would be going about it the hard way.

Don't get trapped by putting the cart before the horse when it comes to the design process.