I always find it amazing that even with the internet, it can sometimes be very hard to sift through all the available materials to find good tutorials and learning tools. Below are a few good starting points. Some are MS Access specific, but many are just database generalities whose techniques can be used with any RDMS. So if you are starting off, or merely brushing up, here are a few good links to consider:
For starters, some of the best websites are those created by the various Microsoft Access MVPs. I have compiled a separate list of their websites in the following post: https://www.devhut.net/mvp-sites/.
Also, you will find a series a links below covering a variety of subjects. I cannot take the credit for this listing, but thought it was so good that it should be posted for all to see:
- Access Best Practices and Troubleshooting Steps
- Naming Conventions
- Crystal’s ACCESS Basics for Programming
- Database planning tutorial Part I
- Database planning tutorial Part II
- argeedblu’s FAQ on Design Strategies
- Noah’s FAQ on Normalization
- Jerry’s FAQ on Normalization
- GroverParkGeorge’s PDF on Normalization
- Jerry’s FAQ on Fully Qualified Naming
- Jerry’s FAQ on Glossary
- Allen Browne’s Reserved Word Listing
- Autonumbers – What They Are / Are Not
- Primary Keys – Natural vs Surrogate
- Database Answers (free models)
- Description of the database normalization basics (previously http://support.microsoft.com/kb/283878)
- The Evils of Lookup Fields in Tables
- Sharing/Splitting a Database
- Access Tutorial
- Access VBA Tutorial
I also offer videos on my YouTube channel that can quickly get anyone up to speed on a multitude of subjects: