Learning Resources
 

Data Operations

Data Operations

Database Management
It refers to managing of data in a database i.e. adding, removing, updating, sorting data in a database. It offers the facility to sort the database by

  • Using one sort column
  • Using two, three or more sort column


Database management also provides following options in MS-EXCEL

  • Adding a record
  • Deleting a record
  • Filter and multiple filter


Filter and multiple filter
Filtering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria specified for a column.

Automatic filter options

To

Click

Display all rows

All

Display all rows that fall within the upper or lower

limits you specify, either by item or percentage

Top 10

Apply two criteria values within the current column,

or use comparison operators other than AND (the default operator)

Custom

Display only rows that contain a blank cell in the column

Blanks

Display only rows that contain a value in the column

NonBlanks