1 | P a g e
CHAPTER 11
QUERIES
CHAPTER 11 QUESTIONS
1. The query wizard will ask you what tables and fields you want to include in a query and what level of
summarization is required. The design view process provides you a design grid to enter various fields you would
like to include in your query as well as what criteria or sorting schemes you’d like to apply.
2. Once the user has specified the tables and fields to be used in a query they can specify what criteria they want
met in order to be included in the query’s output by placing that value on the criteria row of the design grid.
CHAPTER 11 ASSIGNMENTS
1.
a.
b.
2.
a.
b.
3.
3 | P a g e
a.
b.
4.
a.
b.
4 | P a g e
5.
a.
b.
6.
a.
b.
c.
7.
a.
b.
c.
6 | P a g e
1. Kelly’s Boutique
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
l.
m.
No records had a zero quantity so no results were necessary.
n.
2. Wine Depot
a.
b.
10 | P a g e
c.
d.
e.
f.
g.
h.
i.
j.
12 | P a g e
k.
l.
3. Snick’s Board Shop
13 | P a g e
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
16 | P a g e
4. Rosey’s Roses
a.
b.
c.
d.
e.
f.
g.
h.
i.
k.
l.
m.
n.
