These problems should be completed with a database software package, such as Access. For...

These problems should be completed with a database software package, such as Access. For Problems 5-1 through 5-3, you may use data that you (or your instructor) have downloaded from an accounting database. Problem 5-4 provides an alternative to Problems 5-1 through 5-3 by using the database structure and sample data from Figure 5.10 (pg. 166). This problem also may be completed using the software of your choosing.

Using the database structure and sample data in Figure 5.10 (pg. 166) as a starting point (rather than Figure 5.2), complete the requirements of Problems 5-1 through 5-3 (or whatever portions of those problems your instructor may indicate).

REF PRB:

5-3.Note: This problem is a continuation of Problem 5-1.

a. Write a “program” to enter customer order amounts into the database and to have the system either warn the user if the new order places the customer over his or her credit limit or advise the user if the credit limit is not exceeded.

b. Test the program developed in (a) by entering the amounts of customer order business event data (use a variety of order amounts and different customers so that you test all possible combinations of variables involved in the credit-checking algorithm). (The number of order business event data will be indicated by your instructor.) Obtain hard copy evidence of the results of your testing.

5-1.Before starting this problem, you should consult the customer master data record layout in Figure 5.2 (pg. 144).

Using the database software indicated by your instructor:

a. Create the “structure” for the records in the customer data. Use Figure 5.2 as a general guide to the data elements to be included in the customer records. However, observe the following specific requirements:

(1) For the customer address, use five separate fields, one each for street address, additional address information (e.g., apartment number), city, state, and ZIP code.

(2) Provide for three additional data elements that are not shown in Figure 5.2 (pg. 144) (because they normally would be accessed from other files)—open sales orders, back orders, and accounts receivable balance.

b. If the software package supports a function to design input screens, create the screen format to be used for entering customer data.

c. Create example customer records and enter them into the database. Use a variety of names, street addresses, states, ZIP codes, open sales order amounts, accounts receivable balances, and credit limits. (The number of records will be indicated by your instructor.)

d. Obtain a printout of the database records.