Page Comparison

Dual Code's Microsoft Access integration lets you connect Dual Code's data to Microsoft Access. Once connected, you can manipulate 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

...

Notes

...

:

...

• 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.

...

These steps are based on Microsoft Access Version 2102

...

Related articles

...

...

Important Notes