How to Create Queries in MS-Access?
https://www.computersprofessor.com/2016/05/how-to-create-queries-in-ms-access.html
|
A query is a condition to extract
the information from a data base. This query is a filter through which data
is evaluated. You can define filter criteria in the query and only those
records which meet the criteria are displayed.
In MS Access, we have following
types of queries
1. Select query
2. Action query
3. Update query
4. Cross tab query
Create a Query:-
Open the data base and then select
the query tab.
Click on new button.
Select simple query wizard from
query dialogue box and click on ok button.
Select the required fields from
wizard dialogue box.
Click on next button when you are
ready to continue.
Select the open query to view
information.
Click on the finish button. Then
the query result will be displayed on the screen by running the query.
|
|
|
