PowerDB provides a powerful editor to create or customize test forms.

  • Drag-and-drop controls such as tables, text boxes, images, charts, and more into a form.
  • No database knowledge is required.
  • VBScript® can be used to define calculations, use lookup tables, and even interface with other applications.
  • Tab order for a form can easily be defined or modified.
  • Sections common to multiple forms, such as logos, headers and footers, can be defined once and included in many forms. One change updates all forms where it is used.
  • Procedural and context-sensitive help screens can be defined to assist testers.

If you need assistance in learning the basics of form design, contact PowerDB Support for answers to your questions or to hear about our training options. 

PowerDB provides a first-class presentation on screen and on paper.

  • Test data can be reviewed on-screen. Like the data entry, this data is presented in layout identical to the printed forms.
  • Equipment and test results are organized in a "tree" format familiar to Microsoft® Windows users. Equipment is organized in the tree in a real-world hierarchy (user, plant, substation, position). Historical test results are listed below each piece of equipment.
  • All test forms for a job can be sorted and printed in one step. Sorting automatically organizes forms by substation or device type, and position or test date. The print order of forms can then be individually adjusted, if desired.
  • Comment and Deficiency Summary Reports provide quick access to information collected across all equipment tested as part of a job.

 PowerDB provides data entry screens identical in layout to the printed forms.

  • Form layout and data entry order were determined by field personnel, following a logical order, streamlining testing and minimizing data entry time.
  • Nameplate and settings are pre-populated from previous testing or similar devices.
  • Address and common job information is automatically populated for each form added to the job.
  • Extensive equation processing, data lookup and charting are done automatically.

 

PowerDB provides data management and organization for all of your maintenance and testing results.

  • Customer and contract information is organized in a Job List. This list can be quickly sorted and searched.
  • Opening a specific record in the Job List shows detailed information about the job, such as type of service, order date, sales contact, and invoice information.
  • Job information and related test results can be transferred between field-use databases and a master database.
  • Inactive jobs can be archived and hidden from normal view.
  • Job and Device Productivity Reports track the time spent testing, which aids in bidding future jobs as well as personnel evaluation.

PowerDB Pro is typically provided with relational databases that are designed using the Microsoft Access format. This allows great flexibility when used on laptop PC’s that need to operate in remote, stand-alone situations.

MS Access databases are an industry standard, having been used extensively in applications of all types for many years. PowerDB has used this type of database with great success, and users of PowerDB have utilized the standard database for collecting many years worth of test data and maintenance records.

The Access format does have some limitations, though, which are well known by software and IT personnel. This includes a functional limit in the size that the database can grow to. Access databases can also become corrupted for various reasons and can require TLC in regard to regular maintenance, including table validation and compacting.

PowerDB is also compatible with SQL Server. SQL Server is a relational database type that is a higher-end client/server database. SQL databases are not subject to the same size limitations as Access databases, and can provide greater stability.

Upgrading PowerDB to SQL Server requires a user to already have SQL licenses and software on their network servers. Please contact PowerDB support for more information.

More Articles...