Is it possible to change the transparency within tables for border and background? If yes how?
Yes. Insert the table in a text block and apply effects.
I think you mean it the other way round: Insert text frames into the cells of a table and apply effects to the text frames which are inside the cells.
Retrieving data ...