Microsoft Access Integration

Dual Code's Microsoft Access integration lets you connect Dual Code's data to Microsoft Access. Once connected, you can read the data using Microsoft Access Objects.

Step-by-step guide

To pull Dual Code learning records and data to Microsoft Access:

1. Open Microsoft Access
2. Choose your project 
3. In your project, choose the 'External Data' tab and click on the 'New Data Source' icon
4. This will present a dropdown - select 'From Other Sources'  - > 'ODBC Database'
5. The ODBC Database External Data wizard will appear
6. Go through the Wizard selecting the option you need - when the ODBC window appears select the corresponding 'Machine Data Source' for the ODBC connection
7. Now you can work with the data as needed

Technical Notes

The following technical details are worth noting:

• The learning environment is based on Moodle, the world's most popular open-source learning management system. Moodle does not currently generate actual foreign key constraints in the database. As such, Dual Code has defined the relationship using the following convention.
  • The ID column in a table always represents the primary key and usually has the comment of "Primary key of the table."
  • A foreign key usually has the comment of "Key referencing the primary key in the [tablename] table."
• When dealing with dates or times:
  • As a general rule, most dates/times are stored in the database as a BigInt in Unix time format (also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time). Some exceptions apply.
  • The database read-only replica is in the same timezone as the production server.

Notes: These steps are based on Microsoft Access Version 2102

Related articles