Wednesday, October 30, 2019

American Economy Term Paper Example | Topics and Well Written Essays - 500 words

American Economy - Term Paper Example There are various ethical frameworks promulgated over the year. These different frameworks can be used as tools to determine which action is right and which is wrong. There are various ethical frameworks and models such as Unitarianism, Justice and Deontology. Utilitarianism framework ask that those actions are considered as right which render more good to the society, and benefits accrued from them are higher than cost of those actions. Many laws and restrictions imposed by the USA and other super powers are for their own benefits. The benefit is directly accrued to them, whereas the costs have to be borne by the entire society. This means that their actions cannot be justified and are ethically wrong. For example, the current ongoing war on terrorism is one example. The USA started the war after it became a victim of terrorism. It waged war against Afghanistan first, and then went out on hunt in Iraq. However, these actions yielded nothing. Osama was not to be found and he wasn't. However, the war on terrorism killed thousands of innocent people, destroyed millions of dollars worth of infrastructure and started the stream of terrorist attacks all around the world. It can be safely concluded that this war did more damage and was futile.

Monday, October 28, 2019

What Makes Up Marine Ecosystems Environmental Sciences Essay

What Makes Up Marine Ecosystems Environmental Sciences Essay An ecosystem can be defined as an area where there is an interaction between all the non-living and living components. The complete group of organisms inhabiting the ecosystem can be called a community. The abiotic non-living components include such items as air, water, soil sunlight all of which may be critical to the survival of the organisms (Soper et al 1997). Odum (1969) described the ecosystem as a single entity composed of many different parts dynamically interacting with transfers of energy and considers the ecosystem to be a unit of biological organization made up of all the organisms in a given area (that is community) interacting with the physical environment so that a flow of energy leads to characteristic trophic structure and material cycles within the system. This more elaborate explanation is still applied today and is more relevant as it takes into account the important issue of energy flow between the components. Marine ecosystems include oceans, coral reefs, estuar ies and coastal areas such as lagoons and kelp beds. An appreciation of the fundamental definition described above allows us to understand how the ecosystem concept can be extrapolated from smaller marine ecosystems such as coral reefs or sea grass beds to bigger ones such as the Caribbean Large Marin Ecosystem (CLME) which is an interconnected complex of these and many other smaller ecosystems. Duda (2002) describes the large marine ecosystem (LME) as a vast marine area which begins with and includes coastal regions and estuaries and eventually stretches out to continental shelf limits and areas dominated by coastal current systems. Sherman et al (2004) use the following more detailed factors to develop criteria for demarcating LMEs ; bathymetry, hydrography, productivity, and trophically dependent populations. Several of the 64 LMEs spread out across the globe also occupy spaces which are semi-enclosed seas for example the Caribbean and Baltic seas are two semi enclosed seas which form the respective CLME and Baltic Sea LME (BSLME). Another factor used in determining the seaward extent of LMEs is the area affected by the major ocean currents of the world, hence, for example the North Brazil Shelf LME (NBSLME) is delimited by the North Brazil Current system and its extent. This factor therefore sometimes supercedes the 200 nautical mile of EEZ fisheries zone limits criteria. The understanding of the concept of the LME is fundamental to this study as the area of interest transcends the boundary between two adjacent LMEs namely the CLME and the NBSLME (see figure 1.) (Polygon delimiting actual study area needs to be inserted on this diagram) Figure 1. The Caribbean and adjacent Large Marine Ecosystems. (Fanning et al. 2009) Resources and Ecosystems Seagrass, coral reefs and mangroves are very common marine coastal ecosystems within the CLME. The outflows of two of the largest river systems in the world, the Orinoco and the Amazon have a great impact the LME of the Caribbean (CLME, 2007)., the former having the greater effect due to its closer proximity, approximately 100 km from the south coast of the island of Trinidad. The North Equatorial Current moves in a generally westward direction from the mid Atlantic region into the Caribbean basin through the Lesser Antilles and thus many of the islands within this area are impacted by its nutrient poor nature (see fig 2). The islands of the South Eastern Caribbean however, especially the twin island nation of Trinidad and Tobago are heavily impacted by the Guiana Current which enters the Caribbean along the northern coast of South America (fig 3). It has been stated that the freshwater outflows from the Amazon and Orinoco has a significant impact on the Guiana current (Morrison and Smith 1990). Muller-Karger et al. (1988) illsutrate that the Amazon River discharges the most amount of freshwater into the ocean from any single point source. The North Equatorial Current (NEC) as represented by the Mariano Global Surface Velocity Analysis (MGSVA). The NEC is the broad westward flow that is the southern component of the N. Atlantic subtropical gyre. It is fed by the Canary Current and its waters eventually end up in the Gulf Stream system, either via the Antilles current or through the Caribbean via the Guiana current. (Bischof et al. 2004) South equatorial current, North Brazil Current and North Brazilian Current are all terms which have been applied to the Guyana current. Flagg et al. (1986) suggest that the misappropriation of the names is due mainly to the seasonal nature of the adjacent currents. The Guyana Current starts off as the North Brazil Current which carries along the south American coastline up to the region of French Guiana where part of it diverges and rejoins the North Equatorial Counter Current. The Guiana Current is formed from the remainder which continues along the coast in a northwestward direction (Condie 1991) The Caribbean current as represented by the Mariano Global Surface Velocity Analysis (MGSVA). The Caribbean Current transports significant amounts of water northwestward through the Caribbean Sea and into the Gulf of Mexico, via the Yucatan Current. The source water for the Caribbean Current is from the equatorial Atlantic Ocean via the North Equatorial, North Brazil, and Guiana Currents. The counter-clockwise circulation of the Columbia-Panama Gyre is evident off-shore of southern Central America (Nicaragua, Costa Rica, and Panama) and northern Colombia. (Gyory et al. 2004) (Gyory et al. 2004) The Caribbean exhibits a great degree of spatial and temporal differences when it comes to its marine environment. Coral reefs are a prime example of the diversity of its ecosystems and its species as most of the corals and associated species found in the region are endemic making this biodiversity of international importance (Burke and Maidens 2004) The interdependence and flow of energy from the nearshore more productive habitats such as the reefs, mangroves and seagrass beds to the less productive open ocean areas such as the planktonic and pelagic systems and the environmental conditions that influence them are not well understood at this point. Why conserve and manage marine ecosystems? The importance of marine ecosystems and hence the need for their sustainable management can be best illustrated by two main factors; the direct and indirect services they provide and the ensuing natural and human based stressors that they face. Marine ecosystem services Humans often view the oceans as a huge waste bin while simultaneously as a perpetual source of food. With five percent of the worlds protein supply coming from the sea and up to 15 percent is selected areas such as China and Japan our dependence on the ocean for food is immense. There is a wide range of services apart from being a food source that humans garner from the oceans, to fully appreciate these one must first come to terms with the varying scales of spatial distribution and time which these services may be provided. Obviously different regions will provide various services due to their different physical makeup and constituents for example near shore coastal ecosystems provide most of the services of a particular type due to their highly productive nature whereas open ocean areas provide most of the regulating services and chemical balancing mainly due to its immense size. The medical, spiritual, aesthetic values of the ocean are also great but often receive lesser attention. Recently much interest has been placed in carbon sequestration and the role of the oceans and marine ecosystems in acting as carbon sinks slowing the global climate change process Garcia and Cochrane (2005) mentions this and categorizes ecosystem services into four main areas; provisioning, supporting, regulating or cultural. The function of coral reefs, mangroves and even salt marshes in buffering coastal areas from wave and storm damage was apparent during the 2004 Asian tsunami and the 2005 Gulf of Mexico Hurricanes. It is well known that coastal habitats such as mangroves, salt marshes, coral reefs, and sea grass beds act as nurseries for young fish and other species while also providing a source of income and employment generation. The fisheries sectors of many a nation is fuelled by the highly productive upwelling zones mainly in and around New Zealand, Chile/Peru, South Afr ica and the western United States. Also in terms of biodiversity 16 of the 36 animal Phyla that exist occur only in the oceans, this fact has implications for the biochemical and medical fields for human use (Baskett et al 2005). Marine ecosystem stressors Most of the worlds population lives in or near to coastal areas for many different reasons. Primarily most of the jobs exist in and around the coastal zone as this is where many of the major cities and ports occur. Also food and recreation and leisure activities are gained quite easily from the seas. As a result of the high population densities experienced by the coastal regions a lot of the significant ecosystems and coastal marine communities are being negatively impacted due to human activities (Halpern et al., 2007, 2008). Pollution of various forms have caused increase nutrient enrichment, eutrophication, sedimentation due to land degradation and mismanagement and changes in the hydrological patterns. Climate ahnge is another signifjicant contributor the the deterioration of the marine ecosystems and have taken a heavy toll on coral reef systems in particular (Baker et al. 2008). GESAMP (2001) lists the modification and demolition of habitats, sewage run off and impacts on human health, rising eutrophication and nutrient enrichment and the decrease in fish stocks as well as alteration of sedimentation pattern due to hydrological changes and land degradation as some of the most significant issues facing coastal and marine areas and ecosystems. How are they Managed? Ecosystem Based Management (EBM) Conventional types of natural resource management have been replaced over the years by a more rounded approach ecosystem based management (EBM) which focuses not only on specific sectors but is more all inclusive. Traditionally, activities that influence the management process have been engaged independently and have not considered the collective impacts on the ecosystem (Curtin and Prezello 2010). EBM is a new approach that considers a broader range of contributing factors (ecological, environmental and anthropogenic) in designing a management technique. Management techniques including coastal management, fisheries management and the designation of marine protected areas (MPAs) help to drive EBM related models. Christie et al. (2007) also stress that ecological function and pertinent scales must be considered in the EBM process. Arkema et al (2006) summarize it most effectively: Ecosystem based management represents a much broader view than how marine ecosystems have been managed tr adition- ally, taking into account the interconnectedness and inter- dependent nature of the components of ecosystems, and the fundamental importance of ecosystem structure and functioning in providing humans with the broad range of services that are taken for granted. Cury et al. (2005) notes three key issues that must be adhered to in EBM; establishing lasting goals that are pertinent to the particular ecosystem, defining meaningful indicators, and determining suitable models, data gathering tools and means for analysis. INDENT (2006) provides an assessment of a wide range of indicators, while mechanisms for marine ecosystem management and monitoring are outlined by Hoffman and Gaines (2008). Biological monitoring makes use of indicator species and also considers numbers of particular species, this is especially useful in fisheries monitoring to detect when a disturbance in a specific area in this regard fisheries monitoring is considered a tool on its own. Tracking variations in the water quality or physical habitat is termed environmental monitoring and is separate from biological and fisheries monitoring. The multitude of stressors which influence the marine environment can have many sources, including estuaries, coastal areas and even far away areas such as watersheds. At the highest level therefore EBM should take into account watershed impacts (Guery et al. 2005). Also from a management perspective it has been suggested that an approach which begins at the lowest scale and then makes its way up to the level of large marine ecosystems thereby allowing a greater number of stressors and the services that they impact to be considered Agardy (2007) and Rosenberg (2006). Sustainable management and application of marine ecosystem services always need to consider the relationship between the socioeconomic and ecological parts of the entire system across the various scales involved. Indicators The fisheries resources within an ecosystem are directly related to the primary productivity of that ecosystem (Pauly and Christensen 1995). The ever increasing problem of coastal eutrophication can be monitored by utilizing ecosystem productivity as an indicator. Ecosystem characteristics can be observed through the use of satellite data. Satellite data that has been tuned to a specific region can provide data on nutrients, productivity, phytoplankton, and sea surface temperature (Aiken et al. 1999; Berman and Sherman 2001; Melrose et al. 2006). The 2004 National Coastal Condition Report II illustrates the use of five indices for coastal assessment put forward by the United States Environmental Protection Agency (USEPA). These include water quality, sediment quality, benthic communities, coastal habitat, and fish tissue contaminants. These indicators and the entire methodology are gradually being applied to the international global environment facility (GEF) funded LME projects. The Gulf of Mexico LME and many European LMEs have suffered due to nitrogen overenrichment over recent decades. The 1970s Green Revolution which saw much of the wetlands of the world being transformed to agricultural lands and the subsequent fertilizer and livestock increase are said to be the major contributors to this process (Howarth et al. 2000 and Duda and El-Ashry 2000) with other contributors coming from urban sewage sources and automobile exhaust. Indicators used for Marine Management The increasing range and intensity of human uses has led to a need for efficient management of marine ecosystems in the region. Marine ecosystem indicators can play a key role in improving the planning and management practices within the marine environment for sustainable use (Borja et al. 2008b; 2009). Indicators enable managers and stakeholders to monitor the condition of an ecosystem and the impacts of its associated human activities. Indicators can also be used to support planning and decision-making for ecosystem-based management, including problem identification and policy implementation. More than a decade ago the chief method employed in assessing marine quality was the use of indicator species collected from the benthic communities. A wider approach is now being undertaken with the inclusion of the physical components as well as a greater range of biological components (Pinto et al., 2009). Fishes, phytoplankton and zooplankton are biological components that are now part of the ecosystem assessment process and are being used as indicators for marine quality evaluation (Borja et al 2009). True marine quality assessment is usually done by incorporating the various physico-chemical and biological elements of the system (Borja, 2005, 2006). Moloney and Shillington (2007) show that it is necessary to have indicators for ecosystem health however, individual indices can be applied for various aspects of the physical and chemical environment. Further work is required for the establishment of an effective method of defining the single indicator for assessment of marine qual ity (Borja et al., 2008a). The past approach had several deficiencies chief of which was it usually was based on just a few indicator organisms which may not have been a true representation of the ecosystem condition. On the other hand developing several indices based on several different organisms has seen a proliferation of indices (Diaz et al., 2004). Another key point to consider is the validation and testing of an index once it has been developed to ensure its accuracy. Obviously the usefulness or applicability of an index lies in its ability to accurately transmit the information about the quality of the study area for which it was designed (see Borja and Dauer, 2008). It is important to note that local scale indices have been generated in abundance in recent times not taking into account the interconnected nature of the larger marine ecosystems. A key step in index development is the multivariate analysis over areas where the ecosystem compositions are close by comparison. Borja et al (2009) have illustrated clearly that stakeholders and decision makers often need information on larger regions that cross habitat boundaries and thus scale is an important factor in index development. Nextà ¢Ã¢â€š ¬Ã‚ ¦.. Indicators for marine management derived from Satellite Remote Sensing

Friday, October 25, 2019

Business :: essays research papers

CHAPTER I INTRODUCTION   Ã‚  Ã‚  Ã‚  Ã‚  This study will examine the overall affect on society, as well as the historical aspect of the integration of African-Americans, into sports in the United States of America. This study is also designed to discuss and or break down any racial stereotypes involving African-American athletes. Most importantly, this study will also examine the progression that African-Americans have made on the field as athletes and in corporate America as well. The overall affect that integration had on society will be discussed first. The acceptance and the scrutiny of the African-American athlete will be examined. Secondly, the researcher will discuss some of the many racial stereotypes that African-American athletes have to live up to or even hold their heads in shame because of. The third and final area of research is to discuss the progression that African-Americans have made in the world of sports during the years after integration.   Ã‚  Ã‚  Ã‚  Ã‚  The majority of the literature for this study was obtained from various websites and written material discussing the aforementioned topics. This study will not be the first of kind, however the information that was discovered is different than previous studies that have been done on this topic. Since the birth of the United States, this society has been capitalistic in nature. The basis of capitalism is competition. The business that is the best will win or make the most money. This is also the true nature of sports as well. Even though sports took on this mentality, it is still leaps and bounds ahead of society when it comes to equality. After- all Jackie Robison was a Brooklyn Dodger five years prior to the Brown vs. Board of Education case in 1954. In many ways sports in America have become a microcosm of what society should be.   Ã‚  Ã‚  Ã‚  Ã‚  Although Jackie Robinson’s barrier breaking entrance into the Major Leagues was probably the most important event to take place in sport history, it is not the first time African-Americans were involved in sports. Early records have shown that African Americans were involved in these sports whenever given the opportunity to participate. On the other hand, American sports are filled with records of African American athletes capable of participating in the broad sports arena but not given the chance due to their race. Therefore, as sports grew into an American popular pastime, it also grew along on separate fields with race as a dividing line.

Thursday, October 24, 2019

The Train Station ( Creative Writing )

It was the cold seemingly endless winter of 1947 in Paris , Latin Quarter. . Sheets of snow put the rest of the district in almost complete obscurity; all but steeples and tall spires were invisible, on such a bleak day as this. The railway station was a vast cavity made to look smaller by the hoards of hagglers, travellers, tourists, natives and locals. Beggar boys being whisked from sight and hidden by wardens with preying eyes and superstition written all over them. The wonderful smell of the patisserie on the opposite side of the benches wafted around.Although it was only a railway station it held a certain grandeur, however it was not so now, for that was it in its former glory. A truly different sight beholds me now,creepers and vines reach upward, like the boney fingers of a witch. Corridors with cracked flagstones out of which weeds protrude and moss lingers. Must hangs in the air. Rust continues to corrode the tracks, graffiti encapsulates and engulfs the far wall. Tattered posters show a glimpse of what used to be of the place. Old newspaper flutters in the wind, floating on a cushion of wind. Alcoves show the remains of where shops used to trade.Like a black and white movie no colour was really visible. Some were,vaguely, but most not. Something strange hung in the air: an almost haunted aura. Only smashed windows provided light. The old wooden sleepers lay decaying, riddled with termites and millipedes. Forty years of decline and decay, decisions made, money paid,much to be gained as restoration is to begin, windows replaced, rusty tracks turned shiny again, wood turned concrete as the sleepers were replaced, graffiti became mosaic tiles, must became fragrance and dull became vibrance, grit became shine, and disused became used and indeed much was regained.

Wednesday, October 23, 2019

Point of Sale and Inventory System

ABSTRACT Title: Point of Sale System for Stone Pro Enterprise Researchers: Serolf, Jham Year : 2013 Course: Computer Science Technology Adviser: CHAPTER 1 THE PROBLEM AND ITS BACKGROUND 1. 1 Introduction Man have come a long way in doing business transactions with each other. From the primitive ways of exchanging goods or â€Å"barter system†, to the more complex â€Å"e-commerce† or doing business transactions with the help of the internet. With technology rapidly changing and upgrading every now and then, companies must adopt to be able to excel in each businesses’ â€Å"cut-throat† competition.Automation of one’s point of sale and inventory system puts you a step ahead in the game. It helps you conduct business transactions with ease as you only have to press a few keys. It liberates you from countless paper works as computation of the day’s sale and keeping track of inventory are done automatically. With these things in mind, we, the Blue Link Technology group , hopes that upon completion of this Proposed Point of Sale and Inventory System, Stone Pro Enterprise will find it of great value and an indispensable asset in the company.That through the use of this System, unnecessary loss of time spent on computation of payments will be minimized and greater client satisfaction will be achieved. On the part of the management, knowing which products are in need of procurement and which are not, will help avoid over stocking and greatly minimize unnecessary expenses. At the end of the day, all transactions will be properly documented and generation of reports will just be a few keystrokes away.Finally, we hope that with the development of the said System, we will be able to help Stone Pro Enterprise become a company more competitive and quality wise, worthy of recognition in the local industry. 1. 2 Background and purpose of the study Most companies nowadays use computers in transacting with their clients. Companies are now making their systems computerized because using a computerized system will help the company minimize the time and efforts consumed by using manual system.Stone Pro Enterprise provide not only cleaning services for your natural stones flooring, but also offer wide variety of floor care supplies and products. A sale refers to the exchange of product or services for an amount of money or its equivalent while Inventory in a business, is a total amount of goods and the act of counting them. A company owner must know the precise number of items in their storage areas in order to place orders and control losses. Computerizing both Sales and Inventory System will make an easier and faster transaction with the customers as well as monitoring the stocks of the products.The benefit of Point of Sale with Inventory system is that this system makes a business much more efficient, lowering the costs of running the business while improving customer service and making the business more pleasant to work in while Computerized inventory system helps management control the inventories, in turn lowering overall operating costs in the areas of labor, facilities and logistics. A computerized inventory system also improves customer-service metrics and fulfillment rates. 1. 3 Theoretical Framework The study is for Stone Pro Enterprise by using â€Å"Visual Basic† that were relatively easy to learn and use.The researchers were able to analyze the speed properties. Analyzing the point of sale design and code; it is important because the study needs to have a quality for the transaction to be accepted and a good imitator of transaction. The study use IPO chart on knowing the output of the study. The input will be a design and code. The input will pass through several process. These are the speed of transaction. 1. 4 Conceptual Framework Figure 1 Research Paradigm Point of Sale System Stone Pro Enterprise 1. 5 Statement of the Problem Stone Pro Enterprise System requires some compu ter literacy on the user part.It's not trivial investment in time or money to set up. If the user doesn't have basic knowledge then the technical requirements of this POS system may baffle him. Ignoring normal practices the this POS system will confound and frustrate each user. The whole idea of this system is for the user to follow the rules, learn accounting terminology and become more disciplined. If this will be practice, then this POS system can bring a tremendous advantages. 1. 6 Hypothesis This study is intended to design and develop a Computerized Point of Sale System for Stone Pro Enterprise 2013. Specifically, this study aims: . To minimize the effort of the staff in in processing the on Stock Inventory 2. To make an efficient and accurate computation of cash Registry 3. To create a well-arranged database and to implement strong security of the system for data security. 1. 7 Significance of the Study To Admin Department The proposed system will help the admin section of St uff the Buss School Supplies. It will help to lessen the time and effort of the payroll maker/bookkeeper preparing payments of employees. The System develop can accommodate changing figures and produce a paperless environment through well design database.To Proponents This study will help the proponents to enhance the ability on how to create an understandable computerized system in an easy way. This will serve to the proponents as a challenge to do a better system. To the other Researcher This study gives knowledge to the researcher on how to create a Computerized System in understandable way. This will serve as a fresh ground for the researcher whose study will be related in the field of Information Technology. 1. 8 Scope and Limitation Scope This study is designed to develop a Computerized Point of Sale System for Stone Pro enterprise.It covers the process of preparing the on stock inventory record, keeping of cash registry records safety and computing the exact daily revenue. Th e proposed computerized Point of Sale System is expected to generate receipts and report list of daily and monthly revenue. Limitation The proposed Computerized Point of Sale System for Stone Pro Enterprise does not support network topology implementation and online program or online transaction. 1. 7 Definition of Terms Point of Sale – or  checkout  is the place where a transaction occurs in exchange for goods or services.The point of sale often refers to the physical electronic cash register or dedicated POS hardware used for checkout, but the POS is simply the location where the sale is conducted, money changes hands and a receipt is given. Transaction –   an agreement, communication, or movement carried out between a buyer and a seller to exchange an asset for payment. Cash Register – is a mechanical or electronic device for calculating and recording sales transactions, and an attached  cash drawer  for storing  cash. The cash register also usual ly prints a  receipt  for the customer.Inventory Control System –   is a process for managing and locating objects or materials. Computer Software –   is a collection of  computer programs  and related  data  that provides the instructions for telling a  computer  what to do and how to do it. Computer Hardware – equals the collection of physical elements that comprise a  computer  system. Computer System – A complete, working  computer. Computer systems will include the computer along with any  software  and  peripheral devices  that are necessary to make the computer function Program – is a sequence of  instructions  written to perform a specified task with a  computer.CHAPTER 2 REVIEW OF THE RELATED LITERATURE 2. 1. Foreign Literature Over the years, more enhancements were made to the cash registers until the early 1970s, when the first computer-driven cash registers were introduced. The first computer-driv en cash registers were basically a mainframe computer packaged as a store controller that could control certain registers. These point of sale systems were the first to commercially utilize client-server technology, peer-to-peer communications, Local Area Network (LAN) backups, and remote initialization.In the late 1980s, retail software based on PC technology began to make its way into mainstream retail businesses. Today, retail point of sale systems are light years ahead of where they began. Today's POS systems are faster, more secure, and more reliable than their predecessors, and allow retailers to operate every facet of their business with a single, integrated point of sale system. Since computer power was the critical resource, efficiency of processing became the main goal. Emphasis was placed on automating existing process such as purchasing or paying, often within single department as indicated by Jeffrey A.Hofer on Modern System Analysis and Design (1996). Points of sale (P OS) systems are electronic systems that provide businesses with the capability to retain and analyze a wide variety of inventory and transaction data on a continuous basis. POS systems have been touted as valuable tools for a wide variety of business purposes, including refining target marketing strategies; tracking supplier purchases; determining customer purchasing patterns; analyzing sales (on a daily, monthly, or annual basis) of each inventory item, department, or supplier; and creating reports for use in making purchases, reorders, etc.Basic points of sale systems currently in use include standalone electronic cash registers, also known as ECRs; ECR-based network systems; and controller-based systems. Today, point of sale systems are light years ahead of where they began. Today's POS systems are faster, more secure, and more reliable than their predecessors, and allow retailers to operate every facet of their business with a single, integrated point of sale system. 2. 2 Local Literature Computers began from a wild imaginative idea to the world’s highly prioritized tool.Computers today are now used as a substitute to manual processes and other past inventions like the radio, television, etc. It is now used by people for much simpler, easier and faster way to do things. Some used it as a hobby, and some use it as a job. Technology has never stopped from advancing through the years. Its new innovations helps answer the people’s further complex questions. Why not use these advantages to benefit ourselves? Many people use computers in their daily lives.Some use it for transactions, some use it for educational purposes and others use it for data storage. Though it might sound unnecessary but in some cases when storing a file for such a big company, can you manage it properly? Organizing, finding a file, etc. With computers, it can help you simplify the process of storing and managing the files you need for future use and make finding files easier than the manual process. With our proposed Point of Sales and Inventory System In business like Stone Pro Enterprise , Sales and Inventory system plays an important role.It is used to track all the transactions made by the business and responsible for monitoring the items supplies. All the business transactions must be properly recorded and must be fully secured by password. A Computerized system is the best solution and most innovative answer for their needs. The researchers had been motivated to do a study on this topic according to the above observation. The result may help others to understand more about computer-generated data processing, especially on how to deal with computers in terms of speed, accuracy and data security. 2. Related Studies In exploration, we find new techniques, new knowledge, even develop new substances, gadgets, equipment, processes or procedures, imagination and skill is employed by the researcher. The commodities, new devices, services, in technology a re needs of man for a better fuller life which is the concern of the research. These useful arts are the products of the technological environment and the end-user is society in general. The fast growing trend and innovation in technologies today prompts researchers to conduct studies about the efficiency of    system program.This Chapter presents a brief review of literature and studies, both local and foreign that is related to these studies. 2. 4 Foreign Studies 2. 5 Local Studies 2. 6 Synthesis CHAPTER 3 RESEARCH METHODOLOGY This chapter outline the research methodology of this study. The research was conducted in six phases and the research methodology will be discussed under several phases : research design, setting of the study, subject of the study, source data, hardware and software requirements and statistical treatment to be use to come up with an effective proposal. . 1 Research Design The descriptive method of research was used for this study. To define the descriptiv e type of research, Creswell (1994) stated that the descriptive method of research is to gather information about the present existing condition. The emphasis is on describing rather than on judging or interpreting. The aim of descriptive research is to verify formulated hypotheses that refer to the present situation in order to elucidate it. The descriptive approach is quick and practical in terms of the financial aspect.Moreover, this method allows a flexible approach, thus, when important new issues and questions arise during the duration of the study, further investigation may be conducted. Descriptive research on the other hand is a type of research that is mainly concerned with describing the nature or condition and the degree in detail of the present situation. This method is used to describe the nature of a situation, as it exists at the time of the study and to explore the cause/s of particular a phenomenon. The aim of descriptive research is to obtain an accurate profile o f the people, events or situations.With this research type, it is essential that the researcher already has a clear view or picture of the phenomena being investigated before the data collection procedure is carried out. The researcher used this kind of research to obtain first hand data from the respondents so as to formulate rational and sound conclusions and recommendations for the study. The descriptive approach is quick and practical in terms of the financial aspect. 3. 3 Subject of the Study A Point of Sale (POS ) System   is a  system  for managing the sales of retail goods.The term is used to refer to the software and hardware associated with check out stands, and all of the bundled features which are included. Most retailers use a POS  system  at their check stands or counters, and several major manufacturers offer POS systems designed for various types of businesses, ranging from grocery stores to clothing boutiques. Using a POS  system  makes a business much more efficient, lowering the costs of running the business while improving customer service  and making the business more pleasant to work in.In the retail trade, the â€Å"point  of  sale† is the moment when a customer walks up to a counter with goods and prepares to purchase them. A POS  system  handles the transaction, whether it takes the form of an  adding machine  and a hand written receipt pad, or a complex computer system. Except in the case of very small businesses, a current POS  system  usually takes the form of a computer  system. 3. 4 Sources of the Study Our source data is divided into 2 groups, namely the source data based on direct observation and data sources based on indirect observations. . ) Source of data based on direct observation, among others: †¢ Conducting  field studies, it was held at the time we worked at a company engaged in the field of office equipment. †¢ Observation of the market to determine market prices. â € ¢ Discussion fellow colleagues, college friends and group member . 2. ) Source of data based on indirect observations: †¢ Searching  the internet. †¢ Lecture notes †¢ Visual Basic Handbook 3. 5 Procedure of the Study We made our own questionnaire for our study to know the outcome of Point of Sale System.Then we distribute it to our respondents after they answer the question we tallied and get the average of the verbal interpretation. 3. 6 Project Design [pic] [pic] 3. 7 System Flow Chart [pic] Figure 2 System Flowchart 4. 5 System Algorithm Our computerized system allows business owners to track sales, cash flow and item inventory. This system will also calculate the total of all the items that have been purchased. It will ensure not only that the items has been calculated accurately but it will also eliminate the chance of a wrong price being entered.It help retrieved purchase history, item sales detail, stock status reports, monthly, yearly, and seasonal sales data. Also this will prevent theft and also help to maintain a record of what is being sold. This will also help to monitor the employees. It will generate and print professional looking receipts. 3. 9 Hardware and Software Requirements The Point of Sale System by Blue Link Technology is the software which will be used. The operating or the platform that will be going to use is Windows XP, Visual Basic 6. 0 as the front end and Microsoft Access 2007 as the database. Hardware minimum requirements Intel Pentium 3 3. Ghz with 512mb RAM. 600 x 800 screen. 3. 10 Statistical Treatment Database – The united collection of data, usually stored in one computer file in one location, although databases can encompass information from many sources and locations. Discount – reductions to a basic price of goods or services Frequency Count – This is the most straight-forward approach to working with quantitative data. Items are classified according to a particular scheme and an arithmetical count is made of the number of items (or  tokens) within the text which belong to each classification (or  type) in the scheme.Percentage – A  fraction  or  ratio  with 100 as the fixed and understood denominator. Weighted Mean –   is similar to an  arithmetic mean  (the most common type of  average), where instead of each of the data points contributing equally to the final average, some data points contribute more than others. The notion of weighted mean plays a role in  descriptive statistics  and also occurs in a more general form in several other areas of mathematics. Tender – In business, a term synonymous with payment or type of payment. CHAPTER 4 PRESENTATION ANALYSIS AND INTERPRETATION OF DATAIn this chapter states the level of acceptability of the developed system, the significant difference on the perception of the respondents to the developed system, development of the system, program flowchart, program algorithm , program listing, program output and user manual. 4. 1 The level of Acceptability of the developed system |Questions |Cashier |Employee of Stuff the |Weighted Mean |Verbal Interpretation | | | |Bus | | | |1.The point of sales system is easy to handle? |3 |1. 5 |2. 25 |Uncertain | | | | | | | |   |   |   |   |   | |2. The computation of the amount price is accurate in |3. 5 |3 |3. 25 |Agree | |the Point of Sale System? | | | | | | | | | | | | | | | | |   |   |   |   |   | |3. The point of sales System can maximize the |3. 5 |4. |4 |Agree | |productivity of the cashiers work? | | | | | | | | | | | | | | | | | |   |   |   |   |   | |4.The Point of Sales System is used efficiently among |4. 5 |2. 5 |3. 5 |Agree | |various stores? | | | | | | | | | | | | | | | | |   |   |   |   |   | |5. Do you think Point of Sale System can help to your |5 |2. |3. 75 |Agree | |company? | | | | | | | | | | | |   |   |   |   |   | |Average Weighted Mean |3. 9 |2. 8 |3. 35 |Agree | Table 3Computation of the level of acceptability of the developed system Question 1 shows that among 20 respondents uncertain that Point of Sale System is easy to handle, because of the weighted mean of 2. 25. Question 2 shows that among 20 respondents with the weighted mean of 3. 25. This simply means that respondents agree that the computation of the amount price is accurate in the Point of Sale System. Question 3 shows that among 20 respondents with the weighted mean of 4. 0. This shows that most of the respondent's agree that the Point of Sale System can maximize the productivity of the cashiers works.Question 4 shows that among 20 respondents with the weighted mean of 3. 5. This shows that the most respondents agree that the Point of Sales System was used efficiently among various stores. Question 5 shows that among 20 respondents with the weighted mean of 3. 75. This shows the most of the respondents agree that the Point of Sale System can help to t heir company. Based on the table most of the respondents agreed because of the average weighted mean of 3. 35 which falls on Agree Verbal Interpretation. 4. 2 The significance Difference of the Perception of the Respondents to the Developed System Respondents DistributionThe population consists of 20 persons where 50% of the respondents are cashiers and the employee of Stone Pro Enterprise. |Respondents |Quality |Percentage | |Cashiers |10 |50% | |Customers |10 |50% | Table 1 Respondent Table Opinion Index The researchers will use questionnaires with the opinion index below to scale the effectiveness of the study of the respondents. Some questions have options and some are needed to be evaluated and answerable by number with corresponding verbal interpretation. ( see table 2 ). Scale |Range |Verbal Interpretation | |5 |4. 01 – 5. 00 |Strongly Agree | |4 |3. 01 – 4. 00 |Agree | |3 |2. 01 – 3. 00 |Uncertain | |2 |1. 01 – 2. 00 |Disagree | |1 |0. 01 – 1. 00 |Strongly Disagree | Table 2 Option Index 4. 3 Development of the System [pic] [pic] [pic] [pic] [pic] [pic] [pic] [pic] [pic] [pic] pic] 4. 4 Program Flow Chart [pic] [pic] [pic] [pic] [pic] [pic] [pic] 4. 5 Program Algorithm Our computerized system allows business owners to track sales, cash flow and item inventory. This system will also calculate the total of all the items that have been purchased. It will ensure not only that the items has been calculated accurately but it will also eliminate the chance of a wrong price being entered. Also this will prevent theft and also help to maintain a record of what is being sold. This will also help to monitor the employees. It will generate and print professional looking receipts. 4. 6 Program Listing A.Member Log In Option Explicit Private Sub cmdClose_Click() If Me. cmdClose. Caption = â€Å"Close† Then Dim reply reply = MsgBox(â€Å"Do you realy want to Quit this program? â€Å", vbYesNo + vbQuestion, â€Å"Confirm Qu it†) If reply = vbYes Then End End If Else Unload Me End If End Sub Private Sub cmdOk_Click() Me. AdoUser. Refresh If Me. cmdClose. Caption = â€Å"Close† Then Me. AdoUser. Recordset. Find (â€Å"UserName = ‘† & txtUser. Text & â€Å"‘†) If Me. txtPassword. Text = Me. AdoUser. Recordset. Fields(â€Å"Password†) Then If Me. AdoUser. Recordset. Fields(â€Å"Previledge†) = â€Å"Admin† Then mdiMain. mnuItems. Enabled = True mdiMain. tbMain. Panels(2). Text = Me. AdoUser. Recordset. Fields(â€Å"UserName†) frmSplash. Show mdiMain. Show End If If Me. AdoUser. Recordset. Fields(â€Å"Previledge†) = â€Å"User† Then mdiMain. mnuItems. Enabled = False mdiMain. mnuUser. Enabled = False mdiMain. mnuCustomers. Enabled = False mdiMain. mnuSuppliers. Enabled = False mdiMain. Toolbar1. Buttons(11). Enabled = False mdiMain. stbMain. Panels(2). Text = Me. AdoUser. Recordset. Fields(â€Å"UserName†) ‘Unload Me mdiMain. Show End If Unload Me Else MsgBox â€Å"Invalid Password!!! â€Å", vbExclamation, â€Å"Invalid Password† Me. txtPassword. SetFocus Me. txtPassword = â€Å"† End If End IfEnd Sub Private Sub Form_Load() On Error Resume Next Call SQLDB(AdoUser, â€Å"Select * from UserAccount†) AdoUser. Refresh txtUser. Text = â€Å"Admin† End Sub Private Sub txtPassword_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then cmdOk_Click ‘cmdAccess_Click End If End Sub Private Sub txtUser_Click(Area As Integer) On Error Resume Next Dim temp Me. AdoUser. Recordset. Find (â€Å"UserName = ‘† & txtUser. Text & â€Å"‘†) temp = Me. AdoUser. Recordset. Fields(1) End Sub B. Main Page Private Sub MDIForm_Load() ‘With stbMain ‘ensures all panels are visible upon loading DE. Connection1. ConnectionString = â€Å"Provider=Microsoft. Jet. OLEDB. 4. ;Data Source=† & App. Path & â€Å"DBStonePro. mdb;Persist Security Info= False;Jet OLEDB:Database Password= † mdiMain. Width = 15360 End Sub Private Sub MDIForm_Unload(Cancel As Integer) Dim reply reply = MsgBox(â€Å"Do you want to Quit this program? â€Å", vbYesNo + vbQuestion, â€Å"Confirm Quit†) If reply = vbYes Then End End If error: Cancel = -1 End Sub Private Sub mnuAbout_Click() frmAbout. Show vbModal End Sub Private Sub mnuBD_Click() frmDatabase. Show vbModal End Sub Private Sub mnuCustomers_Click() frmCustomers. Show vbModal End Sub Private Sub mnufind_Click() frmfind. Show 1 End Sub Private Sub mnuGp_Click() frmGroup. Show vbModal End SubPrivate Sub mnuItems_Click() frmFItems. Show vbModal End Sub Private Sub mnuLogOff_Click() Dim reply reply = MsgBox(â€Å"Do you really want to LogOff? â€Å", vbYesNo + vbQuestion, â€Å"Confirm Log-Off†) If reply = vbYes Then ‘frmLogin. cmdClose. Caption = â€Å"Cancel† frmLogin. Show vbModal End If End Sub Private Sub mnuNewSales_Click() ‘On Error Resume Next Cal l SQLDB1(frmNewSales. AdoSales, â€Å"Select * from Sales†) Call SQLDB2(frmNewSales. adoCustomer, â€Å"Select * from Customer order by CustomerNumber†) If frmNewSales. AdoSales. Recordset. RecordCount ;= 0 And frmNewSales. AdoSales. Recordset. RecordCount ; 9 Then frmNewSales. xtSalesNumber. Text = â€Å"00000† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount ;= 9 And frmNewSales. AdoSales. Recordset. RecordCount ; 99 Then frmNewSales. txtSalesNumber. Text = â€Å"0000† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount ;= 99 And frmNewSales. AdoSales. Recordset. RecordCount ; 999 Then frmNewSales. txtSalesNumber. Text = â€Å"000† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount ;= 999 And frmNewSales.AdoSales. Recordset. RecordCount ; 9999 Then frmNewSales. txtSalesNumber. Text = â€Å"00† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount ;= 9999 And frmNewSales. AdoSales. Recordset. RecordCount ; 99999 Then frmNewSales. txtSalesNumber. Text = â€Å"0† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount ;= 99999 And frmNewSales. AdoSales. Recordset. RecordCount ; 999999 Then frmNewSales. txtSalesNumber. Text = frmNewSales. AdoSales. Recordset. RecordCount + 1 End If frmNewSales. xtAmountPaid. Text = â€Å"0. 00† frmNewSales. txtBalance. Text = â€Å"0. 00† frmNewSales. txtTotalCost. Text = â€Å"0. 00† frmNewSales. txtDeliverySatus. Text = â€Å"Undelivered† frmNewSales. dtDate. Value = date frmNewSales. DTDelivery = date frmNewSales. Show vbModal End Sub Private Sub mnuOrder_Click() frmOrders. Show vbModal End Sub Private Sub mnuOrder2_Click() frmOrders. Show vbModal End Sub Private Sub mnuQuit_Cl ick() Dim reply reply = MsgBox(â€Å"Do you want to Quit this program? â€Å", vbYesNo + vbQuestion, â€Å"Confirm Quit†) If reply = vbYes Then End End If End Sub Private Sub mnuROP_Click() Set ReOrder. DataSource = frmReProd. Adodc1.Recordset ReOrder. Refresh ReOrder. Show End Sub Private Sub mnuRDelivered_Click() frmDelivered. Show vbModal End Sub Private Sub mnuRItems_Click() frmFItems. Show vbModal End Sub Private Sub mnuRP_Click() frmReProd. Show vbModal End Sub Private Sub mnuRPR_Click() frmReProd. Show vbModal End Sub Private Sub mnuRSales_Click() frmSalesReport. Show vbModal End Sub Private Sub mnuRSupplier_Click() frmSupplier. Show vbModal End Sub Private Sub mnuRUndelivered_Click() frmUndelivered. Show vbModal End Sub Private Sub mnuSuppliers_Click() frmSupplier. Show vbModal End Sub Private Sub mnuTips_Click() frmTips. Show vbModal End SubPrivate Sub mnuUpdateSales_Click() frmUpdateBalance. Show vbModal End Sub Private Sub mnuUser_Click() frmUser. Show vbModal En d Sub Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib. Button) Select Case Button. Index Case 3: Call mnufind_Click Case 5: PopupMenu mnuTransaction, , Button. Left, (Button. Top + Button. Height) Case 7: PopupMenu mnuReport, , Button. Left, (Button. Top + Button. Height) Case 9: PopupMenu mnuAccount, , Button. Left, (Button. Top + Button. Height) Case 11: PopupMenu mnuHelp, , Button. Left, (Button. Top + Button. Height) Case 13: Dim reply reply = MsgBox(â€Å"Do you want to Quit this program? , vbYesNo + vbQuestion, â€Å"Confirm Quit†) If reply = vbYes Then End End If error: Cancel = -1 End Select End Sub C. Transaction Page Private Sub cmdAdd_Click() Grid_DblClick cmdEditItems. Enabled = True cmdRemove. Enabled = True End Sub Private Sub cmdCalculator_Click() Shell â€Å"calc. exe†, vbMaximizedFocus End Sub Private Sub cmdClose_Click() Call SQLDB1(AdoSales, â€Å"Select * from Sales†) Me. AdoSales. Refresh If Val(Me. txtTotalCost. Text) = 0 Then Unload Me Else If Me. txtCustomerName. Text = â€Å"† Then MsgBox â€Å"Please complete data before closing. â€Å", vbInformation, â€Å"Information† Else With Me. AdoSales .Refresh .Recordset.AddNew .Recordset. Fields(â€Å"SalesNumber†) = Me. txtSalesNumber. Text . Recordset. Fields(â€Å"CustomerNumber†) = Me. txtCustomerNumber. Text . Recordset. Fields(â€Å"CustomerName†) = Me. txtCustomerName. Text . Recordset. Fields(â€Å"Datepurchased†) = Me. dtDate. Value .Recordset. Fields(â€Å"DeliveryDate†) = Me. DTDelivery. Value .Recordset. Fields(â€Å"DeliveryStatus†) = Me. txtDeliverySatus. Text . Recordset. Fields(â€Å"TotalCost†) = Me. txtTotalCost. Text .Recordset. Fields(â€Å"total†) = Me. Text3. Text .Recordset. Fields(â€Å"Discount†) = Me. Text2. Text .Recordset. Fields(â€Å"AmountPaid†) = Me. txtAmountPaid. Text .Recordset.Fields(â€Å"Balance†) = Me. txtBalance. Text .Records et. Update .Refresh Unload Me End With End If End If End Sub Private Sub cmdEditItems_Click() Me. AdoItems. Refresh Me. AdoItems. Recordset. Find (â€Å"ItemNumber = ‘† & Me. AdoSalesInfo. Recordset. Fields(â€Å"ItemNumber†) & â€Å"‘†) frmEditItems. txtinfo(0). Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"SalesNumber†) frmEditItems. txtinfo(1). Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"Date†) frmEditItems. txtinfo(2). Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"ItemNumber†) frmEditItems. txtinfo(3). Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"ItemName†) frmEditItems. txtinfo(4).Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"Qty†) frmEditItems. txtinfo(5). Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"UnitPrice†) frmEditItems. txtinfo(6). Text = Me. AdoSalesInfo. Recordset. Fields(â€Å"TotalPrice†) frmEditItems. Show vbModal End Sub Private Sub cmdNew_Click() ‘On Error Resume Next cmdEditItems. Enabled = False cmdRemove. Enabled = False Call SQLDB1(AdoSales, â€Å"Select * from Sales†) Me. AdoSales. Refresh If Val(Me. txtTotalCost. Text) = 0 Then Else If Me. txtCustomerName. Text = â€Å"† Then MsgBox â€Å"Please complete data before closing. â€Å", vbInformation, â€Å"Information† Else With Me. AdoSales .Refresh .Recordset.AddNew .Recordset. Fields(â€Å"SalesNumber†) = Me. txtSalesNumber. Text . Recordset. Fields(â€Å"CustomerNumber†) = Me. txtCustomerNumber. Text . Recordset. Fields(â€Å"CustomerName†) = Me. txtCustomerName. Text . Recordset. Fields(â€Å"Datepurchased†) = Me. dtDate. Value .Recordset. Fields(â€Å"DeliveryDate†) = Me. DTDelivery. Value .Recordset. Fields(â€Å"DeliveryStatus†) = Me. txtDeliverySatus. Text . Recordset. Fields(â€Å"TotalCost†) = Me. txtTotalCost. Text .Recordset. Fields(â€Å"AmountPaid†) = Me. txtAmountPaid. Text .Recordset. F ields(â€Å"Discount†) = Me. Text2. Text .Recordset. Fields(â€Å"Balance†) = Me. txtBalance. Text .Recordset.Fields(â€Å"total†) = Me. Text3. Text .Recordset. Update .Refresh Me. txtCustomerName. Locked = False Me. txtCustomerNumber. Locked = False Me. txtCustomerName. Text = â€Å"† Me. txtCustomerNumber. Text = â€Å"† Me. txtAmountPaid. Text = â€Å"0. 00† Call SQLDB1(frmNewSales. AdoSales, â€Å"Select * from Sales†) Call SQLDB2(frmNewSales. adoCustomer, â€Å"Select * from Customer order by CustomerName†) If frmNewSales. AdoSales. Recordset. RecordCount >= 0 And frmNewSales. AdoSales. Recordset. RecordCount < 9 Then frmNewSales. txtSalesNumber. Text = â€Å"00000† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales.AdoSales. Recordset. RecordCount >= 9 And frmNewSales. AdoSales. Recordset. RecordCount < 99 Then frmNewSales. txtSalesNumber. Text = â€Å"0000† & frmNewSales. AdoSales. Re cordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount >= 99 And frmNewSales. AdoSales. Recordset. RecordCount < 999 Then frmNewSales. txtSalesNumber. Text = â€Å"000† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount >= 999 And frmNewSales. AdoSales. Recordset. RecordCount < 9999 Then frmNewSales. txtSalesNumber. Text = â€Å"00† & frmNewSales.AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount >= 9999 And frmNewSales. AdoSales. Recordset. RecordCount < 99999 Then frmNewSales. txtSalesNumber. Text = â€Å"0† & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount >= 99999 And frmNewSales. AdoSales. Recordset. RecordCount > 999999 Then frmNewSales. txtSalesNumber. Text = frmNewSales. AdoSales. Recordset. RecordCount + 1 End If frmNewSales. txtAmountPaid. Text = â€Å"0. 00† frmNew Sales. txtBalance. Text = â€Å"0. 00† frmNewSales. txtTotalCost. Text = â€Å"0. 00† rmNewSales. Text3. Text = â€Å"0. 00† frmNewSales. txtDeliverySatus. Text = â€Å"Undelivered† frmNewSales. dtDate. Value = date frmNewSales. DTDelivery = date Me. cmdNew. Enabled = False Me. cmdNewCustomer. Enabled = True Me. cmdPayment. Enabled = False Me. cmdReciept. Enabled = False Me. cmdEditItems. Enabled = False Me. cmdRemove. Enabled = False Call SQLDB3(AdoItems, â€Å"Select * from Items where RemainingQty ; 0†) Call SQLDB(AdoSalesInfo, â€Å"Select * from SalesInfo where SalesNumber='† & Me. txtSalesNumber. Text & â€Å"‘†) AdoSalesInfo. Refresh AdoItems. Refresh ‘Me. cmdNew. Enabled = True Set Grid2. DataSource = AdoSalesInfoGrid2. Columns(1). Visible = False Grid2. Columns(2). Visible = False Grid2. Columns(5). NumberFormat = â€Å"##0. 00† Grid2. Columns(6). NumberFormat = â€Å"##0. 00† Set Grid. DataSource = AdoItems Grid. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(5). Visible = False Grid. Columns(6). Visible = True Me. txtCustomerName. Locked = False Me. txtCustomerName. Locked = False lblChange. Caption = â€Å"0. 00† Me. txtCustomerName. Text = â€Å"† Me. txtCustomerNumber. Text = â€Å"† Me. txtAmountPaid. Text = â€Å"0. 00† Me. txtCustomerName. Locked = False Me. txtCustomerNumber. Locked = False Me. txtCustomerName. Text = â€Å"†Me. txtCustomerNumber. Text = â€Å"† Me. txtAmountPaid. Visible = True ‘Unload Me End With End If End If End Sub Private Sub cmdNewCustomer_Click() With frmNewCustomer If Me. adoCustomer. Recordset. RecordCount >= 0 And Me. adoCustomer. Recordset. RecordCount < 9 Then . txtinfo(0). Text = â€Å"00000† & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount >= 9 And Me. adoCustomer. Recordset. RecordCount < 99 Then . txtinfo(0 ). Text = â€Å"0000† & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount >= 99 And Me. doCustomer. Recordset. RecordCount < 999 Then . txtinfo(0). Text = â€Å"000† & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount >= 999 And Me. adoCustomer. Recordset. RecordCount < 9999 Then . txtinfo(0). Text = â€Å"00† & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount >= 9999 And Me. adoCustomer. Recordset. RecordCount < 99999 Then . txtinfo(0). Text = â€Å"0† & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount >= 99999 And Me. adoCustomer. Recordset.RecordCount > 999999 Then . txtinfo(0). Text = Me. adoCustomer. Recordset. RecordCount + 1 End If .Show vbModal End With End Sub Private Sub cmdPayment_Click() If Me. AdoSalesInfo. Recordset. RecordCount = 0 Then MsgBox â€Å"You cannot proc eed to payment because there is no item in your sales item list!!! â€Å", vbExclamation, â€Å"Error† Else frmPayment. txtBalance. Text = Me. txtBalance. Text frmPayment. Text3. Text = Me. txtTotalCost. Text frmPayment. txtChange. Text = â€Å"0. 00† frmPayment. txtPayment. Text = â€Å"0† frmPayment. Show vbModal End If End Sub Private Sub cmdReciept_Click() If Me. AdoSalesInfo. Recordset.RecordCount = 0 Then MsgBox â€Å"There is no item!!! â€Å", vbExclamation, â€Å"StonePro System† Else If Me. txtCustomerName. Text = â€Å"† Or Me. txtDeliverySatus. Text = â€Å"† Then MsgBox â€Å"Please supply personal data before you view the receipt. â€Å", vbInformation, â€Å"Information† Else Set RptReceipt. DataSource = Me. AdoSalesInfo RptReceipt. Refresh RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblSalesNumber†). Caption = frmNewSales. txtSalesNumber. Text RptReceipt. Sections(â€Å"Section2†). C ontrols(â€Å"lblTotalCost†). Caption = Format(frmNewSales. Text3. Text, â€Å"#,##0. 00†) RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblCustomerNumber†).Caption = frmNewSales. txtCustomerNumber. Text RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblCustomerName†). Caption = frmNewSales. txtCustomerName. Text RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblDatePurchased†). Caption = frmNewSales. dtDate. Value RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblDeliveryDate†). Caption = frmNewSales. DTDelivery. Value RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblDis†). Caption = Format(frmNewSales. Text2. Text, â€Å"#,##0. 00†) RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblAmountPaid†). Caption = Format(frmNewSales. txtPayment. Text, â€Å"#,##0. 00†) RptReceipt.Sections(â€Å"Section2†). Controls(â€Å"lblBala nce†). Caption = Format(frmNewSales. txtBalance. Text, â€Å"#,##0. 00†) RptReceipt. Sections(â€Å"Section2†). Controls(â€Å"lblChange†). Caption = Format(frmNewSales. lblChange. Caption, â€Å"#,##0. 00†) cmdNew. Enabled = True RptReceipt. Show 1 End If End If End Sub Private Sub cmdRemove_Click() Dim reply reply = MsgBox(â€Å"Are you sure you want to remove this item to sales list? â€Å", vbYesNo + vbQuestion, â€Å"Confirmation to Remove†) If reply = vbYes Then frmNewSales. AdoItems. Refresh Call SQLDB3(AdoItems, â€Å"Select * from Items†) frmNewSales. AdoItems. Recordset. Find (â€Å"ItemNumber= ‘† & Me. AdoSalesInfo.Recordset. Fields(â€Å"ItemNumber†) & â€Å"‘†) frmNewSales. AdoItems. Recordset. Fields(â€Å"RemainingQty†) = Val(frmNewSales. AdoItems. Recordset. Fields(â€Å"RemainingQty†)) + Me. AdoSalesInfo. Recordset. Fields(â€Å"Qty†) frmNewSales. AdoItems. Record set. Update frmNewSales. AdoItems. Refresh frmNewSales. txtTotalCost. Text = Format(Val(frmNewSales. txtTotalCost. Text) – Me. AdoSalesInfo. Recordset. Fields(â€Å"TotalPrice†), â€Å"##0. 00†) frmNewSales. txtBalance. Text = Format(Val(frmNewSales. txtBalance. Text) – Me. AdoSalesInfo. Recordset. Fields(â€Å"TotalPrice†), â€Å"##0. 00†) frmNewSales. AdoSalesInfo. Recordset. Delete frmNewSales.AdoSalesInfo. Refresh Call SQLDB3(AdoItems, â€Å"Select * from Items where RemainingQty ; 0†) Call SQLDB(AdoSalesInfo, â€Å"Select * from SalesInfo where SalesNumber='† & Me. txtSalesNumber. Text & â€Å"‘†) AdoSalesInfo. Refresh AdoItems. Refresh ‘Me. cmdNew. Enabled = True Set Grid2. DataSource = AdoSalesInfo Grid2. Columns(1). Visible = False Grid2. Columns(2). Visible = False Grid2. Columns(5). NumberFormat = â€Å"##0. 00† Grid2. Columns(6). NumberFormat = â€Å"##0. 00† Set Grid. DataSource = Ad oItems Grid. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(5). Visible = False If Me. AdoSalesInfo. Recordset.RecordCount = 0 Then Me. cmdEditItems. Enabled = False Me. cmdRemove. Enabled = False Me. cmdPayment. Enabled = False End If Else End If End Sub Private Sub Form_Load() ‘On Error Resume Next Call SQLDB3(AdoItems, â€Å"Select * from Items where RemainingQty ; 0†) Call SQLDB(AdoSalesInfo, â€Å"Select * from SalesInfo where SalesNumber='† & Me. txtSalesNumber. Text & â€Å"‘†) Call SQLDB2(frmNewSales. adoCustomer, â€Å"Select * from Customer Order by CustomerName†) adoCustomer. Refresh AdoSalesInfo. Refresh AdoItems. Refresh ‘Me. cmdNew. Enabled = True Set Grid2. DataSource = AdoSalesInfo Grid2. Columns(1). Visible = False Grid2. Columns(2).Visible = False Grid2. Columns(5). NumberFormat = â€Å"##0. 00† Grid2. Columns(6). NumberFormat = â€Å"##0. 00† Set Grid. DataSource = AdoItems Gr id. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(5). Visible = False Grid. Columns(6). Visible = True Grid2. Refresh ‘Call setgrid ‘Call settext ‘Call setgrid ‘lblTotal. Caption = â€Å"Total Number of Records: † & Me. AdoSalesInfo. Recordset. RecordCount End Sub Private Sub setgrid() Set Me. Grid2. DataSource = Me. AdoSalesInfo Grid. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(3). Visible = False Grid. Columns(4). Visible = FalseGrid. Columns(5). Visible = False Grid. Columns(6). Visible = True End Sub Private Sub Grid_DblClick() With frmSalesConfirm .txtinfo(0). Text = Me. txtSalesNumber. Text .txtinfo(1). Text = Me. dtDate. Value .txtinfo(2). Text = Me. AdoItems. Recordset. Fields(â€Å"ItemNumber†) . txtinfo(3). Text = Me. AdoItems. Recordset. Fields(â€Å"ItemName†) . txtinfo(4). Text = â€Å"0† .txtinfo(5). Text = Me. AdoItems. Recordset. Fields(â€Å"UnitPriceâ € ) . txtinfo(6). Text = â€Å"0. 00† If Me. AdoItems. Recordset. Fields(â€Å"Unit†) = â€Å"Kilo† Then .Label5. Caption = â€Å"Quantity† End If .Show vbModal End With End Sub Private Sub lvButtons_H3_Click()Unload Me End Sub Private Sub Text1_Change() On Error Resume Next Me. AdoItems. Refresh Me. AdoItems. Recordset. Filter = â€Å"ItemName LIKE ‘† & LCase(Me. Text1. Text) & â€Å"*'† ‘Call settext ‘Call setgrid If Me. Text1. Text = â€Å"† Then Me. AdoItems. Refresh ‘setgrid End If End Sub Private Sub txtAmountPaid_Change() ‘If Val(Me. txtAmountPaid. Text) < Val(Me. txtTotalCost. Text) Then ‘MsgBox â€Å"Amount paid is lower than its total cost. â€Å", vbExclamation, â€Å"Stone Pro System† ‘Me. txtAmountPaid. Text = â€Å"0. 00† ‘Else ‘Me. txtBalance. Text = Format(Val(Me. txtTotalCost. Text) – Val(Me. txtAmountPaid. Text), â€Å"##0. 00†) â €˜End If End SubPrivate Sub txtAmountPaid_KeyPress(KeyAscii As Integer) If KeyAscii = 8 Then Exit Sub End If If KeyAscii = 46 Then Exit Sub End If If KeyAscii < 48 Or KeyAscii > 57 Then KeyAscii = 0 End If End Sub Private Sub txtCustomerName_Change() On Error Resume Next Me. adoCustomer. Refresh Me. adoCustomer. Recordset. Find (â€Å"CustomerName = ‘† & Me. txtCustomerName. Text & â€Å"‘†) Me. txtCustomerNumber. Text = Me. adoCustomer. Recordset. Fields(â€Å"CustomerNumber†) End Sub Private Sub txtCustomerNumber_KeyPress(KeyAscii As Integer) KeyAscii = False End Sub Private Sub txtDeliverySatus_KeyPress(KeyAscii As Integer) KeyAscii = False End SubConfirm Transaction Private Sub Check1_Click() If Check1. Value = 1 Then Me. Text2. Text = Format(Val(Me. Text3. Text * 0. 1), â€Å"#,##0. 00†) Me. Text1. Text = Format(Me. Text2. Text, â€Å"#,##0. 00†) Exit Sub End If If Check1. Value = 0 Then Me. Text1. Text = â€Å"0. 00† â⠂¬ËœMe. Text1. Text = Format(Val(Me. txtPayment. Text) – Val(Me. Text2. Text), â€Å"#,##0. 00†) Exit Sub End If End Sub Private Sub cmdClose_Click() frmNewSales. lblChange. Caption = Me. Text4. Text frmNewSales. Text2. Text = Me. Text1. Text Unload Me End Sub Private Sub cmdOk_Click() Dim reply reply = MsgBox(â€Å"Are you sure of this payment?. Payment can be done only once in this transaction. , vbQuestion + vbYesNo, â€Å"Confirmation†) If reply = vbYes Then If Val(Me. txtPayment) ; Val(frmNewSales. txtTotalCost) Then Me. txtBalance. Text = â€Å"0. 00† Me. cmdOk. Enabled = False frmNewSales. txtBalance. Text = â€Å"0. 00† frmNewSales. txtPayment. Text = Val(Me. txtPayment) Me. Text4. Text = Format(Val(Me. txtPayment) – Val(Text3. Text) + Val(Text1. Text), â€Å"#,##0. 00†) frmNewSales. txtAmountPaid. Visible = False frmNewSales. cmdReciept. Enabled = True frmNewSales. cmdPayment. Enabled = False frmNewSales. cmdEditItems. Enabl ed = False frmNewSales. cmdRemove. Enabled = False frmNewSales. Text3. Text = Format(Val(Text3.Text) – Val(Text1. Text), â€Å"#,##0. 00†) Me. Text1. Text = â€Å"0. 00† Else Me. txtBalance. Text = Format(Val(Me. txtPayment) – Val(Me. Text3. Text) – Val(Me. Text1. Text), â€Å"#,##0. 00†) Me. txtChange. Text = â€Å"0. 00† Me. cmdOk. Enabled = False frmNewSales. txtBalance. Text = Format(Val(Me. txtPayment) – Val(Me. Text3. Text) – Val(Me. Text1. Text), â€Å"#,##0. 00†) frmNewSales. txtBalance. Text = Format(Val(Me. Text3) – Val(Me. txtPayment. Text) – Val(Me. Text1. Text), â€Å"#,##0. 00†) frmNewSales. lblChange. Caption = â€Å"0. 00† frmNewSales. txtAmountPaid. Text = Val(Me. txtPayment) frmNewSales. txtPayment. Text = Val(Me. xtPayment) frmNewSales. cmdReciept. Enabled = True frmNewSales. cmdPayment. Enabled = False frmNewSales. cmdEditItems. Enabled = False frmNewSales. cmdRemove . Enabled = False frmNewSales. Text3. Text = Format(Val(Text3. Text) – Val(Text1. Text), â€Å"#,##0. 00†) ‘Me. Text1. Text = Format((frmNewSales. Text3. Text), â€Å"#,##0. 00†) frmNewSales. Text2. Text = Me. Text1. Text End If Else End If If Check1. Value = 1 Then Me. Text2. Text = Format(Val(Me. Text3. Text * 0. 1), â€Å"#,##0. 00†) Me. Text1. Text = Format(Me. Text2. Text, â€Å"#,##0. 00†) Exit Sub End If If Check1. Value = 0 Then frmNewSales. Text2. Text = â€Å"0. 00† Me. Text1.Text = â€Å"0. 00† Exit Sub End If End Sub Private Sub txtPayment_Change() If Check1. Value = 1 Then Me. Text2. Text = Format(Val(Me. Text3. Text * 0. 1), â€Å"#,##0. 00†) Me. Text1. Text = Format(Me. Text2. Text, â€Å"#,##0. 00†) Exit Sub End If If Check1. Value = 0 Then Me. Text1. Text = â€Å"0. 00† Exit Sub End If End Sub 4. 7 Program Output [pic] 4. 8 User Manual Title: Automated Sales and Inventory System of Stone Pro Enterprise Table of Contents 1. Introduction 1. 1 System Requirements 1. 1. 1 Hardware 1. 1. 1. 1 Desktop 1. 1. 1. 2 Display 1. 1. 1. 3 Cash Drawer 1. 1. 1. 4 Receipt Printer 1. 1. 2 Software 1. 2 Convention 2. Getting Started . 1 Member Log in 2. 2 Performing Transaction 3. Software Features 4. Message Boxes 5. User Interface Parts, Text boxes and Buttons 1. Introduction Most Large retail stores have migrated from the old trusty cash register to more modern computerized point of sale (POS) systems. This application Guide explores computerized POS technology and provides a roadmap for Stone Pro Enterprise. 1. 1 System Requirements 1. 1. 1 Hardware If you are a computer user, you're no doubt familiar with the most common desktop peripherals – the keyboard, mouse. Blue Link Technology systems are based on ordinary desktop computer and operating system . 1. 1. 1. Desktop Desktop with larger but quieter fans to minimize heat and noise. Heavy duty power supply that last longer th an the standard items. Hard drive doesn't have to be in large capacity but it has to be reliable. We also want to ensure that you're using good surge protector and UPS ( battery backup) to prevent power related crashes. 1. 1. 1. 2. Display At the very least, you'll need a basic  monitor  at your POS to see what you're doing. Touch screens  have become a more popular and affordable option these days since they are a user friendly option that can help speed up the checkout process.Adding customer-facing  and  pole displays  will offer a clearer customer experience and are a great way to promote special offers to customers while they are in line. 1. 1. 1. 3. Cash Drawer They may be the simplest peripheral in a POS system, but  cash drawers  are still an essential part of your system. You need to have a secure place to keep cash, checks 1. 1. 1. 4. Receipt Printer Every transaction ends with a receipt for the customer straight from a  receipt printer. Having a printer go down is one of the most crippling things to any POS system. Making sure you have a printer that'll support your print volume and is easy to use is essential.Most printers are thermal based so you don't even have to deal with ribbon cartridges anymore. Just load the paper and you are back up and running! Whatever your receipt size or type requirements are, there's a printer to fit your needs. There are numerous types of receipt printers, categorized – like any other computer printer – by its printing technology and its computer interface. 1. 1. 2. Software The  POS software  by Blue Link Technology is the brains of Stone Pro Enterprise POS system. 1. 2 Convention Double Click : Refer to user action Log in Window : Refer to user interfaceLog in Button: Refer to object Enter Key: Refer to Keyboard key 2. 0 Getting Started I. Daily Start-Up 1. Turn the Computer ON – Press the â€Å"ON/OFF† button. (On top of the computer for Stone Pro Enterprise. ) WAI T. It will take a few moments but eventually Stone Pro Enterprise System and an Address Lookup application will automatically start up. A desktop with icons will appear including [pic] A â€Å"Login† screen will appear: [pic] 2. Sign on to the System a) When the Security Login screen appears, User ID = (ask for an access code to the admin assign ) unless you have been assigned something else.Password = the password you selected. It will NOT appear for security reasons. ENTER b) The Main Desktop will appear [pic] II. Start of Shift A. Cash Register Processing. 1. Press the Transaction Menu button. 2. Select TRANSACTION then NEW SALE. [pic] ( You are now ready to perform Cash Register Operations. ) III. End of Shift A. Clerk Out Start at the â€Å"Transaction† screen. Press â€Å"CLOSE† to Exit from the Transaction Screen. IV. End of Day In the evening you will need to: 1. Leave the cash drawer open. 2. Close Stone Pro Enterprise System Main Page 3. Exit Stone Pro Enterprise System. 4.Turn off the computer. After you finish the â€Å"End of Shift† procedure, complete the following: A. Log Off of Stone Pro Enterprise System 1. At the main Stone Pro Enterprise System desktop B. Shut Down the Computer 1. Select the Start button in the lower left hand corner. 2. Select Shut Down†¦ from the list. A â€Å"Shut Down Windows† window will appear. 3. Select Shut Down from the drop down list. The monitor will go black and say ‘No Sync’ for a bit. CHAPTER 5 FINDINGS, CONCLUSIONS AND RECOMMENDATION In this chapter states the summary of findings, conclusion and recommendation. 4. 1 Summary of FindingsPoint of Sale System for Stone Pro Enterprise aims to develop an expert system that would enable the emergence of Point of Sale and maximize the capabilities. It shows how efficient accurate and well function, the point of sale compared to manual registry. 4. 2 Conclusion We conclude that the research has shown that the study c an be useful for the company Stone Pro Enterprise. In this study considering all the factors affecting. 4. 3 Recommendation The Researchers recommend this Point of Sale System of Stone Pro Enterprise to be used in interested establishment in improving and helping people retail their products. BIBLIOGRAPHY