Block users from exporting queries and tables

Agree with all the previous comments. Although you cannot make Access totally secure, it is possible to prevent misuse by all except experienced hackers. However, what exactly are you are trying to protect and why?

As well as the suggestions already made, there are many things you can do to make it harder for anyone to steal your data. My article (linked by George_Hepworth) gives many suggestions

You can certainly load form & report data in code as arnel_gp suggests but record sources can be read externally so that isn't secure either. A more secure alternative is to use disconnected ADO recordsets for your forms instead. That option isn't available for reports though workarounds are possible.

I would definitely password protect & thereby encrypt your Access front-end database.

In addition, consider:

a) 'deep hiding' your tables- this makes them invisible in the navigation pane and so not available to users from Excel. Unfortunately, that isn't possible with queries

b) encrypting your data as well so that even if anyone does gain access to your tables / queries, the data will be unreadable