A database in Excel to create
In our small example, we create a supplier database.
- After you have considered what information should be maintained in the database, you distribute the data in the columns.
- The data for the later queries to create, you should, as always in a separate column.
- The respective columns, we provided with self-explanatory Headings such as supplier name, street, postcode, place, contact person, telephone number, supplier since, supplier, delivery time, discounts and so on.
- In the first column, we set an internal supplier number. Thus, you can assign the ID numbers later, it consists of one or more letters, depending on how many tables you want to create - and then a sequential number. The letters are abbreviations for the respective tables. In the suppliers table would result in it really is a L.
Database functions in Excel
The database functions in Excel
In Excel, you can query as complex SQL-like, for example, in Access create, but also the spreadsheet has some database functions.
- To access the database functions, click on the tab "formulas".
- In the ribbon, select the button "insert function".
- Under the "insert function" you will find in the Pull-down menu of "select a category", select "database".
- The in Excel available database functions are then displayed under "select a function".
- Click on the individual functions, you will receive an explanation of what the database feature can use.
Alternatively, you can also access OpenOffice or LibreOffice draw. The free Office packages offer by default a very good database.
