Microsoft Press has just published the book "Building Microsoft Access
Applications" by John Viescas that has a Membership Database application
with lot of explanation.
I haven't looked at this Membership databases but the other databases I
looked at in this book are excellent. It may be a good start for you.
Disclosure: I received this book as a free gift but you should browse the
bookshop and see it for yourself.
