HOME      PRODUCTS      DATA RECORDS      ARCHITECT      PRINT SHOP      DATA XCHANGE      ADMINISTRATOR      PRICING      ORDER      DOWNLOADS


aim Architect - Screen Shot Gallery   

 

User Interface Themes

Data Entry Forms Management

Export / Import Data Entry Forms

Query Manager - SQL Workshop

 

    User Interface Themes ...

 

The User Interface Themes Workshop gives you a centralized workspace to:

  • Create an unlimited number of Themes.

  • Define data field captions to meet your preferences or language requirements.

  • Show / Hide data entry fields and captions on a per Theme basis.  As an example, in a Sheep Theme, you may have a Scrapie ID field ... but when you select the Cattle Theme, you do not want the Scrapie ID field to be visible ... because it does not apply.

  • Add separators to group logical data entry fields and achieve the desired appearance.

  • Preview the runtime layout ... how the information editors and record lists  will appear when the Theme is active.

aim is the ONLY animal records management software that gives you the flexibility to tailor the user interface!

 

 

 

 

    Data Entry Forms Management ...

 

 

Creating new data entry forms is easy.  Use the Forms Manager to create user-defined data entry forms that meet your specific data entry requirements.

 

Define the form type and give it a description.  Then, add data entry fields to the Form.  Form types are:

  • Standalone - forms that are not directly linked to animal inventory or contact  ( address book )  items ... such as Equipment Lists, etc.

  • Linked to Contacts - forms used to record information directly linked to people and businesses in your address book ... such as Staff weekly work hours forms, etc.

  • Linked to Inventory Items - forms used to record information directly linked to your animal inventory items ... such as meat and fleece production metrics, etc.

 

 

Add New Data Entry Fields.  Adding data entry fields to a form is easy.  Simply enter the information that defines the data entry field type and appearance.

Data entry fields can be added to existing forms, or created when you create a new form.

 

 

Modify Existing Data Entry Fields.  To modify the properties of an existing data entry field, simply select the desired field in the list and change the properties.

Notice that this screenshot shows a calculated field and the user-defined formula to perform the calculation.

Calculation field expressions  ( formulas )  can contain:

  • Existing data entry fields.

  • Numeric Functions.

  • Other calculated fields.

 

 

 

    Export / Import Data Entry Forms ...

 

Exporting a data entry form takes two ( 2 ) mouse clicks.

 

When the export process has completed, the form, all data fields on the form, and the SQL for the data table will be placed into the Architect Shared Forms folder.

 

Simply send the exported form to another aim user, where they can import the form and either use the form as is, or make changes to the form to meet their requirements.

 

Forms can be exported based on the desired Theme.

 

NOTE:  Exporting and Importing data entry forms provides a simple, yet significantly powerful, mechanism to share data entry forms between users with similar requirements ... with a direct and positive impact to organizations such as 4-H and USPC where uniform record keeping is a goal and objective in each organization.

 

 

Importing a data entry form takes two ( 2 ) mouse clicks.

 

When selecting a data entry form for Import, the field characteristics and associated SQL to create the underlying data table is viewable in the lower half of the screen.

 

When the import process has completed, the new form will have a data table to contain its records and the form name will be added to the aim Records menu system.

 

To use the imported form, simply click on the aim Records menu item and the form will display ... ready for you to begin entering records.

 

 

 

    Query Manager - SQL Workshop ...

 

The SQL Workshop is an ANSI SQL Standard compliant data mining tool to perform simple-to-complex queries.

In addition to simple queries, like the one in the example, you can perform full text searches to find data that you know exists somewhere in the database, such as ...

        SELECT  *  FROM  aimCalendar 

        WHERE  CONTAINS ( Memo, 'DHLPP' )

 

The above SQL statement will perform a full text search on all Memo fields in the Calendar data table, looking for any records that contain the phrase DHLPP.

As you can see ... the full range of SQL can be applied to the database to enrich your data collection and data mining activities.

 

SQL Scripts can be easily saved for reuse.

 

 


copyright by the caplen company, all rights reserved