In this article, author Randal Hoff shows how to use Multi-Record Type pattern to provide both NoSQL and SQL access to c-treeACE data that combines multiple schemas in a single table.

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data.