You will need
  • Microsoft Access
Instruction
1
Start Microsoft Access and open your database. On the basis of existing tables, create the necessary queries to provide information. To do this, use the design view or the query wizard.
How to make a request of <b>base</b> data
2
In the control tab window the base data, navigate to the tab "Queries". To the left will display all existing queries in this database, as well as two modes of their creation: "...in design view" and "... with the help of the wizard.
How to make a request of <b>base</b> data
3
Click on the label create a query in design view. The screen displays the window in this mode, add the desired tables to the query. The existing relationship between the data tables is displayed in the design window after adding them.
How to make a request of <b>base</b> data
4
On the table, double-click select the fields whose information you need in the query. The field will appear in the columns of the query. Install the same prerequisites, and display mode fields. If necessary, define grouping of lines, or a function for counting selected from tables of values.
How to make a request of <b>base</b> data
5
Save the created query by typing its name. In the query window, a new row will appear. Check the result of the query. To do this, start it on double click. The screen will open the table containing your query results.
How to make a request of <b>base</b> data
6
Create a query using the wizard. To do this, click the mouse on the corresponding label in the tab requests. This will start the wizard that will guide your actions. In the first stage, specify all required fields from tables database data. This drop-down list "Table / Queries" check the name of the table or query. Then use the arrows "<", ">" select which fields to query.
How to make a request of <b>base</b> data
7
If you need a query with the totals function in the next step, check the box against the item "Total". Open the mode with the button "Results" and set the selected field to the desired function to count the total value of its data.
How to make a request of <b>base</b> data
8
The last step is to call the created query is unique in the database name and complete the creation by clicking "finish". In the query window, a new row will appear with the name of the query. When you double-click on it, the query starts to execute. You will have a table with the results of the created query.
How to make a request of <b>base</b> data