The BookCAT database

Previous pageReturn to chapter overviewNext page

The information about your book collection is stored in a database. A database is a file on your hard disk, with the extension .MDB, that contains all the information you have entered into the database.

A database consists of several tables. Each table contains related information. For example, there is one table with information about each book, one with information about each person, one with information about each publisher, and so on. Each table contains a various number of fields. For example, the Person table has a field for the name of the person, one field for the date of birth, one field for comments, and so on.

BookCAT lets you change the name of all tables and all fields. You can specify a default value for most fields. You can hide the fields you don't want to use. They will then disappear from all windows, menus, lists etc. You only use the fields you want.

BookCAT lets you work with an unlimited number of databases. This means that you can split your collection into different catalogs and organize it to meet your needs. You can later merge existing databases.

BookCAT uses a relational database model. This means that you register most information only once. For example, you only need to type the name of an author the first time you add a book by this author. Later, you simply choose the name from a list. BookCAT then automatically creates a link between the book and the author. When you modify an entry in a lookup table, for example, to fix a typing error, the change will be reflected in all fields that are linked to the lookup table.

The use of lookup tables to store information has two significant advantages: it saves time and conserves valuable disk space on your computer. It also makes it easier to search for exactly the information you are looking for, or create a group based report. And finally, it allows you to store useful information about each entry in a lookup table. For example, you can store a person's e-mail address or a publisher's home page URL.




Do you have question? E-mail us at support@fnprg.com.