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 ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

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