Very sound advice.
I would go in stronger than that. In my view, "splitting the database" should never be required. You should always start a new project by creating two databases: "Data" and "Code". Never, ever, ever create an Access database system with data (tables) and program (everything...