RENT TEXTBOOKS

Microsoft Access 2010 VBA Macro Programming

ISBN: 9780071738576 | 0071738576

Edition: 1st
Format: Paperback
Publisher: McGraw-Hill Osborne Media
Pub. Date: 10/25/2010

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

We have the lowest prices on thousands of popular textbooks
Free shipping both ways on ALL orders
Most orders ship within 48 hours
Need your book longer than expected? Extending your rental is simple
Our customer support team is always here to help

Summary Table of Contents Author Biography

"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... MORE VBA macros right away with help from this hands-on guide"--

Take your database skills to the next leveldevelop powerful, custom Access 2010 applications using Visual Basic for ApplicationsMicrosoft Access 2010 VBA Macro Programmingguides you through the structure of VBA, showing you how to use it specifically in Access. The book explains, step by step, how to write VBA codefrom the basics to dealing with errors and debugging code. This practical guide includes examples that illustrate how to use VBA in Access to do specific tasks. You'll learn real-world skills by example.Microsoft Access 2010 VBA Macro Programmingfeatures: Easy-to-understand instructions that explain how to accomplish programming tasks right away 20 practical sample applications Details on adding custom menus and Access add-insAll-inclusive coverage: The Basics; Variables, Arrays, Constants and Data Types; Modules, Functions and Subroutines; Programming Basics: Decisions and Looping; Strings and Functions and Message Boxes; Operators; Debugging; Errors and the Error Function; Forms and Reports; Common Dialog Control; Working with the Ribbon; SQL Queries; Data Macros/Triggers; The Access and DAO Object Models; The Access and DAO Object Models - Main Objects; The DoCmd Object; Using Access to Interact with Other Office Programs; Charts and Graphs; Working with External Databases; API Calls; Class Modules; Animation; Get the Login ID; Secure Your Database; Creating Audit Trails on Tables; Create and Edit Queries in VBA; Search and Replace in Queries; Compact the Current Database using VBA; Monitoring Table Statistics; Handling Large Text Files; Create and Change Table Structures; Create and Objects Inventory; Manipulate Charts; Drill Down on Charts; Create an Excel Spreadsheet for output of Data; Using FTP in VBA; Use of Data Macros/Triggers; Use of Ribbon; Make Controls on Forms Interactive; Set Up Levels of User Security

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

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

Author Information
Richard Shepherd spent the last 20 years developing computer software in blue chip organizations. He is a qualified accountant and the bestselling author of Excel VBA Macro Programming and Excel 2007 VBA Macro Programming.

Please wait while this item is added to your cart...