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 |
3 |
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 |
|
11120 |
Rhododendron |
BUSH |
25 |
25 |
50 |
25.00 |
29.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 BUSH and the OnHand is greater than 10.
2.
List
all items where the vendor code is ABC and the OnHand is greater than or equal
to 25 and the OnOrder is greater than or equal to 25.
3.
List
all items where the Dept is either FLOW or BUSH.
4.
List
all items where the Price is greater than 70.00 and the Dept is either EVER or
TREE.
5.
List
all items where the Price is greater than 10 and either the OnHand is greater than 10 or the OnOrder is
greater than 20.