Microsoft Access is an electronic database application in which you can create tables, reports, forms, and queries. Query is a special tool for selecting data according to a specific criterion from tables and other queries.
Necessary
- - computer;
- - Microsoft Access program.
Instructions
Step 1
Run MS Acess to make a request. Go to the "Requests" tab, click on the "Create" button and select "In design mode".
Step 2
In the dialog box that opens, select the tables and fields from which you want to generate a query by double-clicking. Please note that they have been added to the design sheet. To build a query based on fields from multiple tables, make sure there is a relationship between the tables. To do this, go to the database window, call the menu "Service" - "Data schema". The presence of a connection can be judged by the line between the tables.
Step 3
Create a simple select query, add the required fields and run the query using the button on the toolbar (red exclamation mark). Save your query.
Step 4
Make a request with a selection condition. To do this, in the design form in any field, for example, "Position", enter in the "Selection condition" field - Like "Secretary". Run the execution request. In this case, the query will select data from the table according to the specified condition, i.e. will display information about secretaries.
Step 5
To make a query that would select data for any position, enter the following in the "Criteria" field: [Enter a position]. Then, when you start the execution request, a dialog box will appear every time, asking you to enter the employee's position. This request will be more versatile.
Step 6
Make a request with a limited date, for example, to select information about the company's contracts for the last month. In the Criteria for the Contract Date field, enter the following Between # 2010-01-06 # And # 2010-30-06 #. Run the execution request. The creation of the request is completed, save it using the button with the floppy disk on the toolbar.