I am a novice and trying to learn VB; therefore, I purchased this book. I am on Chapter 6: Using DAO to Access Data, page 111. I am not understanding it. Anyway, I am trying to understand some code I keep seeing, for example:

Dim dbMyDB As DAO.Database
Set dbMyDB = DBEngine.Workspace(0).Databases(0)

The explanations I have read are not clear to me.

What is DAO and workspace? I need non-technical explanations or explanations explained simple enough that a dummy can understand it. I need a clearer understanding of DAO.

My thoughts right now are: DAO is like a library that holds templates to do this and that to your data--for instance, to delete a record, the code is store in a DAO library for delete--you have to go to that library, retrieve the template for delete, save the template to your document, and then use the template to perform a deletion.

Any simple explanations and/or examples are appreciated.

Thanks!