Relationships in Access 2010 templates

[Ricardo]

I am browsing through the database templates on Microsoft's website hoping to learn how relationships between the tables are configured. The problem is none of the templates allow me to click on the relationships button on the Database Tools ribbon. Does anyone know why this is?

[June7]

I don't have that issue. Exactly which templates?

[orange]

If your underlying issue is with relationships - why, how etc, then here are some free videos that go through a sample showiing various design concepts.

You may want to view and review these tutorials. The underlying theme is Customers,Orders, Items and involves pricing.
There are many design concepts in the material.
These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming