Microsoft Access 2010 Bible

Name: Microsoft Access 2010 Bible
Author: Michael Groh

Specificaties

Paperback, 1343 blz. | Engels

John Wiley & Sons | 1e druk, 2010

ISBN13: 9780470475348

Rubricering

John Wiley & Sons 1e druk, 2010 9780470475348

Onderdeel van serie Bible (Hungry Minds)

Verwachte levertijd ongeveer 8 werkdagen

54,60

In winkelwagen

Samenvatting

Your personal guide to a powerful,easy-to-use, database-management system

Whether you want to use the power of Access 2010 to manipulate datasheets, build forms with wizards, or automate query parameters, this book shows you how. Discover enhancements in this version such as wider integration with SharePoint. Find examples that show you the types of tables, queries, forms, and reports you'll need to create when performing common business activities. Packed with pages of tips, techniques, and instruction, this is the guide you need to succeed with Access 2010.

- Review database and Access terminology
- Plan tables and work with Access data types
- Construct queries and utilize Datasheet view
- Create great-looking and effective forms and reports
- Take advantage of VBA programming and development techniques applicable to both Access 2010 and Access 2007
- Handle application errors and exceptions
- Customize the Access 2010 Ribbon and use the Windows API
- Publish Access tables, forms, and reports on SharePoint® sites

What's on the CD-ROM?
Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for most chapters, along with other useful documents, images, and help files that accompany the examples.
- All the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examples
- Searchable PDF of the book

System Requirements: See the CD-ROM appendix for details and complete system requirements.

Specificaties

ISBN13:9780470475348

Trefwoorden:Microsoft Office, Microsoft, databases, Access 2010

Taal:Engels

Bindwijze:paperback

Aantal pagina's:1343

Uitgever:John Wiley & Sons

Druk:1

Hoofdrubriek:IT-management / ICT

Serie:Bible (Hungry Minds)

Inhoudsopgave

Acknowledgments.
Introduction.

Part 1: Access Building Blocks.
1. An Introduction to Database Development.
2. Creating Access Tables.
3. Designing Bulletproof Databases.
4. Selecting Data with Queries.
5. Using Operators and Expressions in Access.
6. Working with Datasheet View.
7. Creating Basic Access Form.
8. Working with Data on Access Forms.
9. Presenting Data with Access Reports.

Part 2: Programming Microsoft Access.
10. VBA Programming Fundamentals.
11. Mastering VBA Data Types and Procedures.
12. The Access Event Model.
13. Accessing Data with VBA Code.
14. Debugging Your Access Applications.
15. Using Access Data Macros.

Part 3: More-Advanced Access Techniques.
16. Working with External Data.
17. Importing and Exporting Data.
18. Advanced Access Query Techniques.
19. Advanced Access Form Techniques.
20. Advanced Access Report Techniques.
21. Building Multiuser Applications.
22. Integrating Access with Other Applications.
23. Handling Errors and Exceptions.

Part 4: Professional Database Development.
24. Optimizing Access Applications.
25. Advanced Data Access with VBA.
26. Bulletproofing Access Applications.
27. Using the Windows Application Programming Interface.
28. Object-Oriented Programming with VBA.
29. Customizing Access Ribbons.
30. Using Access Macros.
31. Distributing Access Applications.

Part 5: Access and Windows SharePoint Services.
32. Understanding Windows SharePoint Services.
33. Integrating Access with SharePoint.
34. Understanding Access Services.
35. Deploying Access Applications to SharePoint.

Part 6: Access as an Enterprise Platform.
36. Client/Server Concepts.
37. SQL Server as an Access Companion.
38. Upsizing Access Databases to SQL Server.

Part 7: Appendixes.
Appendix A: Access 2010 Specifications.
Appendix B: What's New in Access 2010.
Appendix C: What's on the CD-ROM.

Index.