Quote:
Originally Posted by lilac_jive
I honestly don't even know where to start  But I can make a spreadsheet sing and dance  One day I'll teach myself Access and see if I want to migrate it over. I like that I can run different tabs on excel (I have a few for different things, mainly what to buy). I don't know if I can do that with Access. |
You'd have different tables holding different information - so authors, genres, titles, format etc.
Then you'd have a form to input the data onto. The fields on the form are linked back to the different tables, so when you fill in a form, the data gets entered into the correct places.
Then you'd have as many different reports as you can think up to show you whatever you want to see - so all books in one genre by one author that you've read, for example.
To make it even easier, you then have a user interface with buttons on so you can just click to get the input form, generate a report and so on.
If you do go down the Access route, and you use the tab key to navigate between fields in a form, make sure you check the "tab order" is correct, otherwise you'll get horribly frustrated as each press of the tab key takes you somewhere unexpected!
Edited to say:
You'd also need to set up relationships - so one author can be related to many book titles etc