The CATraxx database

Previous pageReturn to chapter overviewNext page

All information about your music 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 album, one with information about each track, one with information about each artist, one with information about each label, and so on. Each table contains a various number of fields. For example, the Artist/Person table has a field for the name, one field for the country of origin, one field for notes and so on.

CATraxx lets you rename all tables and all fields. You can also specify a default value for most fields. For example, if most of your collection consists of CDs, you can specify CD as the default value for Format. 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.

CATraxx 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.

CATraxx 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 artist the first time you add an album by this artist. Later, you simply choose the name from a list. CATraxx then automatically creates a link between the album and the artist. 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 an image of an artist or a label's home page URL.




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