Question

484 Core Concepts of Accounting Information Systems a. Using Access, create an employee table sim- ilar to the one shown in Figure 15-4. Create created. (Hint You can use the aforemen- tioned expression for the department code as a validation rule.) at least one record for this table b. Create validation rules for the listed restric tions and an accompanying validation text for each. Document your work by provid- ing a table outlining exactly what rules you c. Test each validation rule by attempting to enter data that violate it. Screen capture the error messages for each of your three examples. CASE ANALYSES 15-15. BSN Bicycles I (Creating a Database from Scratch with Microsoft Access) Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010. Not counting Jake-a friend who helps out occasionally at the store-Bi and Tom are the only employees. The shop occupies a small commercial space that was once a restaurant. The former kitchen now stores spare parts and provides space for bicycles repairs while the former dining area in the front is now the retail sales area. The "corporate office" is just a desk and file cabinet in the back corner of the retail area. Bill and Tom are more friends and bicycling enthusiasts than businessmen. They've pretty much sunk their life savings into the shop and are anxious that it succeed. In the first year of operations they worked hard to convert the space into its present condition, which includes an old-timey sign above the door with their name "BSN Bicycles With all the other work that had to be done the first year, marketing efforts have been limited to chatting with friends, distributing flyers at bicycle races and similar sporting events, and placing a few ads on the Internet. Similarly, the owners haven't paid much attention to accounting tasks. Who has time with all the other things that must be done? But at least two things are now clear to the owners: (1) some of their loyal customers prefer to buy items on credit, and (2) all of their suppliers want to be paid on time Right now, BSN's "customer credit system" is a box of 3" x 5" cards. Each handwritten card contains customer information on the front and invoice information on the back (Figure 15-19) When a customer pays an invoice, one of the owners simply crosses off the invoice information on # 1234 Dan Donaldson 123 Maple Drive, New City, Virginia 02345 home phone (435) 765-6154 work:? Invoice # Date Amount 056 235. 33 (232) 122-9843 Visa card #: 1234-4456-S432-0976 expires:312019 (A) The front of a 3x5 BSN customer card. (B) The back of a 3x5 BSN customer card. FIGURE 15-19 A customer record for the BSN company

Answer 1