Design and Primary Key Help Needed

[greek49]

Hello,
I am a beginner to databases and I would like to learn how to use Microsoft Office Access 2010. My preferred approach is to just dive in, so here we go. I have an awful lot of questions.
Are the primary keys meant to be cumulative, as in the example in the attachment, or is it better to have a different approach to primary keys? In what kind of design situation would you use Autonumber ID's? Could I have a design with a table which uses a PagesID which would contain every single page of every single report in my example and/or a table with an EntriesID to contain every single entry of every single page of every single report? Both of those could be primary keys.
Sorry to be such a newbie but your help would be appreciated, thanks.

[rzw0wr]

Start you trek by googling Normalization. Then relational databases.

PK are what identify the items in the table. Reference and relationships.

In about every, well always, I use autonumbering for my PK.

Most of what you are asking is easily found on the internet.

Dale

[orange]

Here are some links that may be helpful to you.
Database Design Principles http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

Video tutorials:
If you google for videos "normalization langer" you will find a series of free videos by Dr.Art Langer. These are quite good for learning by Watching/Listening rather than reading.

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

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

Good luck.