Making a Database - 6 - Running more than one query
You can combine queries to give more detail. The queries work from left to right.
Task: Find the number of girls who eat pizza
1. Click Queries, New, Design View:
2. Click Add
3. Firstly drag down gender, and choose the criteria of female.
4. Then drag down takeaway, and choose Pizza.
5. When you run the query by clicking the red exclamation mark, the query filters females first, then pizza:
PRACTICE: Find out whether more boys than girls have climate change as the most important issue.
| 1 Start | 2 Import Data | 3 Adding a New Field |
| 4 Queries 1 | 5 Sorting | 6 Queries 2 |
| 7 Totals | 8 Forms | 9 Reports |
| 10 Charts |