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
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
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)
You're awesome! Thanks Steve
Apparently I cannot delete posts.
Last edited by CryLittleSister; 04-07-2017 at 09:21 AM.
CyrLittleSister - I don't think "DLC" would be too pleased if you gave away your purchased product to others.
Every thing mentioned are all relevant to learning. I got an idea from those links. Thanks too for giving us some resources.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)
YouTube and sites like this one are a great source.