QuickBooks reports in Access with QQube | CLEARIFY

QQube and Microsoft® Access

QQube is designed to work with Microsoft Access, using the linked tables feature, and allows people who are familiar with the report creation interface of Access to develop reports and analytical queries. 

• The schema for each data model is already connected, as there is only one way to relate the tables
• Each analytic shell contains example queries

Requirements

QQube 7.x supports Access Versions 2013 and later. The report examples and pre-built subject shells are saved in 2013 format. 64 Bit is also supported out of the box.

Microsoft Access has a limitation of 256 columns, and QQube provides special data models for cases where a QQube analytic has more than 256 columns by design (certain financial summary reports). and we provide a special section on this design limitation.

In This Section

• Using Access with QQube
• How QQube deals with 256 column limitations