4. Using Queries to Retrieve the Data You Need

In This Chapter

• What is a query?

• Why would you want to use a query?

• How do you create a simple query?

• What’s the difference between the And condition and the Or condition?

• How do I use wildcards in the queries that I build?

• Are query results updateable?

In this chapter, you learn what queries are and why they are important. You learn how to work with queries in both Datasheet view and Design view. You explore the basics of working with queries such as selecting fields, ordering the query result, and using basic criteria. You become comfortable with the process of using And and Or conditions in the queries that you build. You also learn about comparison operators and wildcards.

What ...

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.