We will run a query on the Customers table of our bakery database. Let's familiarize ourselves with the query-building process by building the simplest query possible: a one-table query. Here, the criteria has been set so the query will search for records with Raleigh in the City field or zip code 27513. Simply type the desired criteria in the Criteria: row of the field you want to search. This is called Query Design view, and it lets you see how your query is put together.Ĭlick the buttons in the interactive below to learn how to navigate the Query Design view.Įntering query criteria lets you specify exactly what type of information you want your query to retrieve. When you run a query, the results are presented to you in a table, but when you design one you use a different view. A well-designed query can give information you might not be able to find out just by examining the data in your tables. However, you could easily run a query to find the name and phone number of every customer who's made a purchase within the past week. For example, while you could use a search in the customers table to find the name of one customer at your business or a filter on the orders table to view only orders placed within the past week, neither would let you view both customers and orders at once. This is because queries can draw their information from multiple tables. Queries are far more powerful than the simple searches or filters you might use to find data within a table. When you build a query in Access, you are defining specific search conditions to find exactly the data you want. Running a query is like asking a detailed question of your database. Queries are a way of searching for and compiling data from one or more tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |