Hi, please could you help me wth the creation of a query in Access. Here is the problem.

Enter the tables in Table 4-15 into a relational DBMS package. Write queries to answer the following questions ? How much credit does each customer STILL have available?

THANKS!!!

create tables. Customer Customer # - Customer Name city State 1000 Smith Phoenix AZ 1001 Jones St. Louis MO 1002 Jeffries Atlanta GA 1003 Giikey Phoenix AZ 1004 Lankford Phoenix AZ 1005 Zeile Chicago IL 1006 Pagnozzi Salt Lake City UT 1007 Arocha Chicago IL * 0 Record 9 of 9 No Filter Search Credit Limit 2500 1500 4000 5000 2000 2000 3000 1000 Quantity on Hand Inventory Item# . Description - Unit Cost 1010 Blender $14.00 1015 Toaster $12.00 1020 Mixer $23.00 1025 Television $499.00 1030 Freezer $799.00 1035 Refrigerator $699.00 1040 Radio $45.00 1045 Clock $79.00 0 $0.00 Record: H 49 of 9 No Filter Search Unit Price $29.95 $19.95 $33.95 $699.95 $999.95 $849.95 $79.95 $99.95 S0.00 200 300 250 74 32 25 100 300 0 create tables. Customer Customer # - Customer Name city State 1000 Smith Phoenix AZ 1001 Jones St. Louis MO 1002 Jeffries Atlanta GA 1003 Giikey Phoenix AZ 1004 Lankford Phoenix AZ 1005 Zeile Chicago IL 1006 Pagnozzi Salt Lake City UT 1007 Arocha Chicago IL * 0 Record 9 of 9 No Filter Search Credit Limit 2500 1500 4000 5000 2000 2000 3000 1000 Quantity on Hand Inventory Item# . Description - Unit Cost 1010 Blender $14.00 1015 Toaster $12.00 1020 Mixer $23.00 1025 Television $499.00 1030 Freezer $799.00 1035 Refrigerator $699.00 1040 Radio $45.00 1045 Clock $79.00 0 $0.00 Record: H 49 of 9 No Filter Search Unit Price $29.95 $19.95 $33.95 $699.95 $999.95 $849.95 $79.95 $99.95 S0.00 200 300 250 74 32 25 100 300 0