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.
| Info |
|---|
The Microsoft Access Integration services described below may require additional one-time and/or annual fees. For more information, please contact us. |
Step-by-step
...
Guide
To pull Dual Code learning records and data to Microsoft Access:
- Open Microsoft Access
- Choose your project
- In your project, choose the 'External Data' tab and click on the 'New Data Source' icon
- This will present a dropdown - select 'From Other Sources' - > 'ODBC Database'
- The ODBC Database External Data wizard will appear
- Go through the Wizard selecting the option you need - when the ODBC window appears select the corresponding 'Machine Data Source' for the ODBC connection
- 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 2102Notes: These steps are based on Microsoft Access Version 2102
Important Notes
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|