Access 2010 VBA Macro Programming

Name: Access 2010 VBA Macro Programming
Author: Richard Shepherd

Specificaties

Paperback, 373 blz. | Engels

McGraw-Hill Computing | 1e druk, 2011

ISBN13: 9780071738576

Rubricering

Hoofdrubriek : Computer en informatica

Juridisch : Computer en informatica

McGraw-Hill Computing 1e druk, 2011 9780071738576

Verwachte levertijd ongeveer 11 werkdagen

71,08

In winkelwagen

Samenvatting

Develop custom Access VBA macros

Perfect for power users, 'Microsoft Access 2010 VBA Macro Programming' reveals how to maximize the features and functionality of Access 2010. You'll get in-depth details on Access VBA programming and application development followed by 20 real-world projects-complete with source code-that show you how to set up specific subroutines and functions. This practical resource then explains how to include the subroutines in the Access menu system and transform a set of interrelated VBA macros into an Access add-in package. Create your own Access 2010 VBA macros right away with help from this hands-on guide.

Learn how to:
- Create and enhance forms and reports
- Design custom dialog boxes and buttons
- Develop custom menus for the Ribbon
- Use SQL queries with VBA
- Create table macros
- Use Office object models to interact with other Microsoft applications
- Create and manipulate charts and graphs
- Work with external databases
- Add functionality to your programs with API calls
- Animate objects in Access
- Enhance database security
- Create audit trails
- Handle large text files
- Transfer data via FTP

Specificaties

ISBN13:9780071738576

Taal:Engels

Bindwijze:paperback

Aantal pagina's:373

Uitgever:McGraw-Hill Computing

Druk:1

Verschijningsdatum:4-11-2010

Hoofdrubriek:Computer en informatica

Inhoudsopgave

Part 1: Programming in Access VBA
1. The Basics
2. Variables, Arrays, Constants and Data Types
3. Modules, Functions and Subroutines
4. Programming Basics: Decisions and Looping
5. Strings and Functions and Message Boxes
6. Operators
7. Debugging
8. Errors and the Error Function
9. Forms and Reports
10. Common Dialog Control
11. Working with the Ribbon
12. SQL Queries
13. Table Macros

Part 2: Object Models
14. The Access Object Models
15. The Main Objects
16. The DoCmd Object
17. Using Access to Interact with Other Office Programs

Part 3: Advanced Techniques in Access VBA
18. Charts and Graphs
19. Working with External Databases
20. API Calls
21. Class Modules
22. Animation

Part 4: Access VBA in Action
23. Getting the Login ID
24. Securing Your Database
25. Creating Audit Trails on Tables
26. Creating and Editing Queries in VBA
27. Search and Replace in Queries
28. Using the DateAdd Function
29. Monitoring Table Statistics
30. Handling Large Text Files
31. Create and Change Table Structures
32. Create an Objects Inventory
33. Manipulate Charts Colors
34. Drill Down on Charts
35. Use Excel For Output
36. Using FTP in VBA
37. What Happens When the 2-GB Limit is Reached
38. Creating Menu Structures with the Ribbon
39. Make Controls on Forms Interactive
40. Set Up Levels of User Security

Appendix. ASCII Character Codes

Index