How to Search a DataBase using MaxiPlan:

If you haven't already read: SETUP_A_DATABASE please do now.

Searching:

1.	Select one of your defined data ranges.  Click on a
	single cell and select SET DATA RANGE from the DATA menu.
	A selector will appear with the names of all the available
	data ranges.  Click on the name and then click on OK (or
	double click on the name) to select the database on which
	you want to operate.

2.	To search a database you must define the criteria for the
	search.  In MaxiPlan, you do this by building and then
	setting a "Criteria Range".  A Criteria Range consists of
	a section of the worksheet, OUTSIDE of the database range
	which contains at the top one or more of the category
	names from the database and underneath the category names
	the criteria on which to match.  If the category contains
	text information you can use wildcard matching characters
	as shown in the MaxiPlan manual.  If the category contains
	numerical information you must supply a partial formula
	for determining a match.  Then criteria below matches each
	record in which the Name category begins with the letter
	capital L and the Age category is greater than or equal to
	30: 
		DataBase:				   Criteria Range:

		Name		Age				Name		Age
		Lehman		33				L*			=>=30
		Saunders	28
		Smith		17


	Note that you are required to prefix the partial comparison
	expression in the criteria range with an equal sign indicating
	to MaxiPlan that this is a formula (sort-of).  If you wanted
	to match on exactly 27 as the age you would need to enter
	==30 in the cell under the Age heading in the Criteria Range.

	Once you have selected your data range then select, using the
	mouse, the criteria range and choose SET CRITERIA RANGE from
	the Data menu.  Again, as in setting the data base name, you
	must choose a name which is not the same as a cell reference.

3.	Now you are ready to search (Find) or copy (Extract) information
	from your database.

4.	To search choose FIND from the Data menu.  Each matching record
	will be highlighted.  To stop at any given record click on the
	<x> button or press the Esc key.  You move the cursor forward
	and backward using the cursor keys on the keyboard.

5.	To copy choose EXTRACT/ALL or EXTRACT/UNIQUE from the Data menu.
	BEFORE YOU SELECT THE MENU ITEM, SELECT THE LOCATION FOR THE
	NEW DATA BY POSITIONING THE CELL SELECTOR BAR OVER THE UPPER
	LEFT HAND CORNER OF THE OUTPUT RANGE.  Extract/All copies all
	matching records from the database.  Extract/Unique insures
	you that only one copy of any duplicate records will exist
	in the output range.




PLEASE SEE THE EXAMPLE FILE: DB_DEMO IN THE WORKSHEETS DRAWER.