An Accounting Information System: Revenue Cycle, Database and File Structure - Essay Example

The client can either pay through the bank or take the items on credit. He, therefore, makes the indication if he intends to take the goods on credit. The salesperson thus makes a credit note and sends it to the accounts department. The accountant checks the customer’s credit limit before authorizing the credit note and allowing the shipment of the items to the customer. On the other hand, if the customer pays through the bank, the payment is authorized by the accountant and the sales department prepares a delivery note that is used to ship the items.

The actors and processes in the cycle are further illustrated using the following diagrams. Figure 1: Context diagram Figure 2: Level 0 Data Flow Diagram Figure 3: Document Flowchart. 4.0 Database and file structure The database is created using the Access application. The database stores records of books, records of customers, and records of purchase orders made by the customers. These records are stored in tables that form the basis for the database. The screenshots for the database are shown below: Books Customers Purchase Orders 5.

0 Screens and Reports The screens are necessary for easy entry and retrieval of information to and from the database. The screens provide an interface for the users of the database to interact with the database more efficiently and conveniently. The various screens are shown below Customer entry screen: Purchase order entry screen Inventory Reports Books Reports Customer reports Purchase Orders Reports