Wiley Access 2007 VBA Programming For Dummies 978-0-470-04653-1 ユーザーズマニュアル
製品コード
978-0-470-04653-1
Chapter 1
Where VBA Fits In
In This Chapter
Describing Access
Discovering VBA
Seeing where VBA lurks
Understanding how VBA works
T
his book is about using Visual Basic for Applications (VBA), which is a
programming language that helps you program, tweak, and squeeze pro-
programming language that helps you program, tweak, and squeeze pro-
ductivity from Access. VBA, which is embedded in Access, is a sophisticated
set of programming tools that you can use to harness the power of a pack-
aged application like Access. Just like you need to know how to walk before
you can run, you need to know how to use Access before you can start to use
Access VBA.
set of programming tools that you can use to harness the power of a pack-
aged application like Access. Just like you need to know how to walk before
you can run, you need to know how to use Access before you can start to use
Access VBA.
Maybe you want to use Access to manage a large mailing list. Maybe you
need Access to manage your whole business, including customers, products,
and orders. Perhaps you need to manage enrollments in courses or events.
Whatever your reason for using Access, your first step is always to create the
tables for storing your data. From there, you can then create queries, forms,
reports, and macros to help manage that data. All these steps take place
before you even get into VBA, so in this book we have to assume that you’re
already an experienced Access user who needs more than what queries, forms,
reports, and macros can provide. If you’re new to Access, this book isn’t a
good place to start. If you need to brush up on Access, Access 2007 For Dummies
(by John Kaufeld, Laurie Ulrich Fuller, and Ken Cook; Wiley Publishing) or
Access 2007 All-in-One Desk Reference For Dummies (Alan Simpson, Margaret
Levine Young, and Alison Barrows; Wiley) is a good place to start.
need Access to manage your whole business, including customers, products,
and orders. Perhaps you need to manage enrollments in courses or events.
Whatever your reason for using Access, your first step is always to create the
tables for storing your data. From there, you can then create queries, forms,
reports, and macros to help manage that data. All these steps take place
before you even get into VBA, so in this book we have to assume that you’re
already an experienced Access user who needs more than what queries, forms,
reports, and macros can provide. If you’re new to Access, this book isn’t a
good place to start. If you need to brush up on Access, Access 2007 For Dummies
(by John Kaufeld, Laurie Ulrich Fuller, and Ken Cook; Wiley Publishing) or
Access 2007 All-in-One Desk Reference For Dummies (Alan Simpson, Margaret
Levine Young, and Alison Barrows; Wiley) is a good place to start.
Although Access has progressed through many versions over the years, VBA
has remained relatively unchanged. We used Access 2007 to create this book,
but the code examples we present should work fine in just about any version
of Access. So now, before launching into VBA, take a moment to delve into
what tables, queries, forms, and reports are all about, and how VBA fits into
the overall scheme of things.
has remained relatively unchanged. We used Access 2007 to create this book,
but the code examples we present should work fine in just about any version
of Access. So now, before launching into VBA, take a moment to delve into
what tables, queries, forms, and reports are all about, and how VBA fits into
the overall scheme of things.
05_046531 ch01.qxp 1/16/07 10:31 PM Page 9
COPYRIGHTED MATERIAL