I know that it is possible to link databases from Access to QGIS via the ODBC Data Source administrator.
I am curious if it would be possible to create a python code/plugin that would allow the user to do the following:
- Search for a specific piece of data
- Create a buffer of x amount of distance from that one point
- Select the data that intersect with that buffer
( I am sure the first 3 steps in this are possible)
- Take the selected data and use it to spit out a report in Microsoft access via the ODBC Data Source Administrator.