In the field of molecular and cellular neuroscience, it is not a trivial task to see the forest for the trees, where numerous, and seemingly independent, molecules often work in concert to control critical steps of synaptic plasticity and signalling. Here, we will first summarize our current knowledge on essential activity-dependent transcription factors (TFs) such as CREB, MEF2, Npas4 and SRF, then examine how various transcription cofactors (TcoFs) also contribute to defining the transcriptional outputs during learning and memory. This review finally attempts a provisory synthesis that sheds new light on some of the emerging principles of neuronal circuit dynamics driven by activity-regulated gene transcription to help better understand the intricate relationship between activity-dependent gene expression and cognitive behavior.