Loading…

Managing data with Microsoft Excel /

You have learned the methods to the madness of Excel. Formulas and functions are friends instead of foes. Yet you know there's something missing that could make your job even easier. That "something" is efficient and effective data management. Managing Data with Excel is the only book...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Carlberg, Conrad George
Format: Electronic eBook
Language:Inglés
Published: Indianapolis, Ind. : Que, ©2004.
Series:Business solutions.
Subjects:
Online Access:Texto completo (Requiere registro previo con correo institucional)
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 DAO
  • 12. Controlling a database from Excel using ADO and DAO.