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 data model example contains one or more queries.

Requirements

QQube 10.x supports Access Versions 2016 and later. The report examples and pre-built subject shells are saved in 2016 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