Queries are those objects in a database that allow us to view, change, and arrange data stored in tables.
Explain: (isa itong parte ng database na kung saan ginagamit para ipakita ang mga data at pwede rin itong baguhin o i-edit.)

Various types of queries exist:
Select queries, Action queries at Crosstab queries
Explain: (ito ang mga query na pwedeng gamitin pero ang sa amin jan ay select query.)
Select queries.
These are the queries that extract or show us data.
They will show data that complies with specific criteria.
Explain: (Ito ang query na nag Eextract ng data o nag papakita ng data galling sa database
At pwede rin itong magpakita ng data na may specific criteria.)

To create a query,
Open the database window where the query will be created.
Explain: (una nga ay buksan natin ang database window)
Click on the Queries object found on the left lateral of the Database window. (click natin yung Queries button at ito ang lalabas)

Explain: (meron tatlong paraan para simulan ang query) * Double click on the Create query by using wizard option.
In this case the wizard window will open in which we are asked from which table we choose to extract the data, the fields we wish to visualize and the title of the query, next it will automatically generate the corresponding query.
Explain: ( sa wizard ay automatically na syang nag eextract ng data papunta sa query galling sa pinili nating database, automatic ng mailalagay yung mga inimput natin sa fields papunta sa grid at pati rin yung title ng query .) * Double click on Create query in Design view.
In this case the Query design window will open on which we will elaborate further on, and within which we can define our query in more detail.
Explain : (sa query design view naman ay mas maidedetalye natin ang query na gagamitin natin) * Click on the new button in the Database window.
Explain: (sa new button naman ay magbubukas lang sya ng new Query window at ito ang gagamitin namin.) Explain: (dito sa New Query window ay mas marami lang ang pagpipilian. Ang;)
Design view, simple query wizard, crosstab query wizard, find duplicates query wizard, find unmatched query wizard. (at ang ginamit naming ay design view at lalabas may lalabas na Show table kapag kinlick natin ang design view.)

On entering the Query design we are firstly asked for which tables the query should extract the data from:
Explain: (pagmagsisimula na nga tayo sa paggawa ng query ay pipili muna tayo kung saan natin kukunin ang data na gagamitin.)
Select the table from which we wish to extract the data and click on the Add button (or double-click on its name).
Explain: (click natin yung tables na gagawin natin then click add. Then click close)
If we wish to extract data from another query, click on Queries tab an select it.
If we wish to extract data from various tables we should continue in the same manner.
Design View
Explain: (dito sa design view, ditto natin Ie-edit ang query natin)
To add fields to the QBE grid we can:
Double click on the name of the field appearing in the table’s area, this will be placed in the first vacant column of the QBE grid.
Explain: (sa paglalagay ng field sa QBE grid. Pwede nating I double-click ang Field sa lumabas na tables at lalabas ito sa unahang bahagi ng grid)
Or Click on the Field row of an empty column in the grid, an arrow will appear to the right with a drop down list with all the fields from all the tables that appear in the tables area.
Explain: (Pwede rin tayong pumili sa grid, sa pagclick nito sa arrow sa gilid ng grid at may lalabas na dropdown list.) We can also type the name of the field directly in the Field: row of an empty column in the grid.
Explain: (pwede rin tayong magtype directly sa grid.)
Changing the order of the fields
If we want to change the order of fields that have been included in the grid we can move a column (or various) either by dragging it.
Explain: (kung gusto naman nating baguhin ang pag kakasunod ng mga fields pwede natin itong idrag )
To move a column by dragging it:
Position the cursor over the extreme top part of the column and when the arrow appears clic, and the column will appear standing out (it is selected).
Explain: (itapat lang ang kursor sa itaas na bahagi ng field at may lalabas na arrow then iclick at mag ba black ito)
Move the cursor slightly so that the arrow appears. Press the mouse button and mantaining it down, drag the column to the desired position.
Explain: (kapag na click na ilagay ulit ito dito at iclick ulit pero kailangang naka maintain ito sa pagclick pagkatapos ay ilagay sa gusting position.)

Run the query
We can run the query from the Query design window or from the Database window.
From the design view of the query:
Click on the icon button on the toolbar.
Explain: (sa query design view naman iclick lang natin itong icon na to.)
From the Database window:
Firstly select the query to run by clicking on it.
Next click on the open button in the database window.
Explain: (sa database window iclick ang query then click your query.)