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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
