Microsoft Access is an easy to use database platform which is part of the Microsoft Office family.
An Access data source has the following settings:
In the first field 'File name', you can browse for the Access file you want to work with. You can also use an expression in this field to specify parameters to be used with the file, or give other commands.
Select a table
Most data sources, are organized as tables. You can simply select all data from a table by selecting the option Select a table and selecting the appropriate table from the drop down list. See below.
Join multiple tables
Using the 'Join multiple tables' query method you can combine data from multiple sheets.
Most data sources, are organized as tables. You can select data from multiple tables at once using this by selecting the option Join multiple tables and selecting the appropriate tables from the drop down list. See below.
For each selected table, you must specify the name of the table and the ID column.
The ID column is use to related rows in all tables.
Specify SQL statement
Access databases can handle complex SQL queries. To enter a custom query select 'Specify SQL statement' as the query method. See SQL quick reference for a quick overview of SQL and links to resources.
Your configuration should now appear as following:
Two sample projects that uses a Microsoft Access data base file can be found in Samples\Tutorial 2 and Samples\Tutorial 3 in the installation folder. Just double-click the .exe file and run the sample.