Wiley Access 2007 VBA Programming For Dummies 978-0-470-04653-1 ユーザーズマニュアル
製品コード
978-0-470-04653-1
Taking a Look at Access
Access, part of the Microsoft Office suite, is a huge database management
system that you work with by using modern object-oriented methods. (The
term object-oriented stems from the fact that everything you create in Access —
a table, form, report, or whatever — is considered an object.
system that you work with by using modern object-oriented methods. (The
term object-oriented stems from the fact that everything you create in Access —
a table, form, report, or whatever — is considered an object.
The Access Navigation pane, as shown in Figure 1-1, is the main container in
which you store all the main objects that make up a single database. The
Navigation pane breaks down the objects into groups — tables, queries,
forms, and so on — and each group contains the objects within that group.
The following list summarizes the types of objects.
which you store all the main objects that make up a single database. The
Navigation pane breaks down the objects into groups — tables, queries,
forms, and so on — and each group contains the objects within that group.
The following list summarizes the types of objects.
Tables: Tables contain the raw data that all other object types display and
manage. Data in tables is stored in records (rows) and fields (columns).
Queries: Use queries to sort and filter data from one or more tables.
Forms: Access forms are similar to printed fill-in-the-blank forms, but
Forms: Access forms are similar to printed fill-in-the-blank forms, but
they allow you to view and change data stored in Access tables.
Reports: Reports define how data should be presented on printed pages.
Macros: Macros provide a means of automating certain aspects of
Macros: Macros provide a means of automating certain aspects of
Access without programming in VBA.
Modules: The Modules group, as you soon discover, is one of the places
where you store VBA code. If you’re not already familiar with modules,
that’s fine. Modules are what this book is really all about.
that’s fine. Modules are what this book is really all about.
Groups
Navigation pane
Figure 1-1:
The Access
Navigation
pane.
10
Part I: Introducing VBA Programming
05_046531 ch01.qxp 1/16/07 10:31 PM Page 10