Microsoft Office Access 2007 VBA Programming For Dummies

From the Back Cover
Customize combo and list boxes
Go beyond forms and reports and build custom database solutions

Need to know how VBA works in Access 2007? This plain-English guide introduces you to the fundamentals of VBA programming, helping you get the most out of your Access apps and giving you practical code examples for immediate use in your databases. You’ll see how to control Access through VBA and apply powerful real-world VBA solutions.

Discover how to
– Create simple VBA programs
– Program Access forms
– Manage Access tables with SQL and record sets
– Test and debug your code
– Use VBA with multiple databases
– Integrate with other Office apps

About the Author
Joe Stockman is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He’s also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and VB.NET, where he specializes in creating applications for the Windows Mobile platform. He worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers’ wishes into working applications keeps them satisfied. Joe’s also writing the fundamentals column for the Advisor Guide to Microsoft Access magazine.

Alan Simpson is the author of over 100 computer books on databases, Windows, Web site design and development, programming, and networking. His books are published throughout the world in over a dozen languages and have millions of copies. Alan has also taught introductory and advanced computer programming courses at San Diego State University and the UCSD Extension. He has served as a consultant on high-technology, education oriented projects for the United States Navy and Air Force. Despite that, Alan has no fancy job title because he has never had a real job.

Related Articles

Access 2007 VBA Programming For Dummies Feb 2007

DESCRIPTION
If you’ve been using Access for a while, you’re probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:
Basic programming skills and concepts
Explanations of modules, procedures, objects, and arguments
Access-unique programming activities, including SQL and recordsets
How to use the Visual Basic editor
Creating dialog boxes, lists, drop-down menus, and functions
Integrating with other Office applications
Ready-to-use VBA code examples to type in or copy and paste from the Web
Completely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you’ve never had it before.

Access VBA Programming for Dummies

Create more powerful Access applications and databases!

This friendly, easy-to-use guide shows experienced Access users how to use VBA (Visual Basic for Applications) to not only build Access databases and applications, but also:
Covers programming fundamentals for nonprogrammers
Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects
Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops
Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming

These authors have written more than ninety computer books and have been working with databases since the early 1980s

Microsoft Office Access 2007 All-in-One Desk Reference for Dummies

– Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover beginning to advanced-level material
– Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros
– Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web
– Access is the world’s leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Access 2010 All-in-One for Dummies

The all-in-one reference to all aspects of Microsoft Access 2010
If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible.

Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010
Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web
Helps you build database solutions that integrate with the Web and other enterprise data sources
Offers plenty of techniques, tips, and tricks to help you get the most out of Access

This all-in-one guide contains everything you need to start power-using Access 2010!