I am not sure where to start here but i am looking for help regarding using python to retreive data from an access 2016 database form and then populate an existing PDF form. can anyone tell me if this is possible and if so some guidence please?
While I’ve never done that, it sounds possible. Searching for “access 2016 python” finds for example this explanation how you can use Python and pyodbc to read data from an access database. Then searching for “pdf form python” finds for example this explanation how you can use Python and pdfrw to fill out a PDF form. Try combining the two.
Do you mean Access database form or Access database table? Probably table; getting data from a form would be complicated. ODBC, as already mentioned, is the likely solution. There is an Office API for Access but you are not likely to want that.