RB User Guide > Tools > Query Maker
Database
A database is a place where organized information is stored for a purpose. There are many types of databases; RB9 uses a relational database. Relational databases store and display data in a tabular format of rows and columns, like a spreadsheet.
TIP: Think of a database like a filing cabinet
A relational database is structured much like a manual filing system:
- The “filing cabinet,” which contains all of the data we want, is called a database.
- Each of the “drawers” in the filing cabinet is called a table. A table stores a specific set of information — there’s one table for firms, another table for contacts, and another table for locations, for example.
- The “sheets of paper” stored in folders in the filing cabinet are called records. So the Firm table would have a record for each law firm, listing their name, address, etc.
- The individual entries on the sheets of paper (name, address, etc.) are called fields.
These components form the core of a relational database.
Reference
Step-by-step instructions