Chapter 1. Advantages of Access and VBA


Understanding Where Access Fits in Office 7

Understanding Access Programming Choices 8

Understanding Where Access Fits in Office

Access is the database management tool for the Office suite. Access comes with Office Professional and higher versions. Although other tools included in Office (specifically Excel and One Note) also provide some capability to manage data, their functionality is severely limited. Only Access offers a full set of functions to manage relational tables, create robust data entry forms, build complex queries to analyze data, and design comprehensive reports to present your data.

Access comes with VBA, the core automation language provided with many applications developed ...

Get Microsoft® Office Access 2007 VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.