Chapter 16Access Projects


In this chapter, you will learn about Access projects, how they are different from Access databases, and how they provide a different perspective on the concept of SQL commands. We will also go into the fundamental elements of an Access project and show some of the pitfalls in their use.


Access database — An Access program developed with the Access Jet database engine.

Access project — An Access program that uses an SQL back end exclusively rather than local Jet elements.


We have been a bit vague in defining exactly what database engine we have been working with for the examples in this book. The reason for this is both simple and complex as it almost always is when dealing with Microsoft ...

Get SQL for Microsoft Access, 2nd Edition now with O’Reilly online learning.

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