Database

A database is a collection of one or more tables that are interrelated.

Table

A table is a collection of records stored in the same file.  Each horizontal row of a table contains a single record and each vertical column contains a single field.

Record

A record is a collection of fields related to a particular case, such as an event, part, person or transaction.

Field

A field is a column or category that holds information in your table.  For example, in a table that holds customer information, a field could hold customer names, companies or phone numbers.

Filter

A filter is a set of criteria or conditions that lets you indicate which records to include in your query results (e.g., "Only customers from California who purchased more than $100").

Query

A query is a specialized view of  information in your database.  It may contain all fields and records or a filtered subset.  The records in a query may be sorted, grouped and summarized in different ways.

Report

A report is the output of a query.  The report can be a printed document or a file written to disk such as a database table, spreadsheet or text file.

 Using the mouse:

Click on  with the primary mouse button (the left mouse button on most computer systems).

Using the keyboard:

Move to  by pressing Tab or the cursor arrow keys until a darkened border appears around the button.  Then press the Enter key.

The Query List Manager is OT2 Query Maker’s “control panel.” It is a screen showing titles of previously saved queries. These queries may have been created by you, or by your colleagues, or by a programmer.

To choose an existing query to work with, highlight it with an arrow key or with the mouse.

You can then perform an action on this highlighted query by pressing one of the buttons listed horizontally across this screen's bottom. 

If using a keyboard, you can switch between the query list and the buttons with a left or right arrow key.

Selects current query to setup and run.

Creates new query.

Modifies query's filter.

Makes a copy of the current query.

Changes title of the current query.

Permanently removes the current query.

Returns you to your prior application.

Takes you to Query Overview Dialog

Takes you to  Filter Building Dialog.

Takes you to Filter Building Dialog.

Will prompt you for a new title.

Will prompt you for a new title.

Will ask you to confirm your intention

Will save any changes you have made.

This dialog lets you pick output table fields, a record sort order, group and summary fields, and what type of report to generate.

This dialog guides you through a step-by-step process of specifying a record filter. 

When done, press Select to run this new query.

A filter is the set of criteria that indicate which records are to be included in the query results.

After picking a query to copy and pressing this button, you will be asked for a new title.

To customize your new query, press Edit.

When you delete a query, any associated reports are also permanently removed.