Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Access2003- Database Layout Help

  • Please log in to reply




  • Member
  • PipPip
  • 34 posts

Admittedly, I am somewhat a novice in MS Access, but have had some experience (I created a small system, 3 tables and 2 relationships).

However, with trying to create a system for a relative I have found myself stuck for how to layout this system, for example the tables and relationships required. Hopefully, a 'greater being' will be lurking around GtG, eager to help :whistling:

Record keeping system, for a collection of booklets.

Each booklet is uniquely identified by an ID number, and then classified into 4 different possible kinds of booklet. Each booklet is made up of a number of pages, which can vary (but is never greater than 10 pages). Each page belongs to a set type, of 10 different varieties. Each type of booklet and each type of page has a set (£) value. The Booklet has the value of its pages added and then compared to the value of the booklet, to find which is greater, which is known as the 'Actual Value'.

In the attached JPEG, I hope to have explained this slightly more clearly.

Thank for reading, hopefully someone can help!

Attached Thumbnails

  • DB_Design.jpg

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP