Results 1 to 5 of 5

New to Forum

  1. #1
    Betteron2wheels's Avatar
    Betteron2wheels is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2019
    Location
    Maryland
    Posts
    2

    New to Forum

    Hi all,



    I got tired of using excel to track data and decided to relearn access. I used it years ago but only scratched the surface, now I'm at a place where I have challenges that are hard to solve with tutorials and might have enough knowledge to contribute to the group.

    Cheers,

    Shannon

  2. #2
    JoeM is online now VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,567
    Welcome to the Board!

    If you are designing your own databases, I strongly recommend that in addition to learning all the ins and outs of Microsoft Access, you also brush up on Relational Database Theory and the Rules of Normalization. Some years ago, when I was designing my first "real" database in Access, I tried it without this knowledge, and spun my wheels for quite a while (and kept programmning myself in corners). Someone pointed me in that direction, and I realized that my tables were not normalized. I scrapped everything, and started over, and had much better luck the second time around. It is imperative to create properly normalized tables! You can find lots of information on it via Google Searches (lots of tutorials, videos, etc).
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    Betteron2wheels's Avatar
    Betteron2wheels is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2019
    Location
    Maryland
    Posts
    2
    Thanks for the tip! I'll check it out.

    Cheers.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    13,337

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    7,936
    Here is what I refereed to for Normalization (and I still look at them occasionally)
    Maybe a starting place for you:


    Normalization http://www.utteraccess.com/wiki//Normalization
    Normalization Terms and Concepts http://www.utteraccess.com/wiki/Norm...s_and_Concepts


    What is Normalization?
    =======================
    What Is Normalization, Part I: Why Normalization? http://rogersaccessblog.blogspot.com...on-part-i.html
    What Is Normalization, Part II: Break it up. http://rogersaccessblog.blogspot.com...n-part-ii.html
    What Is Normalization: Part III: Putting It Back Together http://rogersaccessblog.blogspot.com...-part-iii.html
    What is Normalization: Part IV: More Relationships http://rogersaccessblog.blogspot.com...n-part-iv.html
    What Is Normalization: Part V: Many-to-Many Relationships http://rogersaccessblog.blogspot.com...on-part-v.html


    Entity-Relationship Diagramming
    ==============================
    Entity-Relationship Diagramming: Part I http://rogersaccessblog.blogspot.com...ng-part-i.html
    Entity-Relationship Diagramming: Part II http://rogersaccessblog.blogspot.com...g-part-ii.html
    Entity-Relationship Diagramming: Part III http://rogersaccessblog.blogspot.com...-part-iii.html
    Entity-Relationship Diagramming: Part IV http://rogersaccessblog.blogspot.com...g-part-iv.html


    The Normal Forms
    =========================
    The Normal Forms: Introduction http://rogersaccessblog.blogspot.com...roduction.html
    The Normal Forms: First Normal Form (1NF) http://rogersaccessblog.blogspot.com...-form-1nf.html
    The Normal Forms: Second Normal Form (2NF) http://rogersaccessblog.blogspot.com...rmal-form.html
    The Normal Forms: Third Normal Form (3NF) http://rogersaccessblog.blogspot.com...rmal-form.html
    The Normal Forms: In a Nutshell http://rogersaccessblog.blogspot.com...-nutshell.html
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Hello Forum
    By D_InSub in forum General Chat
    Replies: 6
    Last Post: 07-06-2018, 11:16 AM
  2. Forum Help
    By AccessLearner24 in forum Access
    Replies: 1
    Last Post: 10-22-2014, 09:32 AM
  3. Converting dBase forum to Access forum
    By amerifax in forum Forms
    Replies: 5
    Last Post: 07-03-2012, 12:12 AM
  4. Any forum for ASP.NET
    By coolpal9 in forum Access
    Replies: 1
    Last Post: 01-13-2012, 12:09 PM
  5. forum help!
    By karanvemuri in forum Forms
    Replies: 9
    Last Post: 09-06-2011, 10:10 AM

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