struggling to understand ms access

unwashed potato! · 8 Dec 2007 at 15:19

having to use access for homewokr and struggling to understand it,not sure why,maybe my mind is not with it, maybe it's because i have used mySQL and access is not how i think for db anymore idon't know but im in need of help.

hoping you guys can just give me a quick explanation of how it works, things like relationships, why you have them, and what feature you use to which part, like some reason at first i was designing my table as i'd want the form to work and now just changed it to work better and thenget the form to do what i wanted.

is there anything you do when planning a database? maybe some tips for me so i can plan this better.

thanks

radderfire · 8 Dec 2007 at 19:49

Have a table for each logical set of entities, e.g.

Customers
Orders
Products

In each table, have an Id e.g. CustomerId which you can index on (set a primary key).

You can then set up relationships between the tables, e.g. when a customer makes an order, in the orders table you have a column called CustomerId so you can see what customer made the order without having to record all their details in the orders table.

Rgds

Radderfire

radderfire · 8 Dec 2007 at 19:50

Having the separate tables associated by Ids etc is what's meant by a relational database, look that up on Wikipedia or Google.

Rgds

Radderfire

Alpha · 10 Dec 2007 at 23:06

If you are getting stuck on particular issues, I have found this to a very useful resource as I have been learning Access over the last year: Link