Basically a "query" is a way of asking the database a question, i.e.
How many people,
have a red car.
The query is set an can be a one off question or can be a question it is asked regularly.
The criteria is in effect the question you want answered i.e. how many people in you database have a red car So in the data base you may have the name, address, car type, car colour. In the colour field you would set the criteria as RED. Then running the query you will get all the cars that are red. If you then placed in the field on the database data about the type of car this could be Sports, saloon, hatchback SUV
So you can then ask red in the colour filed of the query and SUV for example in the TYPE field. It is the queries that make the database do its job of reporting back the information.
Humans decide what criteria is best for running Queries or Searches. If you display the database as a list of records then you can sort alphabetically from A to Z or the other way around
Microsoft Access
The ones you never use.
Microsoft Access
Tables,forms,queries,reports
Queries
with ms access we can create tables, queries, forms, reports, pages, macros and modules which are the objects of ms access.
"EQUALITY"
Conditions are known as Criteria in Access. These are what allow you to make choices and decisions on what data to show. If you only want to show people over a certain age, or people living in a certain town, or products with a cost between one value and another etc., you need to apply conditions to limit what data will be shown. You do that by specifying criteria in your queries mainly, but you can also do it in some other things, like forms and reports.
You can use queries to delete records and queries to perform calculations.
Reports in Access can be generated directly from database tables or through queries that have got their data from tables.
A query is in basic terms a QUESTION. Therefore when you make and run a query in access you are asking it questions to do with the data it has in the dataset. I.e In the last name field you may ask for all people who meet the criteria of SMITH as the last name. Queries can be very complex depending on what youve stored in the database and what your asking of it.