Each QQube Subject is already configured for any version of Access 2013 or above. The underlying tables are already linked, and the relationships are already established. (In a data warehouse, there is only one way to attach the underlying tables). All you need to do is open one of the examples, and refresh the links (see the last picture on this page).
Open up the Configuration tool, and highlight "Microsoft Access" under the Examples section. You will see a list of Access examples that are installed with the QQube components. By default they are installed to "C:\Users\Public\Documents\CLEARIFY\QQube Tool\Access Examples"
The Access database will open up to a blank canvas where there is at least one query example.
FIRST. Make sure that the correct Analytic is loaded in the QQube Configuration Tool
SECOND. Check the synch logs to ensure that the Analytic Data has been extracted without errors.
THIRD. go to the Linked Table Manager as shown here, Select All, and click OK.
You should receive the following result. If not, check to ensure that the specific analytic has been loaded - successfully.
The schema is already pre-connected where the subject tables are linked together in the only way possible.
Double clicking on the query example will show raw data
Looking at the design view for this example:
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/252/using-access-with-qqube