12. Advanced Query Techniques
In This Chapter
• What are calculated fields, and why would I want to use them?
• What are parameter queries, and why are they important?
• How can I build a query that updates table data?
• How can I build a query that deletes table data?
• How can I build a query that appends data to a table?
• How can I build a query that makes a new table?
• How can I summarize table data?
• What is an outer join, and why would I need one?
You will probably agree from your experience with queries thus far that Access queries are very powerful. This chapter takes Access queries to a whole new level.
You begin by creating calculated fields. You can create calculated fields that multiply the price of an item by the quantity, or ...
Get Access® 2013 Absolute Beginner’s Guide 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.
