Query in MS Access |DBMS Queries| important queries| SQL Queries| ICS Practical| ADP/ADS Computer

‪@computerhubayesha‬
in this videos we will learn about
How we can create query in MS Access foe example
1. Create a query to display guest whose name is “Ahmad in guest table
2. Create a query in design view to display all date wise arrival in patient table
3.  Create a query in design view to display project _No ,Student _ID ,Student _Name on project table.
4. create a query in design view to display to display all the students with grade A.
5. Create a query in design view to find information about the employee whose Empno 3
6. Create a query in design view to find information about the employee whose job is programmer
7. Write a query to display calculated field of Total Salary using expression builder Total Salary=salary +bonus
8. Create a query in design view to find information about the employee whose name begin with “Ta”
9. Create a query in design view to find information about the empname whose second letter is “a”
10. Create a query to display product who price is less than 1200 in product table.
11. Create a query in design view to display a calculated field total amount .(total amount=total _hours*rate) on package table