Managing data with Microsoft Excel
| Main Author: | |
|---|---|
| Format: | Book |
| Published: |
Indianapolis, IN :
Que ,
c2004
|
| Subjects: |
Table of Contents:
- 1. Misusing Excel as a database management tool
- 2. Excel's data management features
- 3. Excel's lists, names, and filters
- 4. Importing data: an overview
- 5. Using Microsoft Query
- 6. Importing data: further considerations
- 7. VBA essentials reviewed
- 8. Opening databases
- 9. Managing database objects
- 10. Defining fields and records with ActiveX data objects and data access objects
- 11. Getting data from Access and into Excel with ADO and DAD
- 12. Controlling a database from excel using ADO and DAD