Access data analysis cookbook
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 performi...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2007.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627116106719 |
Tabla de Contenidos:
- 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
