Features |
|
Descriptions |
| |
|
|
Application Database Modification |
|
- Easily add tables, fields, sorts, relations, tabs, buttons, and update screens to the application.
- Automatically update the database to reflect changes.
- Change field lengths without worries of data loss or the using of complicated data conversion procedures.
- Relate data within the original application to data in add-on modules .
|
| Context Sensitive Help |
|
- Usage is explained with a right click on any field or button.
- Those with access rights can edit the help.
|
| Copy/Merge |
|
- Generic copy feature reduces repetitive data entry.
- Able to copy a record and its related records.
- Flag each field in the table and related tables to either copy or not.
- Merge will automatically check for duplicates and merge related data. For example, merging two accounts into one.
|
| Custom Interfaces |
|
- Function buttons are added through data dictionary and the program name is attached.
- Custom interface program can be written and attached within the applications.
- Future upgrade need not affect the customization.
|
| Date Field |
|
- All date fields have a calendar feature associated and it is displayed in full screen mode in Windows format.e.g. 28, June 2001
- The newest version can also include a time.
|
| Default |
|
- Any field can be assigned a default value when a new record is created. Defaults can be specified to be the previous entry, which reduces data entry time.
|
| Grid Displays |
|
- Grids are visible by default.Grids support calculated fields.
- Grids support lookup data from other tables.
- Grids can be filtered for reports.
- Users control which columns to display.
- Column widths can be permanently resized to match your data requirements.
Back to Top
|
| Images |
|
- Image capability can be attached to any table.
- User can resize screen displays.
- Direct scan capability from screen to database.
- Unlimited images can be linked to one or more equipment.
- Screens, links, displaying, and paging are easy and fast.
- Users can resize and position screen image displays.
- Images can be edited externally with programs such as Paintbrush.
- Images can be inserted into reports.
|
| AutoCad, Word links |
|
- Multiple links per record.
- More than 190 document types supported.
- Red-line overlay support. Zooming, printing.
- Special user count required.
|
| Projects |
|
- Project can have many phases.
- Each phase has a budget amount.
- Track costs from purchase orders and demand work orders.
- Budget to actual comparison.
|
| Key Edit |
|
- Able to change record keys (e.g. account codes or personal ID's) and have the system update all related records thus maintaining data integrity.
- Having to rename a major item is no longer a problem.
Back to Top
|
| Open Architecture |
|
- User interface is data driven.
- Able to customize screens and add or customize reports, add special function buttons, add sorts, add user tables, resize grid columns, add and re-order grid columns.
- Extend the power of the application in any direction without the need to access source code.
- The application can utilize data from multiple databases.
|
Record Locking (Multi-user)
|
|
- Record locking is set to "optimistic" by default.
|
| Relational Deletes |
|
- User-defined relations determine which associated attachments should be deleted when a record is deleted.
- Relation can be set for "delete" or "protect delete" so user must first delete related records manually before deleting the main record.
|
| Grid Reports |
|
- Reports are replica of grid displays on screen.
- Instant reports (no setup required).
- Filters are supported.
- Professional appearance.
- Columns, headers, and page numbers are displayed.
- Add, delete and resize columns on-line.
- Fields can be added to report (temporary or permanent).
- Export capability.
- Conversion to column report option.
Back to Top
|
| Column Reports |
|
- Professional appearance.
- View before sending to printer.
- Add, delete and adjust columns on-line.
- Save report specifications.
- Automatic date/time stamping and page numbering.
- Prints memos in rich text format (RTF).
- Stack memos under titles.
- Powerful filtering and record selection criteria on-line.
- No need to recompile when report is altered.
- No need to run an external report generation tool.
- Column headers can be stacked and edited.
- Numeric data uses display criteria stored in the user accessible (on-line) data dictionary.
- Print check marks in Boolean (e.g. Yes/No) type columns.
- Reports can be copied.
- Support totals, averages, counts, min, max, and calculated fields.
- Reports can have any number of groups.
- Totals can be rolled up for summary.
- Level of detail to print specified at run-time.For example, if you specify zero levels and get only the bottom line cost.
- Automatic alignment of data and column headers.
- Export capability.
- Conversion to Layout style option.
|
| Layout Reports |
|
- Page layout under user control.
- Data dictionary driven.
- Easily customizable.
- Supports rich text.
- Easy to use graphic interface.
Back to Top
|
| Screen Painter |
|
- Arrange fields.
- Resize and align text boxes.
- Display lookup descriptions inside of text boxes.
- Edit prompts, column headers, and text input masks.
- Move edit boxes around.
- Make edit boxes mandatory.
- Hide unwanted edit boxes.
- Change tab order.
- Change width and height of memo boxes.
- Change fonts, bold, and underline inside memo boxes.
- Attach label to memo boxes.
- Move function buttons.
- Add and delete text boxes.
- Access validation rules.
- Set defaults.
- Make text boxes equal size and more.
|
| Searching/Sorting |
|
- Option of selecting alternate sorts.
- User defined sorts and grid columns.
- Multiple key searching.
- Columns on grid and pick-lists match sort selected.
- Incremental searching (the capability of narrowing your search in the database, without scrolling, with each character typed).
|
| Security |
|
- Security system is COMPLETELY customizable by the end user.
- Security level codes (Full, View, and None) can be applied on screens and function buttons.
- Users with None do not see buttons or tabs that are not required.
|
| Spell Checker |
|
- This option can be used on any field or memo.
|
| Subset Selection |
|
- Drill down can optionally display only subset records on grid.
- Fast data access for small and very large tables.
- Users can override selection by screen.
Back to Top
|
| Tabs that Remember |
|
- If reviewing a record (e.g. equipment record) and tab to another related table (e.g. equipment history), the grid will point to the correct history record.
- As you navigate related records, the application "remembers" where you came from.
|
| Text Lookup Display |
|
|
| Export |
|
- Export any report to Excel, PDF, RTF (Word), ASCII (text) formats.
|
| Filters |
|
- Every screen has a user friendly filter wizard. Example: show equipment attached to account 13490 and under warranty.
- Works great with quick reports.
|
| Update-on-the-fly |
|
- Option of editing any pick-list on the spot.
- Never go elsewhere to update a table.
- Update on the fly is security protected.
Back to Top
|