Murakami Sale
 
 

Recently Viewed clear list


Original Essays | August 18, 2014

Ian Leslie: IMG Empathic Curiosity



Today, we wonder anxiously if digital media is changing our brains. But if there's any time in history when our mental operations changed... Continue »
  1. $18.89 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Computers Reference- General

This title in other editions

Microsoft Access 2010 VBA Programming Inside Out

by

Microsoft Access 2010 VBA Programming Inside Out Cover

 

Synopses & Reviews

Publisher Comments:

You're beyond the basics, so dive right in and build sophisticated and elegant business solutions with Access—using Microsoft® Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!

  • Gain a deep understanding of how to design effective Access applications
  • Get started with client-server design and cloud computing
  • Broaden your skill set by developing applications linked to Microsoft SQL Server
  • Support existing applications that contain a large amount of programming code
  • Tame complex controls such as the TreeView, Tab, and ListView
  • Use a variety of approaches to design your user interface
  • Automate the integration of data from different sources
  • Extend Access applications by connecting to Microsoft SharePoint® and other Microsoft Office® applications

Book News Annotation:

This guide shows how to use Visual Basic for Applications (VBA) to trick out Microsoft Access. The books is aimed at two types of readers: readers who have worked with Access and developer applications, and more experienced VBA programmers who are ready to learn more advanced aspects of VBA programming as well as development with SQL Server and cloud computing. Readers are assumed to have experience working with Access or a strong programming background. The book's seven self-contained sections cover the VBA environment and language; the Access object model and data access objects; working with forms and reports; advanced programming with VBA classes; external data and Office integration; SQL Server and SQL Azure; and application design. The book's troubleshooting tips and workarounds are illustrated with b&w screenshots. A searchable online edition of the book offers bonus content, application files, and sample database files. Couch has taught VBA programming courses. Annotation ©2011 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!
  • Enhance your application with VBA built-in functions and SQL code
  • Use the Access Object Model to work with data in forms and reports
  • Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
  • Create classes for handling form and control events
  • Connect your Access database to different sources of data
  • Effectively plan how to upsize an existing Access database to Microsoft SQL Server
  • Dynamically update Microsoft Excel spreadsheets from the database
  • Migrate your Access database directly to the cloud using SQL Azure

About the Author

Andrew Couch is a Microsoft Access MVP. He has been programming with VBA since it was introduced into the Access product, and uses VBA on a daily basis in commercial applications. As a director and founding member of the UK Access User Group, he has been involved with developers and software companies using VBA. Andrew is also an experienced instructor, and has taught Introductory, Advanced, and VBA programming courses.

Table of Contents

; Introduction; Who This Book Is For; Assumptions About You; How This Book Is Organized; Features and Conventions Used in This Book; Text Conventions; Design Conventions; About the Companion Content; Access Versions; Acknowledgments; Support and Feedback; Errata & Support; We Want to Hear from You; Stay in Touch; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; VBA Environment and Language; Chapter 1: Using the VBA Editor and Debugging Code; 1.1 Debugging Code on a Form; 1.2 Creating Modules and Procedures; 1.3 Debugging Code in a Module; 1.4 Breakpointing Code; 1.5 Using the Object Browser and Help System; 1.6 Summary; Chapter 2: Understanding the VBA Language Structure; 2.1 VBA Language Settings; 2.2 Working with Constants and Variables; 2.3 Functions and Procedures; 2.4 Control Statements and Program Flow; 2.5 Summary; Chapter 3: Understanding the VBA Language Features; 3.1 Using Built-In Functions; 3.2 Domain Functions; 3.3 SQL and Embedded Quotes; 3.4 Objects and Collections; 3.5 Creating Maintainable Code; 3.6 VBA and Macros; 3.7 Error Handling; 3.8 Summary; Access Object Model and Data Access Objects (DAO); Chapter 4: Applying the Access Object Model; 4.1 The Application Object Methods and Properties; 4.2 The CurrentProject and CurrentData Objects; 4.3 The DoCmd Object; 4.4 Manipulating the Forms and Reports Collections; 4.5 Using the Screen Object; 4.6 Enhancing the User Interface; 4.7 Summary; Chapter 5: Understanding the Data Access Object Model; 5.1 The DAO Model; 5.2 Working with Databases; 5.3 Manipulating Data with Recordsets; 5.4 Working with Queries in Code; 5.5 Investigating and Documenting Objects; 5.6 Sample Applications; 5.7 Summary; Working with Forms and Reports; Chapter 6: Using Forms and Events; 6.1 Displaying Records; 6.2 Filtering by Using Controls; 6.3 Interacting with Records on a Form; 6.4 Editing and Undo on a Record; 6.5 Summary; Chapter 7: Using Form Controls and Events; 7.1 Control Events; 7.2 Combo Boxes; 7.3 List Boxes; 7.4 The TreeView Control; 7.5 The Tab Control; 7.6 Summary; Chapter 8: Creating Reports and Events; 8.1 Report Event Sequences; 8.2 Report Layout Control; 8.3 Summary; Advanced Programming with VBA Classes; Chapter 9: Adding Functionality with Classes; 9.1 Improving the Dynamic Tab Control; 9.2 Creating a Hierarchy of Classes; 9.3 Summary; Chapter 10: Using Classes and Events; 10.1 WithEvents Processing; 10.2 Abstract and Implementation Classes; 10.3 Friend Methods; 10.4 Summary; Chapter 11: Using Classes and Forms; 11.1 Opening Multiple Instances of a Form; 11.2 Classes and Binding Forms; 11.3 ActiveX Controls and Events; 11.4 Summary; External Data and Office Integration; Chapter 12: Linking Access Tables; 12.1 Linking Access to Access; 12.2 Linking to Excel and Text Files; 12.3 Linking to SQL Server; 12.4 Linking to SQL Azure; 12.5 Linking to SharePoint Lists; 12.6 Linking Access Web Databases; 12.7 Summary; Chapter 13: Integrating Microsoft Office; 13.1 Working with Objects and Object Models; 13.2 Connecting Access to Word; 13.3 Connecting Access to Excel; 13.4 Connecting Access to Outlook; 13.5 Summary; SQL Server and SQL Azure; Chapter 14: Using SQL Server; 14.1 Introducing SQL Server; 14.2 Getting Started with the SQL Server Management Studio; 14.3 Creating Tables and Relationships; 14.4 Working with Views; 14.5 Working with Stored Procedures; 14.6 Introducing T-SQL; 14.7 Working with Triggers; 14.8 Working with Transactions; 14.9 User-Defined Functions; 14.10 Getting Started with SQL Server Security; 14.11 Summary; Chapter 15: Upsizing Access to SQL Server; 15.1 Planning for Upsizing; 15.2 The Upsizing Wizard and the SQL Server Migration Assistant; 15.3 Developing with Access and SQL Server; 15.4 Summary; Chapter 16: Using SQL Azure; 16.1 Introducing SQL Azure; 16.2 Migrating SQL Databases; 16.3 The Data Sync Feature; 16.4 Planning and Managing Security; 16.5 Building Multi-Tenanted Applications; 16.6 SQL Server Migration Assistant and Access to Azure; 16.7 Summary; Application Design; Chapter 17: Building Applications; 17.1 Developing Applications; 17.2 Completing an Application; 17.3 Deploying Applications; 17.4 Summary; Chapter 18: Using ADO and ADOX; 18.1 ActiveX Data Objects; 18.2 Working with SQL Server; 18.3 ADOX; 18.4 Summary; About the Author;

Product Details

ISBN:
9780735659872
Author:
Couch, Andrew
Publisher:
Microsoft Press
Subject:
Management Information Systems
Subject:
Computers-Reference - General
Subject:
Access;Office;Programming;VBA;Visual Basic;Windows
Subject:
Database Management - General
Edition Description:
Trade Paper
Series:
Inside Out
Publication Date:
20110831
Binding:
TRADE PAPER
Language:
English
Pages:
736
Dimensions:
9 x 7.38 in

Other books you might like

  1. Microsoft Access 2010 VBA Macro... New Trade Paper $42.00
  2. Microsoft Office 2010 Inside Out Used Trade Paper $38.00

Related Subjects

Business » Computers
Business » High Tech Management
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Networking » General
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Software Engineering » Programming and Languages
Science and Mathematics » Mathematics » General

Microsoft Access 2010 VBA Programming Inside Out New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 736 pages Microsoft Press - English 9780735659872 Reviews:
"Synopsis" by , You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!
  • Enhance your application with VBA built-in functions and SQL code
  • Use the Access Object Model to work with data in forms and reports
  • Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
  • Create classes for handling form and control events
  • Connect your Access database to different sources of data
  • Effectively plan how to upsize an existing Access database to Microsoft SQL Server
  • Dynamically update Microsoft Excel spreadsheets from the database
  • Migrate your Access database directly to the cloud using SQL Azure
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.