| Access 2000 VBA Handbook |  | Author: Novalis
Publisher: Sybex
Category: Book
List Price: $49.99
Buy New: $13.25
as of 5/22/2012 00:01 EDT details
You Save: $36.74 (73%)
New (11) Used (37) from $0.14
Seller: surpluscomputerbooks
Sales Rank: 1,190,650
Languages: English (Unknown), English (Original Language), English (Published)
Media: Paperback
Pages: 845
Number Of Items: 1
Shipping Weight (lbs): 3.3
Dimensions (in): 8.9 x 7.4 x 2.1
ISBN: 0782123244
UPC: 025211223246
EAN: 9780782123241
ASIN: 0782123244
Publication Date: August 5, 1999
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Want to get the most out of Access? Then you need to know VBA.
Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job.
You'll learn how to:
* Create databases and projects
* View and print reports
* Run queries to find specific records
* Automate complex and time-consuming procedures
* Synchronize forms and tables
* Understand the ADO and DAO models
* Customize the user interface
* Access data using OLE DB and ODBC
* Create VBA procedures for navigating a database or project
* Use object properties and methods to write VBA procedures
* Create relationships between forms
* Execute commands using SQL statements in VBA code
* Use ActiveX controls in your VBA procedures
Amazon.com Review
Database front ends are the bread and butter of most Visual Basic programmers, so it pays to know how to build them well (and as efficiently as possible). Access 2000 VBA Handbook does a good job of explaining the power of Visual Basic for Applications (VBA) and how it can be used to create custom interfaces on top of Access 2000 databases. This is a well-written, comprehensively researched book well-suited to aspiring Access developers. It's also a fine resource for programmers who use older versions of Access and want to learn more about the newest version, particularly the new DAO-centric approach to transactions. The writing style will appeal to those with a modicum of familiarity in general programming concepts and procedures--the sort of knowledge one can gain in a university-level survey programming course. It documents core VBA as it applies to Access but concentrates mostly on explaining the tools available to solve various problems. The book doesn't go overboard with code listings--a greater number of explicitly stated solutions to problems would have made it better. Instead, it presents long, annotated lists of options and parameters. It also documents lots of step-by-step procedures involving Access's graphical user interface. --David Wall Topics covered: The Database Wizard, the VBA programming environment, basic VBA data and control structures, form design, record manipulation, and Structured Query Language (SQL). Object model coverage includes the Access object model, Data Access Objects (DAO) and ActiveX Data Objects (ADO), with data-access emphasis on DAO.
|
| |
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Thank you for browsing ExcelBookstore.com! | |
