I have one database with process that allows users to customize an export. I use code that manages QueryDefs to modify query object. I have never published an executable database so don't know if this can be done in one. Here is an excerpt. Not showing code that builds the sql string.
Code:
Private Sub btnExcel_Click()
Dim qdfUser As DAO.QueryDef
CurrentDb.QueryDefs.Delete ("UserQuery")
Set qdfUser = CurrentDb.CreateQueryDef("UserQuery", Me.tbxFilter)
DoCmd.OpenQuery "UserQuery", , acReadOnly
DoCmd.RunCommand acCmdExportExcel
End Sub
It is possible to have code in frontend that will build and link to tables in the backend. I have this and used it maybe twice. It was used more during development 9 years ago. I don't think this approach is suitable for your situation. Build table or query in frontend. Be aware that creating and deleting objects are design modifications and design modifications cause db to grow. Be sure to run Compact & Repair regularly.