Creating a Select query.

I. Queries (Запросы).

Queries are those objects in a database that allow us to view, change, and arrange data stored in tables.

Creating a Select query.

1) Click on the Queries object (Запросы) found on the left lateral of the Database window;

Figure 1 Creating a query.

2) Double click on the «Create query by using wizard» option (Создание с помощью мастера) (Figure 1);

3) Select created table «Students» (Figure 2, point 1);

4) Move all fields from Available Fields (Доступные поля) to Selected Fields (Выбранные поля): сlick the ">>" arrows to select all. (Figure 2, point 2);

2. Select Fields

1. Select the table «Students»

3. Confirm your choice

Figure 2 Creating a query by using wizard

5) Click Next (point 3);

6) Title your query by typing a name in the field: «Group»;

7) Click on "Finish" (Figure 3).

Figure 3 Query name

To edit created query «Group» may use «Design view» (Конструктор)

8) Open the query «Group» by «Design view» (Конструктор) (Figure 4):

Figure 4 Opening query «Group» by «Design view»

9) For «Last_name» select «Ascending» («По возрастанию») in field «Sort» («Сортировка») (Figure 5);

10) Close «Design view» and save overpatching.

Figure 5 «Design view» for query «Group»

Дата добавления: 2015-11-14