Results 1 to 7 of 7
  1. #1
    Koolaid is offline Novice
    Windows 8 Access 2016
    Join Date
    Mar 2016
    Location
    Northern VA
    Posts
    26

    Question Best place to start?


    So what source is the best FREE place to learn about Access. I'm using 2010 at work but using 2016 at the house. I know I can google it but you guys here have been there and done that and will know the best places to get that info. Thanks!

    Koolaid

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    If you are interested in database design, I think the most helpful things were first learning about things like Relational Database theory and Rules of Normalization. The following two links have a lot of good information on those topics:
    http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
    https://support.office.com/en-us/art...rs=en-US&ad=US

    See:
    Programming Access vba by Steve Bishop
    https://www.youtube.com/watch?v=kogGwRIHH6o
    This is a series of over 70 videos. Above is the link to the first, but you can do some searching to find specific subjects.

    And for a follow on watch this series of youtube videos by Dr Daniel Soper.
    https://www.youtube.com/watch?v=4Z9KEBexzcM
    Be sure to watch 1,2 and 4 in the series.

    I think you would help yourself by working through a database and table design tutorial.
    See this one from Rogers Access Library.
    http://www.rogersaccesslibrary.com/forum/forum46.html
    You will learn how to go from a description of your requirements to a database structure to support those requirements. You have to work through the tutorial, but you will learn and what you learn can be applied to any database. Should take 40-60 minutes.


    Then there is the need to know stuff:
    Autonumbers--What they are NOT and What They Are
    http://www.utteraccess.com/wiki/index.php/Autonumbers

    Microsoft Access Tables: Primary Key Tips and Techniques
    http://www.fmsinc.com/free/newtips/primarykey.asp


    Object names should be letters and numbers.
    Do not begin an object name with a number.
    NO spaces, punctuation or special characters (exception is the underscore) in object names


    Google "Naming conventions". Very import (IMO)

  3. #3
    Koolaid is offline Novice
    Windows 8 Access 2016
    Join Date
    Mar 2016
    Location
    Northern VA
    Posts
    26
    You're awesome! Thanks Steve

  4. #4
    Join Date
    Mar 2017
    Posts
    12
    Apparently I cannot delete posts.
    Last edited by CryLittleSister; 04-07-2017 at 09:21 AM.

  5. #5
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    CyrLittleSister - I don't think "DLC" would be too pleased if you gave away your purchased product to others.

  6. #6
    Tonya Alcantar is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Dec 2014
    Posts
    36
    Quote Originally Posted by ssanfu View Post
    If you are interested in database design, I think the most helpful things were first learning about things like Relational Database theory and Rules of Normalization. The following two links have a lot of good information on those topics:
    http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
    https://support.office.com/en-us/art...rs=en-US&ad=US

    See:
    Programming Access vba by Steve Bishop
    https://www.youtube.com/watch?v=kogGwRIHH6o
    This is a series of over 70 videos. Above is the link to the first, but you can do some searching to find specific subjects.

    And for a follow on watch this series of youtube videos by Dr Daniel Soper.
    https://www.youtube.com/watch?v=4Z9KEBexzcM
    Be sure to watch 1,2 and 4 in the series.

    I think you would help yourself by working through a database and table design tutorial.
    See this one from Rogers Access Library.
    http://www.rogersaccesslibrary.com/forum/forum46.html
    You will learn how to go from a description of your requirements to a database structure to support those requirements. You have to work through the tutorial, but you will learn and what you learn can be applied to any database. Should take 40-60 minutes.


    Then there is the need to know stuff:
    Autonumbers--What they are NOT and What They Are
    http://www.utteraccess.com/wiki/index.php/Autonumbers

    Microsoft Access Tables: Primary Key Tips and Techniques
    http://www.fmsinc.com/free/newtips/primarykey.asp


    Object names should be letters and numbers.
    Do not begin an object name with a number.
    NO spaces, punctuation or special characters (exception is the underscore) in object names


    Google "Naming conventions". Very import (IMO)
    Every thing mentioned are all relevant to learning. I got an idea from those links. Thanks too for giving us some resources.

  7. #7
    Noob Access is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Posts
    1
    YouTube and sites like this one are a great source.

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

Similar Threads

  1. Best place to hire freelancer
    By Homegrownandy in forum General Chat
    Replies: 10
    Last Post: 04-20-2016, 03:00 AM
  2. Replies: 6
    Last Post: 03-02-2016, 12:58 PM
  3. How to keep your place when adding a new record
    By Access Nick in forum Access
    Replies: 2
    Last Post: 02-16-2016, 04:12 PM
  4. Best place to start Access self-education
    By mholst in forum Access
    Replies: 4
    Last Post: 07-19-2013, 04:02 AM
  5. Rounding up decimal place
    By swagger18 in forum Programming
    Replies: 4
    Last Post: 01-28-2011, 08:29 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
  •  
Other Forums: Microsoft Office Forums