ADO usually uses OLE-DB and there are a couple of OLE-DB providers that support Access databases. One OLE-DB provider allows use of ODBC drivers, so anything that you can do using ODBC you can do using ADO. So with ADO, you have even more choices of the actual database used. You can use ADO with ODBC or you can use ADO for databases for which there is an OLE-DB provider for. A good overview I think is the OLE DB Providers Overview.
See Using ADO with Microsoft Visual C++ for important and useful documentation. See Sample: ADOVC1 Simple ADO/VC++ Application for one simple sample that should help. Also see ADO Code Examples in Visual C++, which has many samples for of many relevant tasks. There is a sample of creating Access tables using ADOX, but note that ADOX cannot create tables for all database formats. To create a dbase table, we must use SQL and I have a sample of that at [??]. Finally, ADO Provider Properties and Settings has a lot of useful information, especially if you want to use ADO for other things such as Excel spreadsheets.
See my Visual C++ Programmer Stuff page for more C++ stuff.