Quick Aim - Contents

Feature Description
Modules Covered We currently offer 3 Quick Aim Manuals. The manuals and their included modules are:
  • Core Applications - AB, AP, CN, GL, IA, PR, TX
  • Construction Applications - AR, BL, CN, EQ, JC, PJ, RT
  • Property Management Application - PM
Custom Descriptions There are many fields in Sage Timberline Office that can be customized. Customization can consist of changing the name of a field, its size, whether it is left or right justified, or whether it should force the use of upper-case text. The Custom Descriptions section of Quick Aim is provided so that specific customizations for your company's database may be documented.
Data Files This section provides information about the hierarchy of the Sage Timberline Office database. This includes a description of how data is stored in files, records and fields within a database. In addition, information about the data folder structure used with the Pervasive database can be found here. Information is also provided that describes each file type. This includes the possible file names and types of records that are contained in each file type. Additional information about each record identifies whether records can be created via ODBC, have notes fields, associated issue records and associated custom fields.
Record Relationships This section provides graphical diagrams that depict the relationships between different types of records in the Sage Timberline Office database. While this section does not document all possible relationships, it does document the relationships that are commonly used.
Based on feedback from users of Quick Aim, this is one of the most popular sections of the book.
Functions Functions that can be used within formulas for Event 1 Office Connector, SQL statements, and Sage Timberline Office reporting are documented here in a concise quick reference including syntax and examples.
Import Files Many of the Sage Timberline Office applications provide the ability to import data from external sources. This section documents each type of import that is possible. This includes information about the file format, type, name, optional characteristics and layout. Examples are also provided.
ODBC The Sage Timberline Office ODBC Driver is a component that can be licensed in conjunction with other Sage Timberline Office applications. The purpose of the Sage Timberline Office ODBC driver is to provide a standard method for accessing Sage Timberline Office data using non-Sage Timberline Office software applications such Event 1 Software's popular Excel-based reporting known as Office Connector. Other products that utilize ODBC include Microsoft Excel®, Microsoft Access®, and Crystal Reports®. The purpose of this section is to provide an introduction to the concepts of ODBC as well as to provide some basic guidelines for its use. Step-by-step instructions are provided for using ODBC with Microsoft Excel, Microsoft Word and Microsoft Access.
Data Dictionary This section documents each of the available fields for each record type in the applications covered. Although much of this information can be obtained via the Sage Timberline Office Report Designer, many users have found that it is better to have it already printed so that it can be used as a desk references. The formatting used in Quick Aim makes this information easy to read.