1. 0Introduction In today’s business environment, even small and mid-sized businesses have come to rely on computerized inventory management systems. Certainly, there are plenty of small retail outlets, manufacturers, and other businesses that continue to rely on manual means of inventory tracking. Indeed, for some small businesses, like convenience stores, shoe stores, or nurseries, purchase of an electronic inventory tracking system might constitute a wasteful use of financial resources.
But for other firms operating in industries that feature high volume turnover of raw materials and/or finished products, computerized tracking systems have emerged as a key component of business strategies aimed at increasing productivity and maintaining competitiveness. Moreover, the recent development of powerful computer programs capable of addressing a wide variety of record keeping needs—including inventory management—in one integrated system have also contributed to the growing popularity of electronic inventory control options.
Information system are collection of procedures, program, equipments methods that process data of make it useful to management for decision-making. The term Information Systems refers to the interaction between algorithmic processes and technology. This interaction can occur within or across organizational boundaries. An information system is not only the technology an organization uses, but also the way in which the organizations interact with the technology and the way in which the technology works with the organization’s business processes.
Information systems are distinct from information technology (IT) in that an information system has an information technology component that interacts with the processes components. Methodical procedure or process, used as a delivery mechanism for providing specific goods or services to customers in a well defined market. Also called a company, enterprise or firm, it is a legally recognized organization designed to provide goods and/or services to consumers. Businesses are predominant in capitalist economies, most being privately owned and formed to earn profit that will increase the wealth of its owners and grow the business itself.
The owners and operators of a business have as one of their main objectives the receipt or generations of a financial return in exchange for work and acceptance of risk. Notable exceptions include cooperative enterprises and state-owned enterprises. Businesses can also be formed not-for-profit or be state-owned. 1. 1Background of the Study In today’s globalized and integrated economy, intense competition necessitates faster demand for goods and products, and manufacturers and producers cannot afford to stock more inventory than necessary.
An inventory-control system (mostly automated or computerized) helps producers, warehouse owners and stockman to better manage inventory and control overhead expenses. It ensures that just enough inventories are kept in stock. A computerized inventory system monitors inventory level at all times and issues pay orders to suppliers and other business partners as required. Way back October 25, 2006, a business with the trade name of Double A Store was established. It was owned and managed by Mrs. Haidee Abel and her husband Mr. Julieto Abel. They started the business with a capital of P300,000.
The store is located at Anilao Proper, Mabini, Batangas. The store has 15 local suppliers. Her store contain groceries, canned goods, rice, drinks, alcoholic beverages, snacks, cosmetics, gas tanks, shampoos, soap, beauty products, school supplies, and other things that are needed in everyday use that are monitored daily. But due to the large quantity of these products, they still experience out-of-stocking of the products. Thus, resulting inconvenience for the customers. And they are still looking for a solution to avoid problems such as out of stocking, over stocking, under stocking, fast and slow moving items,
With the help of her employees namely Marie Calderon, the saleslady, Rico Ilao and Elezer Dimaala, the two delivery boys, Mrs. Abel is earning much from her monthly profit. They work together to make the business gain profit. In the present time, her business is earning good income, and will continue to grow in the future time. 1. 2Statement of the Problem How to design and develop a Computerized Sales and Inventory System for the Double A Store that will effectively and efficiently provide current information of the product flow to avoid overstocking, under stocking and out of stock; and well-timed reports? . 3Objective of the study 1. 3. 1General Objective This study aims to design and develop a Computerized Sales and Inventory System for the Double A Store that will provide current information of the product flow to avoid overstocking, under stocking and out of stock; and well-timed reports. 1. 3. 2Specific Objectives •To design and develop a module that accurately monitors the status of the stocks. The user will be provided with a module that will give information about the current state of the products through the product maintenance. To design and develop a module that will monitor products under the critical level. The system will show products that are in the critical level through alert message to inform the user. It will be found on the module containing the list of all the product under critical level. •To design and develop a module that will monitor the products that are fast and slow moving. The user will be provided with a module that will monitor the fast and slow moving product. •To design and develop a module that will provide accurate and well-timed reports.
The system has a report module that will provide the user the reports such as the product master list report, sales report, reorder product report, stock adjustment report, purchase report and delivery report for the owner to have a better monitoring of his products. 1. 4Significance of the Study 1. 4. 1Business The system will give the business an advantage against other business competitors. It will provide a big help in controlling and monitoring the inventories of the company. Thus, the company will be given a better and easier way of record keeping especially in inventory management.
With this system, the company will surpass other competitors in the area of inventory management. 1. 4. 2Owner The computerized sales and inventory system will be very helpful to the manager in finding the record of their products. Accurate information through easier control of management and several inventory reports will be provided to them by the proposed system, thus giving them a solution regarding inventory, if difficulties occur. 1. 4. 3Employee The employees will have benefits because this system will help them lessen their work.
They will immediately know if the items are out of stock, thus giving an immediate response to every inquiry proposed by the customers. They can do their job easily within a short time, instead of consuming a lot of time searching for the availability of a product needed by a customer. 1. 4. 4Customers Customers will benefit from this study for it will provide them fast service especially when they are inquiring for the availability and cost of a certain item. Transactions will be easier and faster because the employees will no longer need to use a lot of time looking for the products and their price. . 4. 5Proponents The proponents will benefit greatly from this project for they will be able to produce a computerized sales and inventory system that will serve as a proof of their untiring effort to improve whatever they have learned from STI. This study will help us sharpen our skills and widen our knowledge in the field of programming. It will give us ideas and insights of what we are about to face when we come out to the real world. And this thesis will give us an edge over our counterparts when we are looking for jobs in the near future. 1. 4. 6Future Researchers
Future researchers on the same field who are going to develop case studies or thesis about inventory systems can use the proposed system as well as the program code as their reference. This project will give them ideas and will serve as a guide that will help them to start their own project. 1. 4. 7School The school will gain benefits from this project because if the system works accurately and is proven effective, the school will gain good comments from people in terms of their way of teaching students. And most likely, many students will be encouraged to enrol and study in STI. 1. Scope and limitation This study mainly focuses on the development of the Computerized Sales and Inventory Control System for Double A Store. Microsoft Visual Basic 6. 0 will be used for the main system development and Microsoft Office Access as database of the system. 1. 5. 1Scope 1. 5. 1. 1 File Maintenance Module This module will enable the user to maintain the list of all suppliers, users and products. 1. 5. 1. 1. 1 User Maintenance This module will be used to maintain the list of the users of the system. It contains module to use and operate. The users are: the owner/manager who has full ccess of functionalities of the system, the cashier wherein she is limited only to access the system that involves sale transaction and the sales representatives that have only access to product inquiry module. 1. 5. 1. 1. 2 Supplier Maintenance This module will be used in adding new supplier or removing/editing old supplier. 1. 5. 1. 1. 3 Product Maintenance This module contains product code, product description, original price, selling price, available quantity and reorder point (ROP = (average daily sales * lead time)This module will be used in adding, removing, editing new and old products available in the store. . 5. 1. 2Transaction Module It contains all the transaction the company is dealing with. They are as follows: 1. 5. 1. 2. 1Sales This is used to transact sales with customers like saving transaction, making a new transaction and printing transaction. It is used in computing amount due by the customer and give an official receipt after operation is done. 1. 5. 1. 2. 2Purchase Order This is a module that will make a list of products that need to be restocked in the store. This makes it easier for the user to track the items that needs to be ordered at any given time. 1. 5. 1. 2. 3 Products Delivery
This module is developed to handle incoming deliveries from suppliers. It includes date of delivery, the products delivered, supplier name, quantity and net price. It will be used to update the products information after the products have been delivered. 1. 5. 1. 2. 4Stock Adjustment It is used to handle products that are damaged in the company, the products returned by the customer to the company and the company to the supplier. The product return is categorized into defective, return with damaged, returned without damaged for example wrong size and others. 1. 5. 1. 3Reports Module This module will provide a hard copy of a particular list. . 5. 1. 3. 1Product Master List It is a list of all the products of the company. It will contain different products offered by the company. 1. 5. 1. 3. 2Sales Report It will show the list of all items that were sold to the customers that will be deducted to the quantity available products. It can be generated in daily, weekly and monthly sales report. 1. 5. 1. 3. 3Critical/Reorder This is the list of items or products monitored by the system below or at par with its reorder point. It can be generated on a daily and weekly basis but the decision to reorder still depends on the decision of the store owner. . 5. 1. 3. 4Purchase Order Report It is a list of all purchase orders made by the store. It will be per supplier basis. 1. 5. 1. 3. 5Stock Adjustment Reports It is a list of all items returned by the customers to the company and by the company to the supplier. It can be printed on a daily, weekly and monthly summary of returned items but still depends on the manager when he wants to return those products to the corresponding supplier. 1. 5. 1. 3. 6Inventory Report It contains products information about the difference between the physical counting and the current inventory in the system. 1. 5. 1. 3. Delivery Report It contains all the information about the product that has been delivered in the store. 1. 5. 1. 3. 8Official Receipt It is given to the customer after the transaction has been process. 1. 5. 1. 4Utilities Module The proposed system will provide a utility module wherein the company will have a back-up database, restore the database, archive and audit trail capability. 1. 5. 1. 4. 1Back-up This creates backup for database files to be able to support recovery. 1. 5. 1. 4. 2Restore This retrieves the database that has been backed up whenever the database has been damaged. 1. 5. 1. 5 Help Module
This system provides information about the system, how it works, and who made it. 1. 5. 1. 5. 1How the system works This contains all information about the proposed system. 1. 5. 1. 5. 2About the Programmer This provides information about the proponents, the people who made the system. 1. 5. 2 Limitations The system does not include touch screens and bar code readers because it needs a very high operational cost during implementation. Accounts payable are not included since the company pays their supplier in full payment. Accounts receivable is not also included since the company only operate retail transactions. . 0Methodology of the study Methodology refers to more than a simple set of methods; rather it refers to the rationale and the philosophical assumptions that underlie a particular study relative to the scientific method. This is why scholarly literature often includes a section on the methodology of the researchers. This section does more than outline the researchers’ methods (as in, “We conducted a survey of 100 people over a two-week period and subjected the results to statistical analysis”, etc. ); it might explain what the researchers’ ontological or epistemological views are.
Another key usage for methodology does not refer to research or to the specific analysis techniques. This often refers to anything and everything that can be encapsulated for a discipline or a series of processes, activities and tasks. Examples of this are found in software development, project management and business process fields. This use of the term is typified by the outline who, what, where, when, and why. In the documentation of the processes that make up the discipline, which is being supported by “this” methodology, that is where we would find the “methods” or processes.
The processes themselves are only part of the methodology along with the identification and usage of the standards, policies, rules, etc. System Development Life Cycle The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Documentation is crucial regardless of the type of model chosen or devised for any application, and is usually done in parallel with the development process.
Some methods work better for specific types of projects, but in the final analysis, the most important factor for the success of a project may be how closely particular plan was followed. System Development life Cycle Planning Develops a project management plan and other planning documents provide the basis for acquiring the resources needed to achieve a solution. Analysis Analysis user needs and develops user requirements create a detailed functional requirements document. Design Transform detailed requirements into complete detailed System Design Document focuses on how to deliver the required functionality.
Implementation This includes implementation preparation, implementation of the system into a production environment, and resolution of problems identified in the integration and test phases. Maintenance Describes task to operate and maintain information system in a projection environment include Post-Implementation and in Process Reviews. 3. 0 Data Gathering Procedures and Outputs Research Systematic investigative process employed to increase or revise current knowledge by discovering new facts.
It is divided into two general categories: (1) Basic research is inquiry aimed at increasing scientific knowledge, and (2) Applied research is effort aimed at using basic research for solving problems or developing new processes, products or techniques. [http://www. businessdictionary. com/definition/research. html] The proponents conducted a research in the school library to gather additional information for the proposed project. They read books and other finished thesis as a reference to complete their study. The proponents also did internet research during the time if their study.
This helped them to obtain additional information related to the field of study. Interview An interview is a mutual sight or view; a meeting face to face; usually, a formal or official meeting for consultation; a conference; as, the secretary had an interview with the President. It is a conservation, or questioning, for the purpose of eliciting information for publication; the published statement so elicited. To have an interview with; to question or converse with, especially for the purpose of obtaining information for publication. [http://www. brainyquote. om/words/in/interview180085. html] The proponents conducted an interview that was held on June 30, 2010 in Double A Store. This step gave them enough information and important details about the business. Survey Statistical surveys are used to collect quantitative information about items in a population. A survey may focus on opinions or factual information depending on its purpose, and many surveys involve administering questions to individuals. When the questions are administered by a researcher, the survey is called a structured interview or a researcher-administered survey.
When the questions are administered by the respondent, the survey is referred to as a questionnaire or a self-administered survey. [http://en. wikipedia. org/wiki/Statistical_survey] The proponents prepared survey questions and distributed them to random customers of Double A Store to determine the customers’ opinion about the business. 4. 0Documentation of the current system The current inventory system of Double A Store uses log book and is done manually. This contains the list of each transaction form the supplier and then their sales.
The owner, the same time the manager, did the job and by the help also of the cashier. The cashier records the amount of the daily sales and then that’s what the owner/manager gathers together. As of now they have 15 suppliers where they order their products through phone, or in some cases the agent of the supplier visits the store to ask for their orders and delivers it during that day or wait for the day of delivery. And their payment is usually through check. In attending the customer, the customer ask for the product and the sales lady look in that product if they don’t find it any in the shelves they go o the stockroom and look if there are stocks, this takes so much time to attend to the customer only asking for the product. If the product is available, and then the customer will decided to avail it, if yes then the sales lady will get the product and ask if there’s any other product that the customer need. After this, the sales lady will list the product in a receipt and then calculate how much all of it cost and then give the total amount to the customer. The sales lady now will go to the cashier to give the payment and get the change if there is.
While on the other hand the helper is packing the products that the customer avails. •Hardware Set Up The concept of Hardware Resources (HR) includes all physical devices and material used in information processing. Especially it includes not only machines, such as computer and other equipment, but also called media. That is, all tangible objects on which date is recorded, from sheets of papers to magnetic disks. The current system of Double A Store did not use any computer on their daily operation. •Software Application being Used The concept of Software Resources includes all sets of information processing instructions.
This generic concept of software includes not only the sets of operating instruction called programs, which direct and control computer hardware, but also the sets of information processing information needed by people, called procedures. •Personnel ?Manager oSigns important documents need by the business oSupervise and manage the overall performance of the staff ?Cashier oThey are responsible for collecting the payment. ?Sales Lady oResponsible for attending the customer’s needs. oIn charge of checking items delivered by the supplier. ?Helper oThe one who check the product in the stock room. Also act as the baggers and delivery boy 5. 0Software/Project Estimation 5. 1Schedule of activities 5. 1. 1 Gantt Chart of Activities ActivitiesRoxanneJesusRene Boy Letter for interviews Survey Question Interview Question Title Pages 1. 0 Introduction 1. 1Background of the study 1. 2 Statement of the problem 1. 3Objective of the study 1. 3. 1General objective 1. 3. 2Specific Objective 1. 4 Significance of the study 1. 5 Scope and limitation 2. 0 Methodology 3. 0 Data Gathering Procedure 4. 0 Documentation of the current system 5. 0 Software/Product estimation 5. 1 Schedule of activities 5. Cost estimation 6. 0 Requirement analysis specification 6. 1 Process specification/modeling 6. 2 Data specification/Modeling 7. 0 Software Design Specification 7. 1 Process Specification 7. 2 Data Specification 7. 3 Screen/Interface Specification 7. 4 Program/Module Specification 8. 0 Software Implementation 8. 1 Programming Consideration, Issues, and tools 8. 2 System requirements Specification 8. 2. 1 Hardware Requirements 8. 2. 2 Software requirements 8. 2. 3 Human resources requirements 5. 2 Cost Estimation 5. 2. 1 Hardware Hardware PartsCost Estimation Motherboard (ASUS M2N-MX SE Motherboard
Support AMD Socket AM2 CPU, NVIDIA GeForce 6100 + nForce 430, Integrated GeForce6 GPU -PCI Express architecture, PCI Express architecture. 100/10 LAN. DDR2 800, 2*SATA 300MB/s RAID 0,RAID 1 and JOB.. AMD Live! ™ Ready) P 2,790. 00 HDD (Seagate 160GB ST3160811AS SATA Barracuda 7200. 9 SATA 160-GB Hard Drive, 8MB Cache, 3. 5″ for Desktops) P 1,990. 00 CD ROM (Samsung CD-RW/DVD Combo Drive CD write 52X/Rewrite 32X/CD Read 52X, DVD Read 16X, CD-Multi-Read Support) P1,250. 00 Keyboard (A4Tech KBS-720 A-Shape A-Shape Nature Keyboard has increased typing speed unlike in any other keyboard.
The Anti-RSI feature is an excellent design; very comfortable to hands. Ultra-Slim Profile Reducing Typing Noises,Ideal for Fast Typing. Patent Ergo A4Tech Exclusive A-Shape Key Layout prevents Repetitive Strain Injury from your wrists and arms. ) P 300. 00 Optical Mouse (A4Tech K4-3D 16-in-1 Mouse A4Tech exclusive quick access “2X” button can be customized to have up to 16 functions at the same time,such as “Zoom In and Out, Scroll Left and Right, Copy, Paste, Back, Forward, etc… ” – all at your fingertip) P 350. 00 Monitor (LG T710SH 17in Flatron CRT Monitor
CRT Size: 17″ Real Flat FLATRON, Size: 1280 x 1024 Resolution, Display Type: RGB Analog, Pitch Size: 15 Pin D-Sub) P 3,500. 00 Printer (Epson L X 300 + Dot Matrix Printer) P 8,600. 00 Video Card (Palit GF 210 512MB GeForce G Series PCI-E 512MB DDR2 VRam, 64Bit, 589MHz Core / 800MHz Memory, 16 SP Pixel Pipeline, GT 218 Chipset with VGA, DVI, HDMI port. The latest 40nm technology, NVIDIA unified architecture, NVIDIA CUDA Parallel Computing Architecture. it Supports Microsoft Windows 7, DirectCompute, OpenCL, NVIDIA PureVideo HD technology, High Definition 1080p Display, Dual-link HDCP capable, PCI Express 2. support, Microsoft DirectX 10. 1, Shader Model 4. 1, OpenGL 3. 2. ) P 1,990. 00 Memory (Apacer 1GB DDR2 – 800 Long DIMM JEDEC Standard. The Apacer Module is DDR2-800 CL6 ECC Unbuffered Memory module. The Module density is 1GB, it consists 64/128MX8 bit DDR2-800 Synchronous DRAMs in FBGA packages, Memory Module intented for mounting into 240-pin edge connector sockets) P1,195. 00 Total P21. 965. 00 5. 2. 2 Software The operating system of the PC to be use must be Windows XP. The programming language used is Microsoft Visual Basic (VB).
It is the third generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model. It also used Microsoft Access which is a relational Database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. 6. 0Requirements Analysis Specification 6. 1Process Specification/Modeling Product Inquiry (Current System) Sales Transaction(Current System) Purchase Order(Current System) Delivery of the Product(Current System) Data Specification/Modeling ?DFD of the Current Product Inquiry 1.
Customer inquires the product information to sales lady. 2. The sales lady will find the product information to shelves/stockroom 3. The sales lady will now give the product information to customer. ?DFD of the Current Supplier’s Delivery 1. The supplier’s agents delivers the ordered product. 2. The saleslady will physically count the items delivered and check for any damaged products. 3. The cashier will give their payment through check. 4. The supplier’s agents will then issue the delivery receipt. ?DFD of the Current Sales Transaction 1. Customer orders product to the saleslady. 2. The saleslady will look for the product’s availability. . Ordered product will be acquired from the stock room/shelves. 4. Then the ordered product will be given to the customer. 5. The customer will give the payment to the cashier. 6. Official receipt will be issued to the customer along with the change if there’s any. ?DFD of the Current Purchase Order to Supplier 1. The Manager/owner will obtain stock status from the stock room/shelves. 2. Then the manager will prepare the purchase order list. 3. The purchase order list will be given to the supplier. 7. 0 Software Design Specification 7. 1 Process Specification DFD Process Inquiry (Proposed System) Figure 7-1
FD of Sales Transaction (Proposed System) Figure 7-2 DFD of Product Delivery (Proposed System) Figure 7. 3 DFD of Purchase to Supplier (Proposed System) Figure 7-4 7. 1 Data specification ?DFD of the Proposed Product Inquiry 4. Customer inquires the product information to sales lady. 5. The sales lady will find the product maintenance form type the product to be find and search for it. 6. The sales lady will now give the product information to customer. ?DFD of the Proposed Supplier’s Delivery 5. The supplier’s agents delivers the ordered product. 6. The saleslady will physically count the items delivered and check for any damaged products. . The cashier will update the system after counting the products. 8. The cashier will give their payment through check. 9. The supplier’s agents will then issue the delivery receipt. ?DFD of the Proposed Sales Transaction 1. Customer orders product to the saleslady. 2. The saleslady will look for the product’s availability. 3. Ordered product will be acquired from the sales form. 4. Then the ordered product will be given to the customer. 5. The customer will give the payment to the cashier. 6. Official receipt will be issued to the customer along with the change if there’s any. ?DFD of the Proposed Purchase Order . The Manager/owner will obtain stock status from the stock status table. 2. Then the manager will prepare the purchase order list. The purchase order list will be given to the supplier. 7. 2Screen/Interface Specification LOG –IN FORM MAIN FORM PRODUCT MAINTENANCE SUPPLIER MAINTENANCE USER MAINTENANCE SALES TRANSACTION PURCHASE ORDER PURCHASE DELIVERY STOCK ADJUSTMENT HOW TO GENERATE MASTER LIST REPORT HOW TO GENERATE REORDER POINT LIST REPORT HOW TO GENERATE PURCHASE ORDER REPORT HOW TO GENERATE SALES REPORT HOW TO GENERATE DELIVERY REPORT HELP BACK UP RESTORE STOCK ADJUSTMENT REPORT
REORDER LIST REPORT MASTER LIST REPORT SALES REPORT INVENTORY REPORT OFFICIAL RECEIPT 8. 0Software implementation 8. 1 Programming Considerations, issues and tools With these proposed “Computerized Sales and Inventory System” , the proponents consider the following: The total cost of estimation of the hardware requirements is Php 21,965. 00,the consider the minimum system requirement of the actual computer unit and peripherals used in this projects. For the software requirements, the operating system of the PC to be use must be Windows XP. The programming language used is Microsoft Visual Basic (VB).
It also used Microsoft Access which is relational database management system from Microsoft. And last, for human resources requirements, we consider those people who are skilled, expert and related to the study. 8. 2System requirements 8. 2. 1Hardware Requirement To efficiently use this system the following computer specification should be satisfied: Processor: Pentium 4 or higher Memory: 128Mb or higher File System: 32 bit Monitor: 15” monitor Hard Disk: 40 Gb Mouse: Optical mouse Keyboard: Any Windows XP compatible keyboard 8. 2. 2Software Requirements The following software has been used by the proponents to develop and design this system:
Visual Basic 6. 0 Visual Basic (VB) is the third generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model. VB is also considered a relatively easy to learn and use programming language, because of its graphical development features and BASIC heritage. Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to database using Data Assess Objects (DAO), Remote Data Objects (RDO), or ActiveX Data Objects (ADO) and creation of ActiveX controls and subjects.
Scripting languages such as VBA and VBScript are syntactically similar to Visual Basic, but perform differently. Like the BASIC programming language, Visual Basic was designed to be easy to learn and use. The language not only allows programmers to create simple GUI applications, but can also develop complex applications. Programming in VB is a combination of visually arranging components or controls on a form, specifying attributes and actions of those components, and writing additional lines of code for more functionality.
Since the default attributes and attributes and actions are defined for the components, a simple program can be created without the programmer having to write many lines of code. Performance problems were experienced by earlier versions, but with faster computers and native code compilation this has become less of an issue. [WIKI2010] Microsoft Access Microsoft Office Access, prevously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Databse Engine whit a graphical user interface and software development tools.
It is a member of 2007 Microsoft Office System. Access can use the data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container (including MySQL and PostgreSQL). Software developers and data architects can use it to develop application software and non-programmer “power users” can use it to build simple applications. It supports some object-oriented techniques but falls short of being a fully object-oriented development tool. Microsoft Access is part of the Microsoft Office suite and is the most popular Windows desktop database application. [WIKI2010]. . 2. 3Human Resource Requirements 8. 3Software Testing 8. 3. 1Testing activities Testing is one of the important activities in a system. This enables to eliminate errors from the programs and to eliminate errors from the programs and to achieve the integrity, accuracy, and reliability of the system. The proponents are assigned to test or check their specific modules to determine its functionalities. These modules are: File maintenance, transaction, report generation, and inquiry. Results to the test in these modules will reflect the function of the system as a whole. 8. 3. 2Test Cases
The proponents determine whether an application or software system is working correctly or not. 8. 4Installation Process Installation process can only be done if all the issues and tests were solved and passed respectively. After the system is installed and becomes part of the business’s activity, the system administrator is largely responsible in monitoring the whole system analyst or a programmer if problems exist. After having been concluded that the system achieved its effectiveness, the new system was then carefully installed using system installer, who is in the form of executable file, plans how you are going to install. Appendices