Results 1 to 5 of 5
  1. #1
    mikebellows is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Posts
    3

    Talking New To Access

    Hi,


    I am completely new to access - Literally started today!
    Anyway I have a problem - I am creating a CAD Drawing database / Distribution list. I can only seem to distribute one drawing i.e single field to one person.
    Is there a way to have multiple distribtion on one field without creating multiple distribution fields?

    What I have is a database which contains Drawing Numbers - I need to create a report that shows where the
    drawing has been distributed to, with it's current revision status and the date is was sent.

    I am having trouble trying to use multiple revisions and mutiple people in the distribution list with one drawing.

    Maybe not the best description!!!


    Thanks

    Mike ;-)

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    Start by writing down what it is you are trying to accomplish in "business terms".
    Don't get hung up in the innards of Access before you build a model of what you are working with.
    Understand Normalization and Entity Relationship Drawing before you are overwhelmed with trying to do something quickly.

    Step back - understand some concepts

    Get your tables set up. Create some test data. Identify some transactions and the expected outcomes. Test your model. Reconcile every issue (unexpected issue) and alter the model or the data until it does what you expect.

    There are videos(free) here that may help
    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

    http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

  3. #3
    mikebellows is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Posts
    3
    Hi,
    Thanks for the reply. Looks like a lot of info to take in.
    Unfortunately the company that I work for will not allow access to Youtube.

    I take on board your concept - Which I have in part done, but that doesn't help me - I sem to have hit a brick wall.

    To me it's simple - I need to show on a report that a single drawing (Including it's current revision status) needs to be recorded as being sent to multiple end users.

    Cheers,

    Mike.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    Here's another link (non youtube)

    The first few topics are well worth the read.

    http://www.rogersaccesslibrary.com/forum/topic238.html

    There may be a model or 2 here that can give you some ideas.
    http://www.databaseanswers.org/data_models/index.htm

  5. #5
    mikebellows is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Posts
    3
    Thanks - Much appreciated.

    I'm getting Headache now - Trying to work out how to fix my problem ;-(

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums