home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
World of Shareware - Software Farm 2
/
wosw_2.zip
/
wosw_2
/
DATABASE
/
STAFF3.ZIP
/
STAFFHF0.STF
< prev
next >
Wrap
Text File
|
1991-07-27
|
11KB
|
274 lines
STAFF - QUICK REFERENCE
=======================
The database management actions which can be performed with STAFF
are listed in alphabetical order. All the necessary shortcut
commands are shown considering that the user is starting with the
initial unopened menu bar. Comments are in square brackets - [] ,
Function Keys are in angled brackets - <>.
- Adding new Fields: U,R,M, <Ctrl+PgDn>, down arrow-key
- Adding new Records: I,I, <Ctrl+PgDn>, down arrow-key
- Arithmetic operations: I,C, [Select the desired field], <CR>,
[Select the operation to perform], <CR>, [Enter the selection
criteria], <End>
- Calculator: <F6>
- Calender: <F4>
- Calling dBLOOKUP from a data table: [Move the cursor to a field
whose name is followed with an *], <F2>
- Changing lower case to upper at cell level: I,I, <Alt+U>
- Changing upper case to lower at cell level: I,I, <Alt+L>
- Changing lower case to initial capitals at cell level: I,I, <Alt+P>
- Changing lower case to upper for field in all records: I,I, <Alt+R>,
*, <CR>, <CR>, U
- Changing upper case to lower for field in all records: I,I, <Alt+R>,
*, <CR>, <CR>, L
- Changing lower case to initial capitals for field in all records:
I,I, <Alt+R>, *, <CR>, <CR>, P
- Changing the Active DB: N [Select directory], <CR>, [Select the
DB], <CR>
- Changing the DB structure: U,R,M...
- Changing the system colors: U,E,C...
- Copy a block of fields: I,I, [Go to the first block definition
field], <Alt+K>, [Go to the second block definition field],
<Alt+K>, [Go to the left upper definition field of the target area]
<Alt+K]
- Copying Field (once): I,I, [Go to the source Field], <Ctrl+F2>,
[Go to the destination field], <Ctrl+F2>, [Edit when necessary], <CR>
- Copying Field (several times): I,I, [Go to the source Field],
<Ctrl+K>, [Go to the first block definition field], <Ctrl+K>,
[Go to the second block definition field], <Ctrl+K>
- Copy a records at the and of file: I,I, [Go to the desired record],
<Alt+F2>
- Copying the DB structure: U,C,C, [File name], <CR>
- Counting the matching records: O,V, [Select Filter or Query],
[Enter the selection criteria]...
- Creating a DB file: U,C,G, [File name], <CR>, [Fill the
related fields], <CR>
- Creating external Files: [Move the Cursor to the desired field],
[Type %\path\FILENAME.EXT], [Start entering Data], <Ctrl+W>
- Creating a Macro: U,M,C, [Macro name], <CR>, Y, [Type the
command to be incorporated into the Macro], <F10>
- Creating and printing standard labels: O,L,S, [Select the
fields to be printed with the arrow keys and <CR>], [Select:
Printer, File or Screen], <CR>
- Creating custom designed labels: O,L,C [Input the parameters
or use the defaults], [Select the fields]
- Creating Indexes for the selected DB: U,R,I,N, [Select the
index field], <CR>....<End>
- dBLOOKUP Calling from a data table: [Move the cursor to a field
whose name is followed with an *], <F2>
- Defining a dBLOOKUP relation: U,R,M, [Go to field], <End>,
[Type Y in the dBLOOKUP column], <F10>, [When prompted, type
the file name or an * to select from a list], <CR> ...
- Delete a DBF file: N, [Select the directory], <CR>, [Select the
File], <Del>, Y
- Dialing a Phone #: [Move cursor to a cell with a valid
Phone #], D - This works only from the Fast Find, and Output View
Data Tables.
- DOS Shell: <F9>; Return from DOS to STAFF: EXIT
- Editing a field: I,I, [Go to the desired field], <CR>...
- Editing a secondary DBF: I,I, [Go to the related column], <F2>,
<F3>...
- Erasing a Macro: U,M,C, [Macro name], Y
- Erasing a Memo field: I,I, [Go to the desired Memo field], <Alt+Z>
- Erasing a record: I,I, [Go to the desired record], <Del>
- Erasing the contents of a DB file: U,H,Z,Y
- Erasing the marked records: O,V, [Select records], [Mark the desired
records], <F10>, [File name], <CR>, Y
- Exchanging the content of two fields: U,H,S, [Select the 2 fields
to be swapped], <CR>
- Execute a DOS Command: <F9>, [Execute the desired DOS Command],
[Type EXIT to get back to the Program]
- Executing a Macro: U,M,R; From the Main Menu: <Alt+M>, [Select the
desired macro], <CR>, <Y>...
- Exporting a Memo field: I,I, [Go to the desired Memo field],
<Alt+X>, [File name], <CR>
- Exporting the marked records: O,V, [Enter the view criteria],
[Enter the Sort Order], <End>, [Mark the desired records (<Tab>
or <Shift+Tab> for all)], <F10>, [File name], <CR>, N
- Exporting to a Comma Separated file: O,D,C, [Enter the selection
criteria], <End>, [Enter the Sort order], <End>, [File name],
<CR>
- Exporting to a Delimited with ... file: O,D,D, the rest is as the
"Exporting to a Comma Separated file"
- Exporting to a WordPerfect Merge file: O,D,W, the rest is as the
"Exporting to a Comma Separated file"
- Exporting to a WordStar MailMerge file: O,D,M, the rest is as the
"Exporting to a Comma Separated file"
- Exporting to an ASCII file: O,D,A, the rest is as the
"Exporting to a Comma Separated file"
- Exporting to other DB file: O,T, [File name or *, <CR>], [Select:
Append, Zap, Change name, Overwrite], [Select the fields], <F10>
- Fast Find information: F, [Select the Field, or Combination of
Fields], <CR>, [Enter the desired String], <CR>
- Filtering specific records: O,V,F, [Enter filter Criteria], <End>,
[Enter Sort Order], <End>
- Finding duplicate entries: U,H,D, [Select the field to check],
[Enter the amount of characters to scan], <CR>
- Getting HELP: <Alt+F1>; <F1>
- Getting statistics and Optimizing the size of the active DB: U,D,Y
- Getting statistics for numeric fields: O,V, [Enter the selection
criteria], <End>, [Move the cursor to the numeric column], <Alt+F5>
- Going to a specific record: I,I, <Alt+G>, [Type the record number
to go to], <CR>
- Hiding columns in a table: I,I, [Move to the column to hide], <Alt+H>
- Importing from a WordStar MailMerge file: U,I,M, [Enter the path/
CR for the current], [Select the file with the cursor], <CR>
- Importing from an ASCII file: U,I,A, [Enter the path],
[Select the file with the cursor], <CR>
- Importing from other DBF: U,I,O, [Enter the Path], [Select the file],
<CR>, [Select the fields], [Enter the selection criteria], <End>
- Importing to a Memo file: I,I, [Go to the desired Memo field],
<Alt+T>, [File name], <CR>
- Indexing: U,R,I,N, [Select index field], <CR>...<End>
- Leaving STAFF: <F10>; <Esc>, <Ctrl+F10> to exit from deeper
menu levels
- Link to an external file: I,I, [Go to the desired field], [Type
%\PATH\FILENAME], <CR>
- Marking all the records: O,V, [Enter the selection criteria],
[Enter the Sort Order], <End>, <Shift+Tab>
- Marking records: O,V, [Enter the selection criteria],
<End>, [Go to the desired record], <Tab> ..., <F10>, [Type the
file name where you want the marked records to be copied], <CR>, N
- Merging fields: U,H,M, [Select the destination field], [Select
up to 5 source fields], <CR>
- Opening a new DB file: N, [Select the DB file with arrow keys,
or with starting letter], <CR>
- Open a dBASE file with a non DBF extension: Start the program
from the DOS Prompt with STAFF FILENAME.EXT
- Partial string searching: From any table, [Move the cursor to the
desired column], <Alt+F>, [Enter the text to search for], <CR>; to
continue the search process: <Alt+N>
- Printing Labels: O,L,P, [Select the desired format], <CR>
- Printing standard outputs: O,P,S, [Enter the selection criteria],
<End>, [Enter the sort order], <End>, [Select Printer or File to
send the Output], [Enter File Name, if output to File have been
chosen], <CR>
- Query for specific Records: O,V,Q,C, [Enter specific Query], <F10>,
Y, [Enter Name for Query], <CR>, [Enter description of Query],
[Enter Sort Order], <End>
- Removing a field from the DB structure: U,R,M, [Move to the desired
field], <Del>, <F10>, Y
- Removing definitively all the deleted records: U,H,P
- Searching and replacing a string: I,I, [Move to the desired column],
<Alt+R>, [Type the text to search for], <CR>, [Type the text to
replace with], <CR>
- Selecting a printer: U,E,P, [Select the printer with the arrow keys],
<CR>
- Selecting the Date format: U,E,F, [Select the Date format], <CR>
- Sorting a DB file: O,V, [Enter the selection criteria], <End>,
[Enter the sort order], <End>
- Sorting and exporting a DB file: O,V, [Enter the selection criteria],
<End>, [Enter the sort order], <End>, <F10>, [File name], <CR>
- Specifying the defaults: U,E,D, [Type the Path, File name, and
Auto backup options]
- Statistics of numerical fields: O,V, [Enter the selection (filter
or query) criteria], <End>, [Enter the Sort Order], <End>, [Go to
the numeric Field for which Statistics are desired], <Alt+F5>
- Swapping to fields: U,H,S, [Select the 2 fields to be swapped],
<CR>
- Un-erasing a record: I,I, [Go to a deleted record], <Del> - This
only works prior to a Pack
- Using Fast Find and editing the record contents: F, [Select the
desired Fast Find option], <CR>, [Enter the text to search for],
<CR>, [Select the desired record], <Alt+E>, [Start editing the
information]
- Using Fast Find: F, [Select the desired Option], [Type the text
to search for], <CR>
- Viewing and editing an external File: I,I, [Go to
the desired field (it must begin with a % sign, followed by
the FileName)], <Alt+V>, [Start editing the content of the File],
<CR>
- Viewing selected records: O,V, [Enter the selection (filter or
query) criteria], <End>, [Enter the Sort Order], <End>