Set
up the following table in Access:
|
Field |
Type |
Length
if Text |
|
|
|
|
|
ItemNo
(this is the primary key) |
Text |
5 |
|
ItemName |
Text |
20 |
|
Dept |
Text |
4 |
|
OnHand |
Integer |
|
|
OnOrder |
Integer |
|
|
ReordPt |
Integer |
|
|
Cost |
Single |
|
|
Price |
Single |
|
|
VendorCd |
Text |
2 |
Enter
the following data:
|
ItemNo |
ItemName |
Dept |
OnHand |
OnOrder |
ReordPt |
Cost |
Price |
VendorCd |
|
11111 |
Tulip |
FLOW |
50 |
55 |
50 |
.89 |
1.19 |
ABC |
|
11112 |
Peony |
FLOW |
25 |
45 |
40 |
5.25 |
6.59 |
ABC |
|
11113 |
Burning
Bush |
BUSH |
15 |
25 |
10 |
25.00 |
29.99 |
DEF |
|
11114 |
Dogwood |
TREE |
12 |
25 |
50 |
50.00 |
79.88 |
GHI |
|
11115 |
Lilac |
BUSH |
10 |
0 |
25 |
25.00 |
29.99 |
DEF |
|
11116 |
Hemlock |
EVER |
2 |
20 |
25 |
45.00 |
59.99 |
JKL |
|
11117 |
Lily |
FLOW |
0 |
50 |
50 |
4.89 |
6.25 |
MNO |
|
11118 |
Spruce |
EVER |
5 |
0 |
20 |
55.00 |
68.78 |
JKL |
|
11119 |
Cherry |
TREE |
24 |
10 |
35 |
48.00 |
75.59 |
MNO |
|
111120 |
Rhododendron |
BUSH |
25 |
25 |
50 |
25.00 |
19.99 |
PQR |
Draw
the logic flowchart, write the pseudocode and then make the test using your
Access database. Be very careful to
check the data and make sure you are getting exactly what you should be
getting. It is tricky and you may need
to play with it a little.
1.
List
all items where the Dept is FLOW and the OnHand is greater than 20.
2.
List
all items where the Dept is either TREE or BUSH.
3.
List
all items where the Price is greater than 70.00 and the Dept is either EVER or
TREE.
4.
List
all items where the Price is greater than 10 and either the on OnHand is
greater than 10 or the OnOrder is greater than 20.