I made my tables and now Im stuck. HELP

[the extinguisher pro]

I have access 2007 and im trying to make a database for my business. I made the tables and relationships but, now what? Can someone walk me through?

[khalid]

I have access 2007 and im trying to make a database for my business. I made the tables and relationships but, now what? Can someone walk me through?

Would you please read Fundamentals of Relational Database Design?
http://office.microsoft.com/en-us/ac...001224247.aspx

[the extinguisher pro]

thank you Khalid... I think I've followed the first three normalization rules so far but I just dont know where to start building my forms. Would it help if you took a look at what I have so far?

[orange]

You're probably not looking for more reading, but I think the Entity Relationship diagramming here might help. I think the links below will fit with the materials that
Khalid has suggested/recommended.

http://www.rogersaccesslibrary.com/T...lationship.zip

Also to see some free existing data models, this link has several
http://www.databaseanswers.org/data_models/index.htm

also, there is an approach to db design here
http://www.databaseanswers.org/approach2db_design.htm

[khalid]

thank you Khalid... I think I've followed the first three normalization rules so far but I just dont know where to start building my forms....?

As orange gives you lot of information about the entity, relationships, normalization etc, you might have some idea now why these all necessary for good database design?

As a newbie, you might not understood all these in detail, but don't worry, just start with the basic table and develop it gradually.

The first thing you have to do is and as a rule, you should have one primary key in your table, sometime it look ugly to have primary key for each table, but potentially it helps a lot on some uncertain occasions while you have no other choice to pull the data by using this id key.

Anyhow we are still not clear that what type of business you are doing and what type of database you want to create? we will try to help...

[the extinguisher pro]

thank you orange....

[orange]

Glad to help. The theory is great, and as Khalid says, start with the first thing -- Primary Key on a table, and work from there.

Use the references as references and some casual reading. it will all start to make sense. Once you understand "why some things are good", it will make the design and development much more rewarding.

[blue4512]

Put information in each table and then start playing with queries.