answersLogoWhite

0

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.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

In access the best types of queries to use for data analysis are?

In Access, the best types of queries for data analysis are Aggregate Queries, which summarize data using functions like SUM, AVG, and COUNT; Parameter Queries, which allow users to input criteria dynamically; and Crosstab Queries, which provide a compact summary of data across two dimensions. Using these queries enables efficient extraction of insights from large datasets, facilitating informed decision-making. Additionally, Action Queries can be useful for data manipulation tasks such as updating or deleting records based on specific criteria.


What feature is used in Access to set criteria to select or sort data?

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


Where do you use queries?

Microsoft Access


When queries of Access are useless?

The ones you never use.


What includes tables queries forms and reports?

Microsoft Access


What is a database object that enables you to locate multiple records matching specified criteria in an access database?

In an Access database, a query serves as the database object that allows you to locate multiple records matching specified criteria. By defining specific conditions, users can filter and retrieve relevant data from one or more tables efficiently. Queries can be created using SQL or through the Access query design interface, making it a versatile tool for data analysis and reporting.


What is simply a question presented in a way that Access can process?

Queries


What is a complete list of access objects?

Tables,forms,queries,reports


What can you do with the ms access?

with ms access we can create tables, queries, forms, reports, pages, macros and modules which are the objects of ms access.


What tool do you use to delete record or perform calculations on table in Microsoft Access?

You can use queries to delete records and queries to perform calculations.


What are conditions in access?

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.


What is a access assumes criteria?

"EQUALITY"