Hi,
I'm a US Military Member Stationed in Yokosuka, Japan. I'm looking to learn more about MS Access as I have done with Excel. Slowly getting an understanding of relational Databases.
Thank you all in advance,
Jim
Hi,
I'm a US Military Member Stationed in Yokosuka, Japan. I'm looking to learn more about MS Access as I have done with Excel. Slowly getting an understanding of relational Databases.
Thank you all in advance,
Jim
Welcome aboard!
That is a great place to start. Understanding relational databases and the rules of normalization are key to developing a well-designed database. Here is a an article that is a good place to start: https://support.office.com/en-us/art...4-bd4f9c9ca1f5
When I started, I also picked up a book of Relational Databases and Rules of Normalization. Understanding those concepts helped me immensely.
And of course, feel free to post any questions you may have here.
And, thank you for your service!
Konichi wa. O ginki desu Ka.
Thanks for your service...
Additional reading:
------------------------------------------
Normalization Terms and Concepts http://www.utteraccess.com/wiki/inde...s_and_Concepts
Normalization http://www.utteraccess.com/wiki/index.php/Normalization
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
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...nd-normal-form.
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
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...ming-part.html
Entity-Relationship Diagramming: Part IV http://rogersaccessblog.blogspot.com...-i-ii-and.html
=======================================
Access Basics Tutorial by Crystal (Strive4Peace) http://www.utteraccess.com/wiki/inde...asics_Tutorial
JoeM,
Thank you for pointing me in the right direction. I've started watching a YouTube series https://www.youtube.com/playlist?lis...03jQ_t9nFV737s by Steve Bishop and his channel Programming.
V/r,
Jim
I appreciate your Thank you.
Steve,
Thank you for all of the links. I'm slowly learning this as I hope to create a productive easy to Database Application. In my view we spend an inordinate amount of time "tracking" different items and personnel. I'm astonished at how good these Programs such as Excel and Access are but we don't seem to use them effectively.
Thank you again for your efforts to get me started off right. I've started with Steve Bishop on YouTube and found his instruction very easy to follow.
V/r,
Jim