SQL's Explained

SQL is an acronym for Structured Query Language; it is used to ask questions of a database. Without going into detail it is a tool that allows PACE users (with the help of a programmer that has knowledge of the PACE database) to get custom reports from their PACE data files. Virtually any information that you see in your system can be manipulated into a report or extracted and put into other spreadsheets, wordprocessors or databases.

PACE comes with many reports right out-of-the-box, however there are always some business owners that would like to view certain data reports formatted their way. This is what SQL will do for anyone (management and marketing personnel, administrators, bookkeepers/accountants, service writers, etc.) that use the system.

Just to emphasize the previous point - almost any report you can dream up can be built!

To see if you have any reports already in your system press "[Shift][F4]"