# CTE Resource Center - Verso - Computer Information Systems Task 1706535597

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Sort, index, and filter databases.

Definition

Sorting is accomplished by applying an ordering system to data and should require determining the sorting option that is most helpful to the user. Sorting options include

  • ascending order (i.e., A–Z; 1, 2, 3, ...)
  • descending order (i.e., Z–A; 9, 8, 7, ...).

Indexing is accomplished by applying an order to the sorting of multiple fields and should require determining the order of sorting that is most helpful to the user. For example, in an alphabetized table of a personnel directory database, it may be more helpful to sort the Last Name field first, the First Name field second, and the Department field third.

Filtering is accomplished by restricting data-sheet or form records to only those that satisfy some necessary criterion. For example, a City database field may contain many different cities, but filtering will permit specific cities' records to be quickly and collectively viewed.

Other Related Standards

FBLA Competitive Events and Activities Areas

Business Procedures

 

Computer Applications

 

Database Design & Applications

 

Desktop Publishing

 

Microsoft Office Specialist Excel and Word

 

Spreadsheet Applications

 

Word Processing