Chapter 1. Advantages of Access and VBA

IN THIS CHAPTER

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.