You can create objects like forms and reports. Their class modules can manage the calculations on the fly by including your expressions within unbound controls or the class module directly via VBA.
Normalize your tables/relations first, then build queries, then forms and reports. Sometimes queries reports and forms are created simultaneously.