How do I compile an alphabetized and numerical book list?

T

Tashunka Witko

To compile a complete list of my book collection; catagorizing,
alphabetizing,and numbering the individual texts, I would appreciate any
suggestions as to the type of format available to me with microsoft tools.
 
S

Steve

Microsoft Access database would be a simple solution. The design of a
database begins with the proper design of tables. The following tables are
suggested:
TblCategory
CategoryID
Category

TblBook
BookID
CategoryID
BookTitle
BookNumber

Forms are for data entry and display data on screen and reports are printed
output. Your forms and reports should be based on a query that includes both
tables. You need a query to get an alphabetized list. In this query sort on
the BookTitle field ascending.This query could be used both for a form and a
report giving you an alphabetized list of books. You need a second query to
get a numbered list. In this query sort on the BookNumber field ascending.
This query could be used both for a form and a report giving you a list of
books by BookNumber.

Steve
 
Top