Databases are designed to offer an organised mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form. It’s not much of a stretch from spreadsheets to databases.
Computer files can be divided into two broad categories: binary and text. The distinction is subtle because in many contexts any file is a sequence of digital bits.
There are five steps in creating and using a database for your own data, although steps 3 to 5 are often repetitive steps.
It is sometimes a problem to kn w how best to capture all the data for a database. There are a number of options.
Exactly how to query and analyse the data will depend what you need to know. As the examples show, the queries can take data from many tables, you do not need to display all the fields, and you can search for different groups of records.