Information System Development Project

Application of Business Processes and Embedded Controls
Scope:
This is an individual project that requires the development of an event- driven IT
application prototype for a business process for your chosen company ( Any company of your choice). The
project will conclude in a demonstration of your working database.
The objective of the project is to:
o Apply the cumulative instruction provided in this course to a final project that
integrates your understanding of the course material and the database
management skills presented throughout the semester.
o Increase understanding of how technology affects organizations, and the varying
information needs of different industries; and
o Increase understanding of how the use of technology and the knowledge of
business processes can help accounting professionals produce and deliver more
valuable information.
Organization of the Project:
You will be assigned the responsibility of creating an event-driven information
system for a business you have chosen. You should make sure that your business
process incorporates some of the unique information aspects of the industry you
have studied (e.g., for the health care industry - patient management).

STEPS OF THE PROJECT:
I would like for you to create the AIS database for your company’s
partial sales/collection cycle. Use the following steps to work through completing your database:

1. In MS Word, create the Logical model for your company from the REA model given for this
   project (see REA model in screenshot). Make sure the names of your table and the attributes of the
   tables are customized to your company. (Do not use “Item# or “Sales Clerk” primary key names
   – be creative and have the names fit your industry. Example: “furniture#” for primary key of
   inventory for a furniture store, “Barista” used by Starbucks for their sales clerk). Also collect
   data via non key attributes on your customers which fit the needs of your industry.
2. In MS Access, create all tables, complete with required attributes;
   primary keys, foreign keys, and non-key attributes for each of the business events
   (including resources, agents) from your the Logical model created in Step 1.
3. In MS Access, insert real-time information risk controls. Your new tables should have the
   following internal controls implemented (see Controls lab)
   • the Now Date for the Date field in your operating event tables
   • Auto number as the data type for the primary key for your Operating event table (see
   video about Autonumber in Course Resources for system project folder)
   • Use input masks for the Zip Code, SS#, State abbreviation, and phone number ***
   tables containing these non-key attributes
   • in your operating event form, for quantity, limit the number of items ordered as reasonable
   for your company and industry (ex: 5 bikes, 200 balloons, etc)
4. In MS Access, be sure to establish Referential Integrity (tables lab)
5. Fill in data to your Master tables (not Transaction tables) with a minimum of 10 records for
   each table.
6. (Access) Complete your database.
   o Create one form for the operating event to record a new instance of that event
   (see Forms Lab)
   o Create a main menu to be shown when your database opens (Controls Lab)
   o A submenu form for your operating event. These menu and submenu forms
   will help organize your system and allow access restrictions by making them password ***
   protected. A user of your system must be able to access all forms and reports using
   menus and not the database objects window. (Controls lab)
   o Test the accuracy of your prototype. This will require you to use your operating event
   forms to add new records to each operating event table. There should be a minimum
   of 10 operating events for each operating event table created (this means you
   filled in the sales form 10 times).

prevent anyone from opening your database without a password ***
o Hide the navigation pane from users (Controls lab).
o Create a minimum of two reports. Required Reports are:
? Sales by Customer Report (Query lab)
? EQOH Report listing EQOH by total number of items and total dollar
amount of items (EQOH = Ending Inventory in US Dollars)(Query lab)
o Add custom logos, color, graphics, design to your database