2.3- What is a query? Explain the process of saving the run to query.
Answers
Answer:
A query is a set of instructions that you can use for working with data. You run a query to perform these instructions. In addition to returning results — which can be sorted, grouped, or filtered — a query can also create, copy, delete, or change data.
Answer:
jgzgzyddyogykstdtjsitststsitsutsitstFor example, if your database has a table with a lot of information about products and you want to review a list of products and their prices, here’s how you’d create a select query to return just the product names and the respective price:
Open the database and on the Create tab, click Query Design.
In the Show Table box, on the Tables tab, double-click the Products table and then close the dialog box.
In the Products table, let’s say that you have Product Name and List Price fields. Double-click the Product Name and List Price to add these fields to the query design grid.
On the Design tab, click Run. The query runs, and displays a list of products and their prices.