Microsoft Access 2010 VBA Macro Programming

Name: Microsoft Access 2010 VBA Macro Programming
Price: 6.75 USD
Availability: InStock
ISBN: 9780071738576

ISBN-10: 0071738576

ISBN-13: 9780071738576

Edition: 2011

Authors: Richard Shepherd

List price: $69.95

30 day, 100% satisfaction guarantee!

Buy new: $33.52

Marketplace

3 new & used from $6.75

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Book details

List price: $69.95
Copyright year: 2011
Publisher: McGraw-Hill Education
Publication date: 11/15/2010
Binding: Paperback
Pages: 400
Size: 7.00" wide x 9.00" long x 1.00" tall
Weight: 1.430
Language: English




Programming in Access VBA



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



Table Macros



Object Models



The Access Object Models



The Main Objects



The DoCmd Object



Using Access to Interact with Other Office Programs



Advanced Techniques in Access VBA



Charts and Graphs



Working with External Databases



API Calls



Class Modules



Animation



Access VBA in Action



Getting the Login ID



Securing Your Database



Creating Audit Trails on Tables



Creating and Editing Queries in VBA



Search and Replace in Queries



Using the DateAdd Function



Monitoring Table Statistics



Handling Large Text Files



Create and Change Table Structures



Create an Objects Inventory



Manipulate Charts Colors



Drill Down on Charts



Use Excel For Output



Using FTP in VBA



What Happens When the 2-GB Limit is Reached



Creating Menu Structures with the Ribbon



Make Controls on Forms Interactive



Set Up Levels of User Security


Appendix. ASCII Character Codes


Index