FMX Home
Fiscal Management Training

FMQuery – Ad Hoc Web-based Training

The FMQuery – Ad Hoc Web-based training is intended for authorized state agency staff wanting to use the Comptroller’s FMQuery business intelligence tool that uses data from the statewide financial and payroll systems to build reports and queries.

Information in FMQuery currently includes system data from these sources:

  • FMQuery – Payroll: Comptroller’s office–processed state payrolls out of the Uniform Statewide Payroll/Personnel System (USPS) and Standardized Payroll/Personnel Reporting System (SPRS).

    You must complete this online training before attending the FMQuery – Payroll classroom training.
  • FMQuery – SIRS: Certain financial information from the Uniform Statewide Accounting System (USAS) and personnel information from USPS .

Note: This training is most effective if you have access to FMQuery’s query and reporting functions that allow you to practice concepts as you read through the training.

The lessons of this training include:

  1. Introduction
  2. Basic Navigation
  3. Setting Preferences
  4. Creating Web Intelligence Documents
  5. Working with Queries
  6. Working with Reports
  7. Working with Formulas
  8. Working with Templates and Charts
  9. Advanced Report Formatting Options
  10. Exporting and Saving Reports

Course Exam

Upon successful completion of the end-of-course exam, you receive 2.0 hours of continuing professional education (CPE) credit.

warning iconFiscal Management Training Center

Before beginning the course, it's a good idea to make sure you can log on to Training Center new window — that's where you'll be taking the end-of-course exam.

If you haven't set up a Training Center account, new window you should do so now.

Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy
PDFs require Adobe Acrobat Reader