I have a four-year computer science degree from the US Military Academy at West Point, but the bulk of my foundational Access knowledge came from one man: Allen Browne.
While Allen's site has not been updated in over ten years, I still feel it is the best one-stop shop on the internet for people of all abilities, with curated tips for "Casual Users", "Serious Users", and "Programmers."
Every article on Allen's website is top-notch, but these ten are my favorites:
- Problem names and reserved words in Access
- Common query hurdles / Why is my query read-only?
- Common Errors with Null
- Subquery basics / Surviving Subqueries
- Extended DLookup() / Extended DCount()
- Intelligent handling of dates at the start of a calendar year
- Soundex - Fuzzy matches
- Reports: a blank line every fifth record
- Failures caused by Name AutoCorrect
- Why I stopped using Yes/No fields
What about you? What are your favorite Allen Browne articles? Let me know down under in the comments (pun intended–Allen's an Aussie).