How To Create A Query In Ms Access

Table of contents:

How To Create A Query In Ms Access
How To Create A Query In Ms Access

Video: How To Create A Query In Ms Access

Video: How To Create A Query In Ms Access
Video: Access: Designing a Simple Query 2024, November
Anonim

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.

How to create a query in Ms Access
How to create a query in Ms Access

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.

Recommended: