Results 1 to 5 of 5

Organize my database

  1. #1
    Join Date
    Nov 2019
    Posts
    2

    Organize my database

    Hello,



    First time using access and I really don't know how to use it.

    This is what I need: I have let's say 50 workshops.

    Each workshop have multiple fields as Technical specs, Description, Objectives, Constraints...

    Many fields have multiple "sub-fields" like the Objectives field: objective 1, objective 2, objective 3...

    How do I create this kind of database ?

    What I wish after the database creation is for example to search for example all the workshops that require a specific constraint and so on...

    I do hope I've made myself clear.

    Thank you very much for any kind of help.

  2. #2
    ssanfu is online now Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,477
    See this link. Look for "tutorials from RogersAccessLibrary." For practical experience/learning, spend 45-60 minutes and work through at least one or two of them.

    Use the same process with your own database to get the tables and relationships set up. Use pencil and paper and draw (design) your tables. Getting the tables set up and normalized is the critical part.
    "Old Programmer's Rule" is this: If you can't do it on paper then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.


    When you think you have the tables designed, post back here to have the forum review the design BEFORE jumping onto the computer. This will save you from banging your head against the wall....
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #3
    Join Date
    Nov 2019
    Posts
    2
    Hello,

    OK I'll look into it and spend the necessary time and come back to you when I be done.

    Thanks a lot.

  4. #4
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 10 Access 2016
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,436
    Attached is a whitepaper on DB set up.
    Attached Files Attached Files

  5. #5
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    139
    removed post sorry!

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

Similar Threads

  1. Is there a better way to organize this data?
    By TerraEarth in forum Database Design
    Replies: 1
    Last Post: 03-20-2018, 09:57 AM
  2. Replies: 6
    Last Post: 06-15-2014, 07:21 PM
  3. How to organize queries?
    By adacpt in forum Access
    Replies: 3
    Last Post: 01-22-2012, 09:10 PM
  4. Basic How-to-Organize ?s
    By flwrgrl in forum Access
    Replies: 3
    Last Post: 04-28-2011, 02:22 PM
  5. Best way to organize a small database of people?
    By Orabidoo in forum Database Design
    Replies: 1
    Last Post: 06-09-2009, 10:13 PM

Posting Permissions

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