Access data analysis cookbook / Ken Bluttman & Wayne S. Freeze.

Format:

Book

Author/Creator:

Bluttman, Ken.

Contributor:

Freeze, Wayne S.

Language:

English

Subjects (All):

Microsoft Access.

Database searching.

Statistics--Data processing.

Statistics.

Physical Description:

1 online resource (368 p.)

Edition:

1st edition

Place of Publication:

Sebastopol, California : O'Reilly, 2007.

Language Note:

English

System Details:

text file

Summary:

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. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financi

Contents:

Access Data Analysis Cookbook; What&s in This Book; Conventions Used in This Book; Using Code Examples; We&d Like Your Feedback!; Acknowledgments; From Wayne S. Freeze; 1. Query Construction; 1.1.2. Solution; 1.1.3. Discussion; 1.1.4. See Also; 1.2. Making AND and OR Do What You Expect; 1.2.2. Solution; 1.2.3. Discussion; 1.3. Working with Criteria Using the IN Operator; 1.3.2. Solution; 1.3.3. Discussion; 1.3.4. See Also; 1.4. Excluding Records with the NOT Operator; 1.4.2. Solution; 1.4.3. Discussion; 1.4.4. See Also; 1.5. Parameterizing a Query; 1.5.2. Solution; 1.5.3. Discussion

1.6. Returning a Top or Bottom Number of Records1.6.2. Solution; 1.6.3. Discussion; 1.7. Returning Distinct Records; 1.7.2. Solution; 1.7.3. Discussion; 1.8. Returning Random Records; 1.8.2. Solution; 1.8.3. Discussion; 1.9. Fine-Tuning Data Filtering with Subqueries; 1.9.2. Solution; 1.9.3. Discussion; 1.10. Combining Data with Union Queries; 1.10.2. Solution; 1.10.3. Discussion; 1.11. Inserting On-the-Fly Fields in Select Queries; 1.11.2. Solution; 1.11.3. Discussion; 1.12. Using Aliases to Simplify Your SQL Statements; 1.12.2. Solution; 1.12.3. Discussion; 1.13. Creating a Left Join

1.13.2. Solution1.13.3. Discussion; 1.14. Creating a Right Join; 1.14.2. Solution; 1.14.3. Discussion; 1.15. Creating an Outer Join; 1.15.2. Solution; 1.15.3. Discussion; 1.15.4. See Also; 2. Calculating with Queries; 2.1.2. Solution; 2.1.3. Discussion; 2.2. Finding the Number of Items per Group; 2.2.2. Solution; 2.2.3. Discussion; 2.3. Using Expressions in Queries; 2.3.2. Solution; 2.3.3. Discussion; 2.4. Using Custom Functions in Queries; 2.4.2. Solution; 2.4.3. Discussion; 2.5. Using Regular Expressions in Queries; 2.5.2. Solution; 2.5.3. Discussion; 2.5.4. See Also

2.6. Using a Cartesian Product to Return All Combinations of Data2.6.2. Solution; 2.6.3. Discussion; 2.7. Creating a Crosstab Query to View Complex Information; 2.7.2. Solution; 2.7.3. Discussion; 3. Action Queries; 3.1.2. Solution; 3.1.3. Discussion; 3.2. Appending Data; 3.2.2. Solution; 3.2.3. Discussion; 3.3. Deleting Data; 3.3.2. Solution; 3.3.3. Discussion; 3.4. Creating Tables with Make-Table Queries; 3.4.2. Solution; 3.4.3. Discussion; 4. Managing Tables, Fields, Indexes, and Queries; 4.1.2. Solution; 4.1.2.2. Using ADOX to create a table; 4.1.2.3. Using SQL to create a table

4.1.2.4. Using an XSD schema definition to create a table4.1.3. Discussion; 4.1.3.2. Which method should you use?; 4.2. Altering the Structure of a Table; 4.2.2. Solution; 4.2.2.2. Changing a field&s data type; 4.2.3. Discussion; 4.3. Creating and Using an Index; 4.3.2. Solution; 4.3.3. Discussion; 4.4. Programmatically Removing a Table; 4.4.2. Solution; 4.4.3. Discussion; 4.5. Programmatically Creating a Query; 4.5.2. Solution; 4.5.3. Discussion; 5. Working with String Data; 5.1.2. Solution; 5.1.3. Discussion

5.2. Returning Characters from the Middle of a String When the Start Position and Length Are Known

Notes:

Includes index.

Description based on print version record.

ISBN:

9780596516093

0596516096

9780596555214

0596555210

OCLC:

609840873