DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Prev Page
Introduction
Hotkeys
Command line options
Working with dbf files
Opening DBF files
Creating New DBF file
Modifying dbf file structure
Viewing statistics
Import/Append records
Save As/Export
Working with records
Adding records
Editing records
Deleting records
Replacing records
Filling records
Sorting records
Searching and Filtering
Searching by criteria
Filtering records
Wide Filter
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Delete duplicates
DBF File Optimization
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Top  Previous  Next

Quick Filter


DOWNLOAD
for FREE

Instantly find matching records in DBF

The Quick Filter option available in DBF Viewer 2000 allows you locating records in a database that match certain criteria, almost instantly. This provides additional convenience when you work with a huge dataset and saves a lot of time when you deal with groups of records that have similar values of one or more fields.

Imagine the following scenario. You have a database of orders where you want to quickly see all orders except orders for a given product. Then you want orders placed before a given date. Then you want to display every order received in a given department and so on. Quick Filter ideally handles such situations. The option allows you to quickly apply predefined filters to the selected field and instantly see the matching records.

Here is how Quick Filter works

quick filter

We assume you are already accustomed with that DBF Viewer 2000 interface. Open a DBF table. Right-click a certain value in the table view. This will bring up a context menu as shown above. Hover the mouse over the Quick Filter item to display the submenu.

These are quick filter options you can immediately apply to the selected field to filter out the records by this field.

From top to bottom:

  • Item 1: Show records where the value of the selected field is equal to the value of that field in the selected record;
  • Item 2: Show records where the value of the selected field is not equal to the value of that field in the selected record;
  • Items 3 to 6: Show records where the value of the selected field is more (bigger), less (smaller), more or equal, less or equal than the value of that field in the selected record;

DOWNLOAD
for FREE

Updated Fri, 02 Nov 2018

See also: DBF File format, DBF File Optimization, DBF to XLS (Excel), DBF to SQL, DBF to CSV, DBF Repair Tool, Filtering recordsSorting records in dbf file, Command line options

Back to DBF Viewer 2000 Home

Page top |  Copyright © HiBase Group, 2002-2018   gplus