Here's an important tip, especially if you are starting out like I did, with absolutely no knowledge of SQL, Visual Basic, macros, etc. Learn by example. Find any examples you can, dissect them, find out how they tick, and then apply that to your own project. Microsoft put out some terrific example databases for Access. The great thing about them is that they demonstrate a specific feature you might want to add to your own solution, like sorting a report dynamically, or closing a report automatically if it has no data.
Report sample database
Query sample database
Northwind Traders sample database