Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 9.7
9-18. This problem requires students to create a report similar to the one in Figure 9-8. The
resultant report should look like this:
and last customer in their reports.
9-19. This problem requires students to use their Customers Table and the Report Wizard
to create a report similar to the one in Figure 9-15. Instructors should note that this requires
SM 9.8
Case Analyses
9-20. A Form for BSN Suppliers (Creating a Simple Form in Access)
a. This case requires students to create a simple form in Microsoft Access, using data that they
Additional requirements of this case are:
c. Adjust the Tab Order to ensure that the user tabs sequentially through the fields in logical
sequence.
d. Use the form to add a new vendor record to the Vendors table, including their own name as
the Contact Person.
f. Suggest some additional improvements for this form. Possibilities include:
Adding a default value for the City or State
Adding a mask for the phone and/or fax numbers
Putting the Zip code on a separate line of the form
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 9.9
9-21. A Form and a SubForm for the BSN Suppliers (Creating Forms with Subforms)
a. This problem is mostly a continuation of Case 9-20. It requires students to create a form
similar to the one above, and then use the subform control in the ToolBox to create a
Additional requirements of this problem include:
d. Creating a new purchase order for the current Vendor in the subform.
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 9.10
9-22. A Listing of BSN Suppliers (Creating Simple Reports in Access)
9-23. Furry Friends Foundation III (Creating Forms and Reports)
1. This is a continuation of Cases 8-19 and 8-20 in Chapter 8. If you have assigned these cases,
2. This exercise requires students to create a Contributor Intake Form in two columns and then
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 9.11
3. This exercise requires students to create a Donation Intake Form in two columns and then
4. The requirements for this portion of the assignment requires students to create a list of
can be met by choosing the appropriate selections in the Report Wizard. Below is a sample
of the report.
5. For this part of the case, students must add at least 10 contributors to the Contributors Table
and include donations from them in the Donations Table. They should use the report they
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 9.12