What is a query in microsoft access and what does it do?

[Guest]

What is a query in microsoft access and what does it do?

[Guest]

When you use tables in access to store data, you want to be able to get back all, or more likely, just SOME of the data, based on particular values. When you want to do this, you are kind of asking a question of the database - and that question is called a QUERY - and is written in SQL (Structured Query Language).

Here is an example

Select name, phone
from myFriends
where gender='F'

this would print out the name and phone number from the table named "myFriends" for all the girls.