Query forms are very useful in Access software. In principle, it can be said that a question is asked using this form. You ask the database: “Who are my customers in Isfahan? Or, for example, how many sales did I have this month?
The real power of a communication database lies in its ability to retrieve and analyze your data through queries. These questions allow you to fill in your information from one or more tables based on the set of research terms you define. In this lesson, you will learn how to design or create a simple one-table question.
During this period, we use a sample database. If you want to track this, you need to download the Access 2013 sample database. Access 2013 is installed on your computer to open the sample.
What are queries (queries, queries)?
Questionnaires are a search method for collecting information from one or more tables. Running a questionnaire is like asking detailed questions about your database. When you create a questionnaire in Access in order to find the exact data you want, you will be defining specific research and search terms.
As mentioned above! In principle, it can be said that a question is asked using these query forms. You ask the database: “Who are my customers in Isfahan?
How are queries or questions used?
Queries are much more powerful than the simple searches or filters you use to find data within a table. This is because queries design their information from multiple tables.
For example, while you use a customer table search to find a customer’s name in your business or a filter on the order table to check orders made over the past week, you cannot be a customer And look at the orders at the same time.
However, you can run a query to find the name and phone number of each customer who has made purchases in the past week. A well-designed question can give you information that you could not find just by looking at the data in your spreadsheet.
When you run a query, the results are presented in a table, but when you design a case, you use different perspectives. This is called a question design point of view and allows you to see how your questions fit together. Click the buttons in the interaction below to learn how to control the query table design view.
Query a table
Let’s get acquaint with the process of creating a query by making the simplest possible query, query a table. We run the query on the bakery database client table. To say that our bakery is holding a special event, we want to invite customers who live near us because they are the most people who come and go here.
This means that we want and need to invite only customers who live nearby. If you think this sounds like filtering, yes you are right. A single-table query form is actually an advance filter use for a table.
To build a simple single table question
1. Select the create key on the bar and place the Query group.
2- Click on the query design command.
3- Access to the query design perspective will change. In the dialog box that will be display, select the table on which you want to run the query. We are running questions about our customers, so we will select the customer table.
4. Click on the word Add, then select Close.
5. Select the selected table as a small window in the object relationship pane. In the table window, double-click on the name of the string you want to include in your query. They will be add to the design grid at the button of the page.
In this example we want to send the invitation to customers who live in a certain area. Therefore, we consider the name, surname, street address, city and postal code. We do not plan on calling or emailing our customers. So we do not have to consider the contact number and email.
6- Set the search criteria by clicking on the cell in the criteria: the row of each string you want to filter. Type the criterion on each string you want in the criterion: Arrange the row of your question to consider the results that will meet all the criteria.
If you want to set multiple criteria but do not need the documents shown in the results that you want to meet all of them, type the first criterion in the criterion: row or additional criterion in Or, or the following rows and rows It.
To perform this single-tabular query, we will use a simple search criterion.
- We want to find customers who live in Raleigh, so we type in Raleigh. By typing this word in the quotation marks, we retrieve all the documents that exactly match the word Raleigh in the city price.
- Some customers who live somewhat close to this, and we want to invite them as well. We will add postal code 27513 as another criterion. Because we want to find customers who either live in this area or are in this zip code. We type this code.
7- After setting the criteria, run the questionnaire by clicking on the execution command on the drawing bar.
8. The results of the questionnaire will be display in the Datasheet view, which looks like a table. Click Save in the quick access bar to save your questionnaire. When the name appears, type the name you want and then click on it.