O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18. Building Queries in an Access Project

As you already know from Chapter 7, Chapter 8, and Chapter 9, you can quickly build nearly all the queries that you need in an Access desktop database (.mdb) using the query designer. The query designer in an Access project file (.adp) offers an interface that is similar to the one you use in an Access desktop database (.mdb). So, with only a small learning curve, you can soon be building queries in your Access projects.

Remember that your Access project file doesn’t store your data or your queries. You must connect your project to the Microsoft SQL Server Data Engine (MSDE) or Microsoft SQL Server, and it’s the server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required