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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Carlberg, Conrad George
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Que, ©2004.
Colección:Business solutions.
Temas:
Microsoft Excel (Computer file)
Business > Computer programs.
Electronic spreadsheets.
Tableurs.
COMPUTERS > Desktop Applications > Spreadsheets.
Commerce.
Business & Economics.
Marketing & Sales.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares