Getting Started with Access

Modified on Sun, 26 Jul at 3:44 AM

Overview

Each QQube data model is already configured for Microsoft Access 2016 or later.

The underlying FACT and DIMENSION tables are linked, and the relationships are already established. You only need to open an example and refresh the linked tables.

Start with an Access Example

Open the QQube Configuration Tool and select Microsoft Access under Examples.

The available Access examples appear in the list. At least one example is provided for each data model.

Grayed-Out Examples

A grayed-out example means the required data model is not loaded or has a synchronization error. Review this guide on selection and synchronization before opening the example.

Microsoft Access examples listed in the QQube Configuration Tool

Open and Refresh an Example

1. Confirm Successful Synchronization

Review the synchronization logs and confirm that the required data model loaded successfully.

2. Open the Access Example

Double-click the required example in the QQube Configuration Tool.

The Access database opens with at least one prepared query example.

QQube Microsoft Access example opened with a prepared query

3. Refresh the Linked Tables

Open the Linked Table Manager.
Click Select All.
Click Refresh.

Microsoft Access Linked Table Manager with Select All and Refresh

4. Confirm the Refresh Result

Microsoft Access should confirm that the linked tables were refreshed successfully.

Microsoft Access confirmation that linked QQube tables refreshed successfully

If errors occur, return to Step 1 and review the synchronization logs.

The Prepared Data Model

Each Access example contains one FACT table and its related DIMENSION tables.

The relationships are already assembled according to the QQube data warehouse structure.

Prepared QQube FACT and DIMENSION table relationships in Microsoft Access

Review the Example Query

Double-click the prepared query to view the underlying QQube data.

Raw QQube data displayed by a prepared Microsoft Access query

Open the query in Design View to review the selected tables, joins, fields, and criteria.

Microsoft Access query Design View showing QQube tables and relationships

Microsoft Access query Design View showing selected QQube fields and criteria

Expected Result

The Access example opens with its linked QQube tables, relationships, and sample query already configured. After the linked tables refresh successfully, the database is ready for reporting and query customization.