0
a query that calculates a statistic for data that is grouped by two diffrent type of information
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
When would you use a crosstab query instead of a select query?
A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.
What types of data will form when using a crosstab query?
"row heading"
How do you create a Crosstab Query?
A crosstab query produces data in a table form, with headings for rows and for columns and numerical data for the main part of the table. It is similar to a pivot table. You need to have appropriate data for a crosstab query. It cannot be done with just any set of data. So for example you could have amounts of sales, in different shops, in different months of the year. The shop and the months are not numeric, so one acts as headings for the rows, and the other for the columns. The actual sales would be the field chosen for the value option within the design of the query. So say you chose the shops for the rows and months for the columns, then the end result would be a table which for each shop would have a value for each month, with data totalled up. In the original table the data would not have been totalled, but can be in the query. You could also choose to show the averages or a count of the sales for each shop in each month. Like pivot tables in Excel, crosstab queries in Access can be very useful for presenting data in a summarised form produced in a table.
Are crosstab queries useful for summarizing data?
yes
What is a crosstab query in Access?
It is a query that returns the data in a tabular form, similar to a pivot table in a spreadsheet. There are headings across the top and down the side. A typical example would be counting how many staff in each department are male and female. You could have the headings of the departments down the side and the headings for male and female across the top. Then there would be a total for each gender in each department.
Can write query within the query?
Yes, you can have a query inside a query. That is known as a sub-query.
What is post query and pre query?
pre query
A query that prompts for input whenever it is run is a run-time query?
A query that prompts for input whenever it is run is a Paremeter Query
What is a nested query?
It is a query inside another query. Sometimes we might use one query to reduce down the amount of data to go through and then use another query based on the output of that query to get what you want. The first query is inside or nested in the first query.
What are subqueries used for in a database?
A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.
Do you use Excel or Access in pivot tables?
Pivot Tables are used in Excel. Access has a type of query known as a Crosstab Query, which works in a similar way. If your data is mainly numeric, then you use Excel. Non-numeric data is more suited to Access. So if you have the names, genders and departments of employees and wanted to find out how many males and females are in each department, then that would be good for Access. If you had a load of sales in different regions listed with their dates and wanted to find the total sales in each month for each region, then Excel would be better.
Can you use query language to extrapolate information from a database?
Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.
