New Access User Questions About Our Library DB

Hello,
I'm new to Access. I've recently started helping here at a non-profit literacy org. They have a small library and they were keeping track of it in an Excel spreadsheet. I moved it over to an Access database which seems much more appropriate and better in a lot of ways... Anyway, I'm not sure where to look or even exactly what I need to ask but here goes.

I think what we want to do is something like an invoice. The current database has one record for every book in the library and each record has fields like: book name, checked out (yes/no), date due, and borrower name.

It was nice and easy to write a little query with "<date()" on the due date field to generate a list of overdue books, then we used Word to merge the data and generate letters to send to the people with the overdue books. The problem is that most people have checked out more than one book so our simple merge ends up making one letter for every overdue book.

The first thing we'd like to accomplish is: how do we make a table? querry? report? which makes a new table with one record per borrower then each of the books that borrower has checked out?

It doesn't matter to me which way we do it, just so long as we can end up making just one letter per borrower, with that letter having each of the books listed. This seems kind of like an invoice to me, so maybe if I looked at invoice examples that would help? But that might just be more complicated and confusing?

If it's not too hard, there's a 2nd thing we'd like to do, and that is to, either from a 2nd database, or from data in the same database, but in a different "table"(?) get the person's address and merge that into the letter too, based on the borrower name.

Sorry if I'm being an annoying NOOB ~ if you think there are some things I should read first before asking these sorts of questions, perhaps you can point me too them? I'm at the stage where I don't even know enough to know what I don't know yet.

Just for reference, I do have tons of general PC & software experience, and have learned the C/C++, BASIC, Pascal, FORTRAN (77), 65816 assembly/machine code, and even a little LISP.

:)

Christopher