Access 2007 Tutorial 1.2. Tables and Relationships

Be patient with this video, it’s longer than normal (over 7 minutes) but it covers the essentials when designing and creating a relational (one-to-many) database using two tables.

Keep the rules simple and I have three which I want to share with you:

  1. Make sure the field’s data type is the same size (and where applicable the same size)
  2. Ideally, keep to the same name fields which you are joining – it will help you. Access doesn’t really care!
  3. When creating your join, do this before you add any data in either table especially when setting the ‘Enforce Referential Integrity’ option. Microsoft Access will actually check the data integrity (if any data exists).

Setting the relationship between tables is carried out in one of two places; the Relationship Window (as in the tutorial) and the other in a query itself but doesn’t offer the ‘Enforce Referential Integrity’ option.

There is more to this – it only the start but it is clear to follow and worth a view.

This entry was posted in Database Theory, MS Access, Utilities and tagged , , , , . Bookmark the permalink.

3 Responses to Access 2007 Tutorial 1.2. Tables and Relationships

  1. Ben says:

    Many thanks – alwaysy appreaciate the feedback :)

  2. as seen here says:

    We stumbled over here from a different web page and
    thought I might as well check things out. I like what I see so now
    i’m following you. Look forward to checking out your web page for a second time.

  3. Hi,

    I liked your video. Thanks for taking the time to make it. I doing a project and I needed to know how tables work on microsoft and you helped me a lot. Thanks again!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Confirm you are human.