NCDesk
Global | Editor/Word Processor | Database | Spreadsheet | Window Manager | Mail | Multimedia
| Database Features Functions Limitations | Fall 2004 | Spring 2005 | Summer 2005 | Fall 2005 | Spring 2006 | Summer 2006 | Fall 2006 |
| Size limited to a maximum of 31 records and 15 fields. | Yes | Non-test limit increased to 500 x 500 | |||||
| Creates a new database file (table) by showing a form that asks the user to input field(s) name(s) and data types. | Yes⇒ | ||||||
| Data types supported are numbers, dates, strings, and booleans. | Yes ⇒ | ||||||
| Open database files (*.ncdt) or tab-delimited files (*.tab). | Yes ⇒ | ||||||
| Close the current file. | Yes ⇒ | ||||||
| Save the current file to as a ncdt file. | Yes ⇒ | ||||||
| Save the current file as a ncdt file to a filename specified by the user. | Yes ⇒ | ||||||
| Exit the database. | Yes ⇒ | ||||||
| Cut selected cell(s). | Yes ⇒ | ||||||
| Copy selected cell(s). | Yes ⇒ | ||||||
| Paste an entire record or entire column. | Yes ⇒ | ||||||
| Select all cells. | Yes ⇒ | ||||||
| Delete selected cell(s). | Yes ⇒ | ||||||
| Insert a record. New records are added to the bottom of the table. | Yes ⇒ | ||||||
| Insert a field. New fields are added to the right of the table. | Yes ⇒ | ||||||
| Remove the currently selected field(s) within the selection range. NOTE: The selection range must include whole columns. |
Yes ⇒ | ||||||
| Remove the currently selected records(s) within the selection range. NOTE: Whole records must be selected. |
Yes ⇒ | ||||||
| Sort: | Yes ⇒ | ||||||
| Ascending: if one column is selected, it is sorted ascending. If more than one column is selected, an error message is displayed. | Yes ⇒ | ||||||
| Descending: if one column is selected, it is sorted descending. If more than one column is selected, an error message is displayed. | Yes ⇒ | ||||||
| Filter: A filter dialog is provided where the user can search for specific items in a database certain specified criteria, consisting of a maximum of three filtering criteria connected with ANDs or ORs. When specifying a filtering criterion, the user first selects a database field (column name) in a drop down list, selects an operation (choices shown below) in another drop down list, then types in a value (date, string, or number) in a text field that applies the selected operation on the databases, whenever applicable. | Yes ⇒ | ||||||
| Numeric data type (the following operations can apply to this data type): | |||||||
| < (less than) | Yes ⇒ | ||||||
| > (greater than) | Yes ⇒ | ||||||
| = (equal) | Yes ⇒ | ||||||
| <> (not equal) | Yes ⇒ | ||||||
| <= (less than or equal) | Yes ⇒ | ||||||
| >= (greater than or equal) | Yes ⇒ | ||||||
| is empty | Yes ⇒ | ||||||
| is not empty | Yes ⇒ | ||||||
| String (text) data type (the following operations can apply to this data type): | |||||||
| equal to | Yes ⇒ | ||||||
| not equal to | Yes ⇒ | ||||||
| contains | Yes ⇒ | ||||||
| does not contain | Yes ⇒ | ||||||
| begins with | Yes ⇒ | ||||||
| does not begin with | Yes ⇒ | ||||||
| ends with | Yes ⇒ | ||||||
| does not end with | Yes ⇒ | ||||||
| is empty | Yes ⇒ | ||||||
| is not empty | Yes ⇒ | ||||||
| Date data type (the following operations can apply to this data type): | |||||||
| equals to | |||||||
| not equals to | Yes ⇒ | ||||||
| is before | Yes ⇒ | ||||||
| is before or equal to | Yes ⇒ | ||||||
| is after | Yes ⇒ | ||||||
| is after or equal to | Yes ⇒ | ||||||
| is empty | Yes ⇒ | ||||||
| is not empty | Yes ⇒ | ||||||
| Boolean (yes/no) data type (the default value for this data type is False; the following operations can apply to this data type): | |||||||
| is True | Yes ⇒ | ||||||
| is False | Yes ⇒ | ||||||
| Zoom document view | TBD ⇒ | ||||||
| JAWS Integration | TBD ⇒ | ||||||
| Report Generator | TBD ⇒ | ||||||
This file was modified on Wednesday, August 29, 2007; at 1:36:39 PM