Can an application be built to allow joins of the underlying table structure to provide additional reporting facilities as required?

This will depend on the underlying data server used for the application, but typically, yes this is be done e.g. MS SQL could be used along with standard analytical tools can be used to query it.