Access Data Analysis Cookbook, Bluttman K., Freeze W., 2007

Access Data Analysis Cookbook, Bluttman K., Freeze W., 2007.

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.




Working with String Data.
Text-based data can contain more than just the letters of the alphabet. Numbers can be treated as text, and there are many characters that are neither letters nor numbers, but are vital to text-based work. Consider tabs, carriage returns, spaces, backspaces, and many of the symbols used in everyday work (hyphens, currency symbols, etc.). These all need to be as accessible and pliable as the letters and numbers. In this chapter, you’ll find recipes illustrating how to find text strings within other text strings, how to replace text strings with others, and how to remove unwanted spaces from text strings. There’s also a recipe that discusses different methods for combining text strings, and one that reveals how to sort numbers that are stored as text.

Table of Contents.
Preface.
1.Query Construction.
2.Calculating with Queries.
3.Action Queries.
4.Managing Tables, Fields, Indexes, and Queries.
5.Working with String Data.
6.Using Programming to Manipulate Data.
7.Importing and Exporting Data.
8.Date and Time Calculations.
9.Business and Finance Problems.
10.Statistics.
Index.



Бесплатно скачать электронную книгу в удобном формате, смотреть и читать:
Скачать книгу Access Data Analysis Cookbook, Bluttman K., Freeze W., 2007 - fileskachat.com, быстрое и бесплатное скачивание.

Скачать pdf
Ниже можно купить эту книгу по лучшей цене со скидкой с доставкой по всей России.Купить эту книгу


Скачать - pdf - Яндекс.Диск.




Теги: Bluttman :: Freeze :: базы данных :: работа с базами данных :: книги на английском языке