|
To begin applying search conditions to fields, click "View select area on/off."
The "Field Selection" and "Report Filter Criteria" should appear.
We suggest keeping searches/queries simple.
FIELD SELECTION
Drop and Add Columns: This feature will allow you to view only the columns you wish to see.
To remove a column, uncheck the box in the upper left-hand corner column selection and click the
gray "Apply" button. To view the removed columns, check the box and click the
"Apply" button.
REPORT FILTER CRITERIA
Section I: Drop down menus for each field that has limited choices are provided for you.
You may select single or multiple
selection(s) across fields.
Example: Same as above but, press down "control" key and click (highlight)
multiple counties such as "Contra Costa", "San Francisco", click
"Apply" button.
Apply "Clear filter form" located at the bottom of your screen to clear selections.
It is not necessary to clear the filter before applying another condition. The system will
automatically overwrite the previous selection(s). Clearing the filter will return you to the
beginning state of the database.
Section II: In conjunction with the above selection choices, this section allows you to
perform word/text searches in the "Title", "Description" and "Total
Proposed Funds" fields.
- For example, if you are searching for counties who intend to fund child care
programs/services but you are not sure if child care has a space between child and care or is
one word, childcare. Select "Description", then select "LIKE", then type
in "child care" (with or without the space), then click "Apply". The system
will search for all records with child care and childcare in the project description field.
- Another example, you want counties that are funding domestic abuse programs. Counties may
have used the word "abuse" or "violence". Select "Description",
then select "LIKE", then type in "domestic", click "Apply". The
system will find all counties with domestic in the project description field.
- Using the "AND" and "OR" function located at the right of the space to
type in key word(s):
An "OR" is an additive comment. The database will search for all records that
contain the word/words that you are searching for. The more "OR" statements will
result in more possible records.
For example, Description like "pregnancy prevention" "OR"
Description like "reduce pregnancy"
The database will search for all records that contain in the description field
"pregnancy prevention" or "reduce pregnancy" .
An "AND" is a subtractive comment. The database will search for all records that
contain the word/words in the same record. The more "AND" statements will result in
restrictive searches.
For example, Description like "pregnancy prevention" "AND"
Description like "reduce pregnancy"
The database will search for all records that contain the words "pregnancy
prevention" and "reduce pregnancy" in the same record.
- "Total Proposed Funds" field: Type in only numbers and decimal point. Do not
type in dollar signs or commas.
For example, Total Proposed Funds "=" (equal) "1000000"
The database will search for all records that have total proposed funds of $1
million.
TO PRINT
To print the results of your selections, look at the top left-hand corner of the view screen.
Do you see "Total records = some number"? This tells you the number of total records
that met your selection criteria. A couple of lines down from this displays "# of records
per page" which is defaulted to 5. Change this number to the total number of records that
met your selection criteria. Click the "Go" button. You should now be looking at
all the records that met your criteria. Select "File", "Print" in your
browser. Please note that printing out a large amount of records, may slow down your access
to the database and the response time.
click here to enter data matrix
Please call the Employment Bureau at (916) 654-2137 if you have any questions on the operation of the database.
FURTHER CLARIFICATION REGARDING SPECIFIC PROGRAMS SHOULD BE OBTAINED FROM THE INDIVIDUAL
COUNTY.
|
