You have to use different files to store important data. However, it is crucial to point out that nothing is more helpful and reliable than excel database file when it comes to keeping track of information. Whether you need to store contact number, home addresses, names of books or complete information, excel database file is the best and easiest way. It’s built in tools help in storing data and recovering it with convenience and ease. Another benefit of using excel sheet is that it can easily hold huge amounts of data due to the presence of hundreds of columns and thousands of rows.
There are certain steps that have to be followed:
- First, is to open a blank excel work book
- On the top row, enter all the required fields to be filled
- Next, select cell 1A and then on click on DATA and then FORM from the menu bar
- Click OK and then a form is returned in which you need to enter the data
- Once you have completed the form, click NEW to enter another record
- The entered data is shown on row 2 of the sheet and a new form is returned to be filled with another record
- Repeat this process until all the data has been entered successfully
- Click on DATA and then select FORM again from the menu bar and then click on CRITERIA
- Enter your search criteria which could include symbols for numerical data like <,> or = signs
- Select FIND NEXT or FIND PREV until the required data is found
- If you want to delete any record, repeat the previous step and find the record and then select the DELETE button
- The data can be sorted in ascending or descending order: select the cell or column that needs to be sorted and then click on the button from the toolbar that sorts the data; this button is listed with the function button and has arrows pointing upwards or downwards with it
To reduce errors, make sure that the data entered is correct and that no rows or cells are left empty. Rows should include data and columns are the fields. The database can be expanded by dragging the outline of the table outwards and then finally select the heading and merge it in the centre.