Donate SIGN UP

creatiing a list

Avatar Image
gardenmad | 22:06 Fri 29th Sep 2006 | Technology
4 Answers
I want to catalogue my books, which are many, and I want to create an alphabetical list on my computer - being compute illiterate, I do not know how to do this - I would like to be able to make lists of authors alphabetically, and also, separately, lists of books by subject, e.g. gardening, cookery, biology, histories, etc. Any help would be much appreciated.
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by gardenmad. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Use your spreadsheet programme (eg. Excel) to create a very simple database. Create columns for author (in the format 'Last Name, First Name', Title (moving any 'The's or 'A's to the end, following a comma), and any other info you want to use - ISBN, subject or whatever.

Now, say you want to order them by title - highlight all the rows you want to order, then click Data > Sort. You'll get a box asking you whether you've included your header rows or not, and which column you want to sort by first. Just select the options you need, click OK, and wahay - you're there!

You could use a database programme, but if you're not too computer-savvy they can be quite long winded to set up and can sometimes do quite alarming things if you're not too sure what you're doing.

I use Excel to manage our library service's 400 odd subscription titles in this way, and it hasn't let me down yet.
As your want's don't sound too complicated. Try and get hold of " Access for dummies" it will show you how to do a basic database which will be sufficient for your needs. Not sure,but there may even be a Wizard on access to help
Question Author
Thank you to all who replied, I shall investigate them all, but yours, Chris, is just what I want - I've downloaded it already and look forward to a few quiet hours using it. Thank you very much indeed!

1 to 4 of 4rss feed

Do you know the answer?

creatiing a list

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.