Access

Access

  Pick Manual Home Article
# "not equal to" operator.
& "and" operator.
< "less than" operator.
<= "less than or equal to" operator.
= "equal to" operator.
> "greater than" operator.
>= "greater than or equal to" operator.
a Throwaway connective.
after "greater than" operator.
and "and" (Boolean) operator.
any searches entire item for match, all attributes and values.
are Throwaway connective.
b Suppresses "number of items listed" message.
before "less than" operator.
break-on Creates control break in Access reports.
by Defines (ascending) sort key in Access sentence.
by-dsnd Defines descending sort key in Access sentence.
by-exp Explodes multi-values for sorting purposes.
by-exp-dsnd Explodes multi-values in descending sequence.
c The equivalent modifier is "col-hdr-supp".
c/total used by list-obj to display number of frames
check-sum Produces check sum total.
col-hdr-supp suppresses column and page headings on Access reports.
connectives words in a master dictionary which are used to form the elements of Access statements.
converting-nulls Allows all values to be processed by the output conversion -- even nulls.
count Counts items in a file.
d Suppresses detail on Access reports.
data Throwaway connective.
dbl-spc Activates double spaced output.
default output specifications selects the default attribute-defining items in an access sentence when none are explicitly provided.
det-supp Suppresses detail on Access reports.
dict Accesses dictionary level of specified file.
each Forces comparison on every value.
eq "equal to" operator.
equal "equal to" operator.
every Forces comparison on every value, rather than any value.
file Throwaway connective.
fill Displays report in "across-the-page" mode.
footing Defines report footing.
for Throwaway connective.
ge "greater than or equal to" operator.
grand-total Substitutes text for default "***" on grand total line.
gt "greater than" operator.
h Suppresses default page heading.
hash-test Performs distribution analysis on file with test modulo.
hdr-supp suppress the header
header see "heading".
heading Defines report heading.
i Suppresses item-ids.
id-supp Suppresses item-ids.
if
ifno
in Throwaway connective.
Access a Pick facility to retrieve and output data.
is
istat Performs distribution analysis on existing file modulo.
itemlist Defines a specific list of item-ids.
items Throwaway connective.
j Suppresses "number of items listed" message.
k suppresses the legend.
le "less than or equal to" operator.
leg-supp
legend-supp Suppresses "legend" on output.
list Lists file.
list-item Displays item in storage format.
list-label Produces formatted labels.
logical connectives Boolean operators used in selection clauses.
logical operators Relational operators used in selection clauses.
lptr Directs output to printer.
lt "less than" operator.
m Allows all values to be processed by the output conversion -- even nulls.
modifiers List of Access modifiers.
modlist Defines list of modifiers.
n Outputs report without pausing at the bottom of each page.
ne "Not equal to" operator.
ni-supp Suppresses "number of items listed" message.
no Reverses selection condition.
nopage Outputs report without pausing at the bottom of each page.
not Negates selection criteria.
nselect Performs "not" select - only items not there.
of Throwaway connective.
only Displays item-ids only.
options: Standard options: b,c,d,e,h,i,j,k,n,p,r,s,u,y
or "or" (Boolean) operator.
outlist Defines list of attributes to output.
p Directs output to printer.
phrases master dictionary items which contain Access macros.
pre-processor portion of Access which provides phrase parsing and eliminates the need for quotes around explicit values.
r Displays report in "across-the-page" mode.
reformat Reformats data to file or tape.
relational operators Relational operators used in selection clauses.
retrieval scheme Description of Access' sentence parser.
roll-on creates a visual "break" in output data when the value of a specified attribute changes, an improvement over the "break-on" command.
s-dump Dumps items to tape in sorted order.
sampling Limits the number of items processed to a given number.
select Creates list of items meeting specific criteria.
selection criteria Description of Access selection criteria.
sellist Defines selection criteria portion of an Access sentence.
seqlist Definies collation sequence.
sort Sorts file.
sort-item Sorts item(s) in storage format.
sort-label Produces formatted and sorted labels.
sreformat Reformats data in sorted order to file or tape.
ss Produces "spreadsheet" summary of values by dates.
sselect Creates sorted list of items meeting specific criteria.
stat Displays total and average of numeric field.
string searching String searching.
sum Displays total of numeric field.
supp Suppresses default page heading.
t-dump Dumps items to tape.
t-load Loads data from t-dump format magnetic media.
Tabbed output
tape Produces Access report from magnetic media.
tcl-supp Suppresses TCL command on printed output.
temporary attribute items references any attribute by its numberic attribute count.
the Throwaway connective.
throwaway connectives Access no-ops.
total Summates columnar total.
total-on see "roll-on".
quotes How quotes work in Access.
user exits, Access List of Access user exits.
using Uses dictionary from different file in an Access sentence.
Access verbs General form of Access sentences.
with Defines selection criteria in Access sentence.
within Retrieves sub-list from items.
without Same as with no or with not.
y Displays Access "parsed" sentence parameters.
z Prints Access "parsed" sentence parameters.
[
]
^
collation order Definition of collation order.
options: footing Description of footing options.
options: heading Description of heading options.
list processor Access output-processing facility.
el Edits saved list using Update processor.
istat produces a graphcal representation of item-id distribution and suggests a new modulo.
l Synonym for "list".
si Invokes "sort-item" command.
u1070 Returns a checksum for the current item
u201e Returns the number of attributes in an item.
u2070 Returns the checksum value for the specified frame.
u3070 Returns PCB fid for the current process.
u5070 Converts a string in the form "xxx" to the form "xxx-000".
u508e Calls the "copy" processor from Access.
u6070 Inputs up to 100 characters.
u7070 Inputs up to 100 characters.
u8070 Returns a checksum for the current item
u9070 Toggles the Page/NoPage format.
ua070 Returns the specified value from a multi-valued set.
uc070 Returns the specified value from a multi-valued set.
wildcards allows Access to search for strings beginning with, ending with, or containing a given string.
  Pick Manual Home Article