Ability Database is a powerful data management system that is perfect for storing and analysing structured data or information, including address books, inventories, customer and product lists, medical records, and any other data that can be usefully tabulated.
Each Ability Database essentially consists of these elements:
basic data Tables, which are designed using a variety of Field types, including Numerical, Date/Time, Character, and many others
the data entered by the user into the Records that make up a table
a way of viewing a table, either as a Grid, a Form , or a Report
special tables called Relations, which are constructed from other tables that have one or more fields in common
actions that can be performed on tables, known as Queries: sorting records into various orders by using a Sort Order, selecting records of particular interest with a Filter, rearranging, hiding or showing fields (columns) using a Columns View
queries can be named and saved and used whenever you need them
construction of complex queries from combinations of sort orders, filters and column views
Using Database Manager, Database’s central command area, you can create and display all of your database objects – tables, forms, reports, relations, filters, sort orders, column views, queries – in one convenient tree structure. This is similar to the structure of Windows Explorer and can be expanded or contracted by clicking on the appropriate + or – .
|
