User's Manual

BrailleNote Apex QT User Guide
18-417
18.3.2.1 String.
A string is a sequence of characters. For example, you can enter a string to retain important phone
numbers; months of the year or the symbol representing a currency. A string can be presented in
text or any grade of Braille and is sorted alphabetically.
The maximum length of a string is 255 characters. For longer entries or multiple line entries, use a
document field type.
Note: When you include characters and numbers in a sequence, they are treated as words. To store
the sequence with the numbers in numerical order, put a 0 in front of numbers 1-9. For example, the
My Books database includes a field to store series numbers, and this procedure would ensure that
the titles appeared in order of their series number.
18.3.2.2 Number.
This Field Type applies to any sort of number, but can only contain digits, the negative sign and a
decimal point. The number field type is therefore unsuitable for storing phone numbers as they may
contain spaces, brackets, and so on.
Suitable numbers to have in your database, include quantities, ages, and event years. Numbers can
also represent measurements, such as temperature, and quantities (dollars and cents, for instance).
Numbers are sorted numerically.
18.3.2.3 Yes or No.
The Yes or No Field Type provides two options to choose from; yes or no. This is useful when you
want to include a question requiring a yes or no answer in your database, for instance, "Was there a
prescription issued?".
18.3.2.4 Document.
The maximum length of data allowed in a string field type is equivalent to 255 characters. If you
think the data you want to add to a field will be beyond this limit, use a document field type. For
example, in the case of a Medical History database, you could add a document that outlines details
of your treatment schedule or lists the ingredients in your medication.
An advantage of using the document field type over a string field type is that a document is two
dimensional. That is, you are able to read and edit it as you would with a document in KeyWord.