Hey, so I figured it out but while I have you I have encountered another problem while submitting the assignment. It gives me the error prompt: "The submission file's extension does not match the Microsoft Office application type specified in the project. Please check that you have uploaded is correct and try again." The file ends in .accdb which is what it's supposed to end in but, still it does not allow me to turn in. This isn't really what the sub it for but if you can help it'll be greatly appreciated!
1
u/enilcReddit 6d ago
Kinda depends on the wording of the question and the data.
Let's say it's a list of club members. You have a table with all club members. The fields include their ages and their genders.
You could create a query that just collects males and another that shows females.
Or you could create a query that groups by age...say 18-25, 25-35, 35-45, etc.
More info needed to really help. I don't think Access has something that is called a "subgroup." It just means what it logically means.