Microsoft Access 2007 Data Analysis

Michael Alexander

520 pages, parution le 20/04/2007

Ajouter à une liste

Indisponible

Résumé

Data analysis is the process of categorizing data into groups, translating large amounts of data into meaningful information, and performing a wide variety of calculations in a fraction of the time it would normally take by hand
Showing readers how to save time and increase productivity, this unique book explains how to analyze data using the latest version of Microsoft Access, the world's leading PC database system
Practical, real-world scenarios demonstrate the benefits of using Access for data analysis, show how to avoid common pitfalls of everyday data crunching, and illustrate the differences and similarities between Access and Excel data analysis
Explains how to analyze large amounts of data and report findings in an easily understood manner, automate redundant analysis, and get better visibility into data from different perspectives

L'auteur - Michael Alexander

Michael Alexander est développeur d'applications pour Microsoft. Il dispense également des conseils sur Excel et Access sur son site Web, www.datapigtechnologies.com.

Autres livres de Michael Alexander

Programmation VBA pour Excel 2019 pour les nuls

Découvrir tous les livres de Michael Alexander

Sommaire

Fundamentals of Data Analysis in Access.
- The Case for Data Analysis in Access.
- Access Basics.
- Beyond Select Queries.
Basic Analysis Techniques.
- Transforming Your Data with Access.
- Working with Calculations and Dates.
- Performing Conditional Analysis.
Advanced Analysis Techniques.
- Understanding and Using SQL.
- Subqueries and Domain Aggregate Functions.
- Running Descriptive Statistics in Access.
- Analyzing Data with Pivot Tables and Pivot Charts.
Automating Data Analysis.
- Scheduling and Running Batch Analysis.
- Leveraging VBA to Enhance Data Analysis.
- Query Performance, Database Corruption, and Other Final Thoughts.
Appendixes.
- Appendix A Data Analyst's Function Reference.
- Appendix B Access VBA Fundamentals.
- Appendix C Error Message Reference.

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Michael Alexander
Parution	20/04/2007
Nb. de pages	520
Format	19 x 23,5
Couverture	Broché
Poids	799g
Intérieur	Noir et Blanc
EAN13	9780470104859
ISBN13	978-0-470-10485-9

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles

Consultez aussi

Informatique Bases de données Produits SGBD Access Access 2007