DO NOT TRY THIS AT HOME : Rotteneggs.com text files and message bases are for INFORMATIONAL PURPOSES ONLY. DO NOT undertake any project based upon any information obtained from this or any other web site.We are not responsible for, nor do we assume any liability for, damages resulting from the use of any information on this site.
(62 votes) Published: Nov 21, 2006 10:10 p.m. Viewed 153 times
Excel can be used as a simple and quick to set up database with filtering and sorting functions for records. It is a lot easier to create a database of records than using the more powerful Access and has the added advantage of being able to include mathematical formula within the records.
Data Forms
You can use a basic form to enter or edit records. To access the form select Data/Form from the menu bar.
Finding/Sorting Data
Data can be sorted in alphabetical order in ascending or descending order.
Click on the top record cell of the column you want data sorted by. Don’t select the field label, otherwise the column title will be sorted along with the records and my not remain at the top of the database.
Select Data/Sort from the menu bar.
(Note that you can apply more than one criteria from the dialogue box that appears.)
To find particular records, use the Criteria function of a data form. From the menu bar, select Data/Form, then click on the ‘Criteria’ button of the dialogue box. For effective searching you need to use Operators.
AutoFilter
Autofilter allows the display of only selected group of records in an Excel database. For example, only those customers that have bought “grabbits”.
From the menu bar, select Data/Filter/AutoFilter – the option becomes ticked.
A drop down list button appears for each field (column title).
Select the field you want to filter by clicking on the drop down list button at the top of that field.
The ‘Custom’ option in the drop down list allows you to display two criteria values within the current column, or to use comparison operators (And/Or).
The ‘Top Ten’ option in the drop down list will display the records with the ten highest values in that field.
Edit Page
Message silentclipper
Add Comment
Add to Favorites
Email to Friend
