Іnformatsіynі systems keruvannya budіvelniy complex. Distribution of the information security system for the Wimog hospitality company to the retailer of the hospitality company

Magazine "Budivelna tekhnіka i tekhnologii", №4, 2008

Main warehouse. The role of information systems in the processes of managing life and development projects. Vadim Tsvetkov, commercial director of West Concept.

Entry
The main warehouse business (about 90% contribution) is the stage of project implementation. There is a need for business and development companies, as well as companies that specialize in the development of territories and infrastructure of life, that is, road and life companies, contracting business organizations. There is a lot of reason why the projects of capital life will be so sporud and the creation of the adjacent infrastructure to lie in the form of a hard approach before the process. Those who are as good as a company can manage projects, their risks, terms, budget, and other warehouses, and contribute to the business of the whole. Crime of the human factor is impossible not to take to respect additional tools - information systems for business management.

Investment in warehouse development, which is another aspect of the life business, adding its own specialty, poov'yazani us in front of the search for finance and the structure of yoga dzherel. Credits from financial institutions, advances from purchasers, wet cats, the positions of others, the secrets of the ranks of the organizations, the money, the money obtained from the stock ambushes, foreign loans, too. - all the projects of the dzherel are used in the practice of developers and buddies. To work with them, the financial director is guilty of high qualifications. Vin often clashes with the need to maneuver with financial resources through time-based freezing of life at one object and high tempo and vice versa. It is practical for budgetary organizations to keep their financial planning in line with project planning.

In the process of managing the finances of the expanded life and development structure, it is carefully brought to the point of feeding the winners of the investments of the payoviks and/or the investors. Chapter 25 of the Tax Code goiter vrakhovuvat necilyov vikoristannya koshtіv schodo podatkovuvanoї base. Tsilkom Ymovirno, Scho of the Zagadani Koshtyv, controlled by one ONE (on the Yakaki-INSIAL-RECOUNT OF THE BUDIVNITRA TIMCHOVOVO) on the INNSH (de Budinitvny izhintensifi), Yak Netsilova vicoristani, we can inhibit the vinics of Zobov. With such a maneuver, the problem was often supplemented by the correct classification of bones. Budіvelny biznes has long been on the lookout for such a necessary crochet within the framework of the tax reform, like an accelerated procedure for exercising MAP in capital life.

This is one of the many problems with which the companies of the budvelous circle are stuck and virishiti as a business information system.

Problems in project management
In the period of creation, that growing company and project organization are organically woven into his life. A group of all functional scientists warehouses the headquarters for the project/projects at once. For example, the number of projects in the portfolio of a successful developer is rapidly growing. Obviously, new practitioners are being announced - project builders. The highest vykonavchiy management dedalі more often usuvaetsya vyvіshennya zavdan of everyday project management. Behind him, and functional managers peremikayutsya on vykonannya only appearance and control functions.

It is important that the organization has a centralized centralization headquarters, and it does not allow you to protect yourself on the windows, connected with the mornings of additional accountants, koshtorisnikov, lawyers, too. Here it’s impossible to guess about those from whom such a headquarters is physically formed: as a rule, these people themselves, since 5-7 years ago, they started a development business together with their masters, victoriously including the operational management task, connected with the life of that person object. On the one hand, the stench sounded thoughtful in the categories of a specific contract for a budding contract, prices for that chinese type of BIS and materials, or, for example, a typical application for window dressing. Other than that, they started working in parallel with the courses, received other and third diplomas, and increased their self-esteem. The first axis of the current headquarters is no longer able to serve projects (only to control!), but the headquarters of new project engineers cannot.

As a result, dozens of new project managers have been hired to become the financial director of the company.

So the irreconcilable conflict between the process and the result of business activity is blamed and rozpalyuetsya. Managers of key companies of rich-profile industrial and business holdings together with consultants for a long time slam their heads over the folding register of their own business processes, being out of their mind for an hour to learn that the main and, in fact, a single business process, they manage the entire project themselves The responsibility of the activity may be exclusively for the same and for the same timely completion of the very task.

If you see the main intricacies of projects in everyday life, then the stink of the stink will lead to the coming theses:

• matched three valid terms for the project;
• projects are developing in parallel, varying the structure and terminology of the cob and completion of work;
• projects are geographically distant from each other, like at the borders of the city, and widely between them;
• human factor: people go, and the company uses their competence and knowledge

І Below are some statistics from the consulting company Standish Group:

• 31% of projects end in failure;
• 53% of projects are completed with a budget overrun by 1.9 times;
• Only 16% of projects fit within the budget lines.

Below we will show you how many people are working hard for help with information systems.

Solutions for tasks and tools
When vyrіshennі quiet chi іnshih tasks, problems, it is important to mother a good tool. It is necessary to get a lot of information systems that allow and help project managers, company engineers, to create project activities, to improve their virobnichiy zavdannya effectively. What does the system allow? What is there to paint? Let's take a look at the nutrition report.

Provodzhennya single system planning and project management will help to improve the efficiency of project implementation in the company. What is reachable for the rahunok? As a rule, provadzhennya information system transferring not only the automation of the company's processes. It's worth doing a serious process, building a "chicken" organization, in a sensational term. Having poured into the project a zastosuvannya, you can allegorically sing on the butt of the one, like pouring gymnastics on the practitioner’s sitting practice at a broken yoga robot. Blood flows with new strength through the veins, it becomes easier to practice, then go, and we are ready for new feats.

The main advantages of using a project management information system are:

• the possibility of regulating the procedures for managing projects;
• designation and analysis of the effectiveness of investments;
• selection of mathematical methods for the analysis of hourly, resource, variant parameters in projects;
• centralized collection of information from the schedule of work, resources and varsity;
• the possibility of a quick analysis of the impact of changing the schedule, resource security and financing for the project plan;
• control over vikonannyam robit on projects;
• appearance and risk management of projects;
• ensuring the control of yakistyu robit;
• management and control of deliveries and contracts with safe project activities;
• designation of information flows in project activities;
• the possibility of automated generation of sounds and graphic diagrams, development of documentation for the project;
• support for archiving projects and accumulated knowledge.

More than opportunities, the system of building is to discipline the company, її practitioners, increase the level of reliability of the staff.

The skin project is bound to go through several stages, such as the planning of the viconnance, in fact, the control of its viconnance, the analysis of the results of the project is just that.

Planning
The planning stage is one of the most important. At this stage, the project managers, robots, their technological resources, the budget and the terms of the project are determined. Dosit often rozumіyut rozumіyut as folded scheduling robit, not zvajayuchi on resource management, fold the budget and so on.

For rich project management systems, graphics appear automatically, as the resource assignment is assigned:

• calendar-merezhevі schedule of the project;
• schedule of tenders;
• contract laying plan;
• the budget of the current budget, the payment plan and the budget.

All listed schedules are combined into a single plan for the project, from which you can cut the budget for income and spending on the project and the budget for a penny buck.

Vartіst robіt go automatically for rahunok podklyuchennya resurіvіv, scho vykonuyut robots or just zadіyanі at їх vikonanny. Leather from resources, whether it be the services of a contractor or everyday material, may have a good hand. Tse allows you to automatically mold the vartist robit stalely in the trivality of the day and robit.

Withdrawal of the budget must be confirmed. As a rule, the information system is able to comply with the regulations for the passage of this process. The main tasks of individuals and roles in the project establish the sequence of actions:

• approved by the project manager;
• approved by the curator of the project;
• approved by the financial department.

Once the formal plan is confirmed, the manager is responsible for how it will be implemented.

A confirmation of the fact
In the world of building the project, the scientists are obliged to constantly control the progress of work. The control is based on the collection of actual data on the progress of the work and the correspondence between them and the planned ones. Unfortunately, during the first hour of project management, one can be absolutely indebted to the fact that inspiration between planned and factual displays is constantly being carried out. For this reason, the manager's task is to analyze the possible injection of energy from the victorious obligations to work on the implementation of the project as a whole and in the event of viable managerial decisions. For example, if you look at the schedule to go beyond the acceptable rіven іdhіlennya, you may be praised for the decision to speed up the sing of the critical tasks for the rahunka seeing more resources on them.

Spivrobitniki, who take part in the project, get a list of their tasks and put down the fact of their vikonannya:

• manager, final project, confirming the fact of the completion of the task;
• change the terms and vartostі zavdan vіdobrazhayutsya at the plan.

Analysis and regulation of the progress of the project
Permanently in the course of the design activity, it is necessary to perform a number of functions, without which the project activity would be impossible.

After the completion of the project of yoga kerivnik, we may vikonati low final entries. The specific nature of these obov'yazkіv lie in the nature of the project itself. As in the project, the property was won, it needed to be done in inventory and, possibly, transferred for a new project. At times of contracting projects, it is important to determine who is satisfied with the results of the minds of the contract. It is possible, necessary to fold the remaining notes, and organize the intermediate notes of the project as an archive.

Functional control rooms
Project change management
For the success of the project, it is critically important to be able to trim under the control of inevitable changes, which are blamed on the successively appointed structures, obligations, and improvement of the results of the work.

Formalization of the process of managing changes may be launched at the project earlier, and even though it is not later, the formal designation of the subject gallery will be completed.

The main sense of the change management process is in the fact that, if decisions are made about changes in the object gallery, vrakhovuvavsya injecting these changes into the financial warehouse project. I respect that the idea of ​​changing the subject matter of the project does not necessarily increase the efficiency of the work of the entire project. Even more often, changes can be accepted, as if they change the dirty work, wanting to change in real life, which will increase the work, obviously, they traple more often.

Project changes can be financed from the internal budget of the project. Ale, regardless of the process of managing the changes in obov'yazkovo may be included in some of the moments.

The project management system, as a rule, inadvertently displays the overall plan of the project by looking at the diagrams of mutual tasks, and also in the real time mode it shows, as a change, for example, the triviality of that other building task to be included in the head of the entire project or to create a portfolio of projects.

Variety management
The management of the project schedule is based on the planning of the budget. Variety assessment - assessment of the possible variability of resources, which will be needed for the future work. Wartovі otsіnki rozrahovyutsya protyazh ugo project.

In the past articles, we already reportedly looked at the process of budgeting and the folding of financial plans, so we won’t focus on it at once.

At the early stages of the project, the lack of significance for the understanding of the real obligation of the project is still great and there is no sense in vitrates.

Іsnuє kіlka zagalnopriynyatyh methodіv rozrahunka varіsnyh otsіnok. You can choose a method that will ensure the necessary accuracy of the assessment and the ability to pay pennies and labor costs for conducting an assessment.

Method of evaluation "burn to the bottom"
The "top down estimate" method of estimating the varsity is used for estimating the vats at the early stages of the project, if the information about the project is still cleared. The sense of such an enlarged expert assessment is due to the fact that it is carried out in an integrated manner and the project is assessed as a whole for one show. The assessment is reasonable for them, because it does not require great sums of money for that hour. In short, the accuracy is not as high as it could be with a more detailed assessment.

Method of assessment "from the bottom of the hill"
The “bottom-up” assessment method is necessary to determine the appropriate base price for the project and the residual rank assessment for the project. Calling the method the method of estimating the variance assessment - the method of transferring the assessment of the cost on the detailed levels of the project, and then summing the cost on the highest levels of the index for assessing the vartost (koshtoris) of the entire project. For the creation of such a “package” of vitrates, it is possible to select the structure of the decomposition of robots (SDR or WBS) for the project. The advantage of this method is the accuracy of the obtained results, so, at my own hand, I can see it in equal detail when assessing the vitrates at the cob stages. From mathematical statistics, it is clear that the more details are added at a glance, the higher the accuracy of the assessment.

Not a lot of it is those who spend money and an hour on the detailed assessment are significant things, lower when using the “burn down” method.

Evaluation method "behind analogue"
The method of evaluation "behind the analogue" is one of the different methods of evaluation "burn to the bottom". The essence of yoga lies in the fact that in order to transfer the varity to the project, it is estimated that factual data about the varity of the earlier projects are scored. This method is based on the idea that all projects are similar to each other.

If the similarity between the project-analogue and the project that is being evaluated is great, then the results of the evaluation may be more accurate, otherwise the evaluation will be carried out incorrectly.

Methods of parametric estimates
Methods of parametric assessments are similar to the “behind the analog” assessment method and are different from the “burn to the bottom” method. The accuracy is not inferior to it and not worse than the accuracy of the assessment method "by analogy".

The evaluation process for the parameter determines the significance of such a parameter for the project, changing what it entails for itself in proportion to the change in the project's variability. A mathematically parametric model will be based on one or more parameters. After entering into the model, the value of the parameters in the results of the surveys will be given an estimate of the project cost.

Even though the parametric models of other projects are similar and the value of the cost and the values ​​of the parameters themselves are easy to improve, then the parametric assessment of the future project can be improved. For example, if there are two different projects, and the variance of one of them is greater than the variance of the estimated project, and the variance of the other one is smaller, and the parametric model is valid for both variant projects, then the accuracy of the parametric estimation of the variance of the future project and the variance of the higher parameter will be higher. Evaluation can also be carried out for the help of anonymous parameters. In this way, the skin parameter in the fallowness and its significance is attributed to the vago coefficient, and the assessment of varness is based on a richly parametric model.

Project risk management
Even more important is the project management process of risk management. The information system allows you to randomly and manually secure the possibility of curation by such tasks:

• Risk management planning - the choice of activities and risk management planning for the project.
• Identification of risks - the designation of risks, building impacts on the project, that documentation of their parameters.
• Yakіsna otsіnka rizikiv - yakіsny analysis of rizikіv and minds їх viniknennya z metoyyu vyznachennya їхнго impact on the success of the project.
• Kіlkіsna otsіnka - kіlіkіsny analysis of ymovіrnostі viniknennya i vplyu nasledkіv rizikiv on the project.
• Planning a response to risks is the design of procedures and methods to mitigate the negative consequences of risky conditions and overcome possible troubles.
• Monitoring and control of risks - monitoring of risks, identification of risks that are overdue, monitoring the risk management plan for the project and assessing the effectiveness of minimizing risks.

Project document management
An important task for a capital life is the management of project documentation. Necessary security of access to the design documentation of the project's cores. A wealth of information systems provide the ability to:

• take project documentation "in the middle" of the project;
• attach documents to the date of the design work;
• harden and wait documents;
• kіlkom koristuvacham pratsyuvati with one document;
• discuss documents;
• save your version.

Visnovok
We looked at the main functions and processes, which are even more important in project management as a
tive and other development companies. Project management is so closely related to the day-to-day life of a company, as it is in the main information systems due to the main project management systems. This situation can guarantee the promptness of the collection of information, as well as the urgency of working with great portfolios of projects.

It's easy to send your harn to the robot to the basics. Vikoristovy form, raztastovanu below

Students, graduate students, young adults, like victorious base of knowledge in their trained robots, will be your best friend.

Placed on http://allbest.ru

1. Information system Apache

1.1 Description of Apache

2. Information systems for a wake-up company

2.1 Information system 1C: Trade and warehouse

2.1.1 Program description

2.1.2 Work with different information bases

2.1.3 Reliability and safety

2.1.4 Flexibility and moodiness

2.1.5 Interface

2.1.6 Criticality and availability

2.1.7 Working with trading powers

2.2 CRM information system

2.2.1 Automation of business processes

2.2.2 Manage customer information

2.2.3 Sales management

2.2.4 Product portfolio management

2.2.5 Working hour management

2.2.6 Document automation

1. Information systemApache

The world has anonymous web servers. The stench is considered one kind of one for functionality and recognition. This robot will have one of the most popular installations on the largest servers of hosting providers. The Apache server satisfies practically all the needs of today's web development, but sometimes it's easy to install programs to improve their programs.

In 1994, Rob McCool, a spokesman for the National Center for Supercomputer Programs at the University of Illinois USA (NCSA), turned out to be the first web server, which is so called - NCSA HTTP daemon. The server gained popularity among the narrow cols, but in the middle of 1994, McCool left the university, and the rozrobki stumbled.

A small group of infected webmasters started working on the product. Speak to the discussion arkusha email, stinks rozroblyali "patches" that innovation for the server. The very stinks created the Apache Group, as they rozrobil the first version of the Apache server. It happened at the end of 1995, if all the necessary "patches" were applied to the base (NCSA Server 1.3). So this is the first official huge release of Apache 0.6.2.

The work on the server didn't stop for a day, and it didn't take long to become one of the most popular. After a number of trials on 1 December 1995, version 1.0 appeared, stable and new. With the help of the successful tsikh rokіv i dosi Apache is completely free of cost. Possibly, this also signified the success of the server, even if, for the NetCraft tribute, Apache is installed on 67% of all servers in the world at once.

1.1 DescriptionApache

At the moment, two Apaches are being developed in parallel - versions 2.0 and 1.3. Another version recognized a significant number of changes, as if in the first place the kernels of the program and some important modules were stuck. Other modules written by third party vendors for version 1.3 do not work in version 2.0, "old" Apache is also supported. However, if you install Apache first, it will jump to the new version.

Apache is a fully functional web server that expands, re-enables the HTTP/1.1 protocol and re-enables with a valid code. The server can be run on all broader platforms. Prepared server files for Windows NT, Windows 9x, OS/2, Netware 5.x and desktop UNIX systems. With any fault, the installed configuration is simple. Apache is built for additional configuration text files. The main parameters have already been set "for locking" and work with more fluctuations. If you blame the defective functionality of the regular "Apache", then you may be surprised by the modules written by the Apache Group and third-party retailers. An important priority is those who actively communicate with koristuvachs and respond to all notifications about pardons.

The simplest function you can use to defeat Apache is to stand on the server and serve a great HTML site. When you cancel the request to the same side, the server will run the browser. When typing the address, the side is displayed - everything is simple.

The folding function, as laid down in the HTTP / 1.1 protocol, is the authentication of the hosts. For the help of staff members Apache serverє the ability to separate access to the song sides of the site for different koristuvachiv. It is necessary, for example, to create an administrative interface to the site. For this, the .htaccess and .htpasswd files, as well as the mod_auth and mod_access modules, are compiled. Koristuvachi can be divided into groups, and skin can recognize their access rights.

For subdivision of design and functional part of the site, as well as simple change of static objects, SSI* technology is used. It allows you to place all the information that is repeated in one file (for example, top.inc), and then insert it into the side of the message on it. Let's see if you need to change the number of rows in this information, you will have to change them only in one file. The Apache server supports this technology and allows you to beat the server-side inclusion in the general agreement.

Like on the same server installed operating system Since the Unix family and the Apache server have created a sprinkling of koristuvachiv, then you can create a small directory from them. More precisely, it will be created automatically at once with a pseudonym. Seek help from the mod_userdir module and the UserDir directive. So, for example, you can put the public_html folder in the home folder of the coristuvach at the address www.site.ru/~user. Zagalom so and fight on the servers of the most sites that provide cost-free hosting. The server administrator can either allow the administrators to create home pages, disable SSI and other functions of the server. Povnotsіnny hosting zazvichay transferring the creation of an okremny virtual server for skin koristuvach.

The Apache server was one of the first servers, so we started to improve virtual servers(Hosti). This ability allows hosting on one physical server a copy of full websites. The skin of them can be your own domain, administrator, IP address and so on.

If you need to host the domain.ru and domain.com domains on the server, then for the first time you need to do so, so that the IP address was assigned to the DNS system. What's next in configuration file Apache creates two directives Describe the skin of the virtual host. In this rank, the server will know, on the yak the folder "vіdpravlyati" is asked.

At the moment, the majority of Internet sites are dynamic. Tse means that the sho vnіshnіy vglyad i napovnennya is formed from the help of a program script, written by one of the "moves" їkh can be called movy all over the world, destined to do it smartly. At the moment, the most widely used technologies are CGI and PHP. Understandably, in Apache there is support for both, plus the ability to connect other moves.

The mod_cgi module allows hosting CGI scripts on the server. There are no more files written than one of the valid programming languages. The stench can be as if looking at the compiled one, for example, so shy, as if writing CGI in my C ++, so when looking at the output text, Perl is installed on the server, then the programmer can place and such files. Sometimes stinks may expand.

On the basis of the Apache server, you can create not only simple amateur sites, but also resources that are serious cryptographic zakhistu transferred data. The SSL/TLS protocol was broken up specifically for this purpose, and this support was introduced into Apache 2.0. For the help of a special module, you can set up authentication based on personal certificates, which allows you to sing-songly guarantee the correctness of the driver.

The Apache server can keep a record of suicidal actions, yakі zdіysnyuyutsya with it. The administrator can choose the details of the protocol himself. Protocols are kept for pardons, for successful surgeries and skin virtual host. .

2 . Information systems for a wake-up company

2.1 Information system 1C: Trade and warehouse

2.1.1 Program description

"1C: Trade and Warehouse" is a component "Operational appearance" of the "1C: Enterprise" system with a typical configuration for automating the warehouse appearance and trade.

The component "Operational appearance" is recognized for the appearance of visibility and change of material and penny costs. You can win both autonomously and in combination with other components of "1C: Enterprise".

"1C: Trading and Warehouse" is recognized for the appearance of any kind of trading operations. Zavdyaki gnuchkosti and mood, the system of the building is designed to improve all the functions of the appearance - in the form of conducting the final documents and the introduction of the first documents to the removal of the various records and analytical information.

Automation of any trade and warehouse operations

"1C: Trading and Warehouse" automates the work at all stages of business activity.

Typical configuration allows:

· conduct a rozdіlny managerial and financial appearance;

· To conduct oblіk vіd іmenі kіlkoh juridical osіb;

· to conduct a party appearance of the commodity stock with the possibility of choosing the method of writing off the co-vartost (FIFO, LIFO, for the middle one);

· to conduct a distribution of goods and goods taken for sale;

· Make purchases and sales of goods;

· Automatically posting documents on the basis of earlier data entry;

· to conduct a form of mutual frost protection with purchases and post-employees, details of mutual frost protection for other contracts;

· Form the necessary primary documents;

· Prepare account-invoices, automatically book sales and purchases, maintain a balance sheet at the VMD numbers;

· Reservation of goods and control of payment;

· to keep the appearance of cats on rozrahunkovy rachunks and at the kasі;

· maintain the shape of commodity credits and control their repayment;

· to keep the shape of goods transferred for sale, their return and payment.

In "1C: Trade and Warehouse" you can:

Task for the skin product is necessary to kіlkіst cіn rіznogo type, zberіgati cіni postachalnikіv, automatically control and promptly change rіven cіn;

Practice from mutual documents;

Calculation of the automatic repayment of prices for the write-off of goods;

Shvidko make changes for additional group processing of documents and documents;

keep the appearance of goods in different units of the world, and costs - in different currencies;

Take away nayrіznomanіtnіshu zvіtnu and analіtіchnu _informatsiyu pro ruh comradіv i pennies;

Automatically form accounting entries for 1C: Accounting.

apache information program automation

2.1.2 Work with different information bases

The main recognition of the work with different subdivisions of information bases is the organization of a single system of automated appearance at enterprises, which can be territorially distant objects: branches, warehouses, shops, points of reception local mesh:

· maintenance of an uninterrupted number of autonomously operating information bases;

· Povna or vibirkova synchronization of data;

· Nalashtuvannya warehouse synchronized data;

· Dovolny order and method of transferring changes;

Vykoristannya zasobіv administrating rozpodіlenimi іnformatsiynimi bases do not obzhuє dії koristuvachіv systems. If you change these data, the system automatically sends them automatically to the description of the synchronization rules.

The component "Management of the distribution of information bases" is supplied with

2.1.3 Hope and safety

"1C: Trading and Warehouse"

· Possibility of fencing koristuvacham "direct" access to information;

· Special mode of data withdrawal with control of cross-talk;

· Possibility of fences for koristuvachas to redagulate data for the past summer period;

· Installation of a fence for editing other forms of documents;

· "Zamikannya" system koristuvachim with timchasovym pripinennі roboti.

2.1.4 Flexibility and moodiness

"1C: Trading and Warehouse" can be adapted to any specific appearance on a specific business.

Before the warehouse of the system enter the Configurator, which allows you to adjust all the main elements of the system for the necessary:

edit the essential and create new necessary documents, whatever the structure

Change screens and other forms of documents

create journals for work with documents and quite reshape documents according to journals for efficient work with them

edit the essential structure

· Editing the authority of the dovіdnikіv:

· change the warehouse of requisites, number of rivniv, type of code, range of verification of the uniqueness of the code and create registers for the shape of the koshtiv in any necessary rosettes, create whether or not add-ons, and the procedure for processing information will be described in the system.

2.1.5 Іinterface

"1C: Trade and Warehouse" is supported by current standards in the interface of the koristuvach:

- "before the day" will show you the effective use of robots and the ability of the system

Service days can be "attached" to between the main days of the program

Headless menu of the system to "image" commands - also display the placement on the buttons of the toolbars

toolbar buttons can be labeled as thumbnails as well as text.

2.1.6 Openness and availability

"1C: Trade and Warehouse" to set up different manpower for communication with other programs.

Ability to import and export information through text files to allow the exchange of danim practically with any program.

In addition, the language has been introduced to avenge the work with files in the DBF format.

Also "1C: Trading and Warehouse" p_dtremuє today's wellness add-ons integration: OLE, OLE Automation and DDE. Wikoristanya tsikh zabіv allow:

· use the robot of other programs, vikoristovuyuchi vbudovanu mov "1C: Trade and warehouse" - for example, form the name of that graph in Microsoft Excel

· remove access to data "1C: Trade and Warehouse" from other programs

insert into the documents that name "1C: Trading and Warehouse" objects created by other programs - for example, place the logo of the company in the first document

· Razmіschuvat in documents and zvіtah little ones and graphics.

In "1C: Trade and Warehouse" a new set of standards was implemented: the exchange of commercial information (CommerceML) and the exchange of payment documents (1C: Enterprise - Client to the bank).

It gives you the opportunity: to form and vivantage commercial propositions on the Web - windows that support the standard of organizing electronic exchange with catalogs, price lists and documents with your counterparties exchange payment documents (payment receipts and bills: bank accounts) with systems data from the UNISCAN Association/EAN Russia.

2.1.7 Work with trading powers

"1C: Trade and Warehouse" provides for the operation of trading facilities: cash registers, receipt printers, scanners and barcode printers, electronic cards, data collection terminals, purchase displays and other types of possession.

"Intellectual" interaction with trade authorities allows, for example, to download documents and read the barcodes of goods with a scanner.

Additional components of the method of robotic trading with trading powers are being supplied okremno.

Variability of installation software vіdіznyаєtsya vіd kіlkostі working mіsts. For the installation, you will need additional data on the data bases for the provision of the system.

This robot is looking at a budding company, in which 40 working days are organized, the average number of one working month for 2016 is with the installation, and the cost of supplying the keys to the working month is ~ 17.5 thousand. rubles

2.2 Information systemCRM

Establish different concepts of CRM (Customer Relationship Management): some of them should be familiar with the methodology of running a business, and some - software for automating work with clients. І tі, th іnshі mаut ration. Let's put the right accents.

CRM - strategy. The term “Customer Relationship Management” can be translated by my Russian language as “customer relationship management”.

This literal translation reveals the truth, but not the slightest obvious picture.

As a matter of fact, CRM is a specific guide to running a business, when the client is put in the basis of the company's activities.

Therefore, the CRM strategy transfers the creation in the company of such mechanisms of interaction with customers, under any circumstances, may be the highest priority for business.

Similar customer orientation is not only central to the company's business strategy, but also corporate culture, structure, business processes, operations.

The main meta promotion of CRM-strategy is the creation of a pipeline to acquire new customers and develop existing customers.

Managing relationships means getting new customers, converting neutral buyers into loyal customers, forming business partners from existing customers.

CRM-system - the purpose of automation of CRM-strategy. An even more important role in the implementation of CRM-strategy in life is played by information technology.

CRM software is a specialized system, developed for automating the business processes themselves, procedures and operations, as implemented in a company's CRM strategy.

In the yakost key tool To win over those clients, CRM add-ons minimize the human factor when working with clients and allow increasing the transparency of activities in the areas of sales, marketing and customer service.

At that very hour, it is important to note that the automation of the process of contacting customers is important, but with a single and first line in the wake of a client-oriented company.

A software product is a handy tool that will become a part of the current regulations and processes, and will develop together with the company.

2.2.1 Automation of business processes

Lay out all the working processes on the fly, formalize them - a non-trivial task, as business analysts believe.

As all spіvrobіtniki due to regulated processes, the number of pardons changes, the company's work speeds up, and the results of the work become predictable.

Yakshcho vykonannya protsesіv є clear for kerіvnikіv, it's easier for them to reveal weak areas in robots and direct the sound of spivrobіtnikіv at the necessary channel.

Qi zavdannya can be done with additional automation of processes, with additional CRM-systems.

For formalization, automation and control of processes, Terrasoft CRM offers special tools. Business Analyst Estimate Handy visual editor which allows you to describe algorithmic processes in the CRM system, no matter how complex.

Managers will be able to indicate the vikonavtsіv that participants of the zavdanіv on the process, fix the vtracheny on the vikonannya of the next task hour, and the kerіvniki mаtimіt ability to analyze the efficiency of both the business processes themselves, and the robots of the workers.

For automation and operational control of the progress of the company's business processes, the CRM-system promotes the progress of their time and business processes.

New spіvrobіtniki more easily enter the course on the right, improved communication between vіddіlami. And the assessment of the efficiency of business processes will lead to the optimization of the company's activities in the blink of an eye.

2.2.2 Manage customer information

The "heart" of a CRM-system is the data base of both physical and legal systems, such as interoperability with your company within the framework of business activities. Not only the clients, but also the companies, partners, employees, competitors.

The database of clients is a valuable asset in itself, and competent data management in the CRM system allows you to extract information in robots with maximum efficiency.

The client base is consolidated, the organization is removed new information about their clients and their advantages, basing themselves on these information, the future strategy of mutual modality.

A single database of clients' data and a complete history of mutual interrelationships with them in the aggregate with sophisticated analytical tools CRM allows you to minimize and develop your main clients, revealing the most important ones, as well as gain new clients.

2.2.3 Sales management

The main function of the CRM system is to help managers plan sales, organize the review of property management and optimize sales channels.

The system saves the entire history of communication with customers, which helps sales departments to analyze the behavior of customers, form relevant propositions, and win loyalty.

Sales planning in the CRM system is organized in different areas (by regions, managers, etc.). The manager develops a plan based on the data of his clients and improves their ability, and the clerk, having analyzed the confirmation of payments, can create an incentive plan for the manager.

Ker_vniki vysuvayut osoblivi vomogi to CRM. For additional tools of the CRM-system, the clerks can control the performance indicators of the manager's work (sales funnel), the monitoring of sales plans, the completion of payment terms and delivery.

The system allows you to evaluate the quality of goods, check business processes of sales, follow the camp to please and analyze your competitors.

One of the most important tasks, which helps to improve the CRM system is the organization of cross-sales, up-sales.

The system allows you to form a cross-sales matrix and a product-segment matrix, group customers according to different parameters and show their potential interests.

Supporting tools for forecasting and analyzing, automating the interaction between contacts with customers and among themselves, the CRM system forms a rethink for optimizing the main channels and increasing the profit of the company.

2.2.4 Product portfolio management

Whether it be a commercial organization, it is important to offer high quality products at competitive prices, to improve product lines.

The CRM-system allows you to structure the nomenclature and keruvati with a complete catalog of goods and services of the company. The ability of CRM to ensure the appearance of special prices and discounts, analysis of data and interrelationships for proposing to customers the optimal package of services and the appointment of popular products.

2.2.5 Working hour management

Efficient management and the appearance of the working hours can have a positive impact on all business processes of the company. The CRM-system allows the employees of the organization not only to keep records of the current working hours, but also to plan for the upcoming period.

CRM-systems provide manual access to the layout, in which case the worker can plan his/her working hours, to evaluate the results of the planned work, review the layout of colleagues. At their own discretion, at the disposal of the kerіvnitstva, there are tools to control the engagement and efficiency of the work and the support.

Zavdyaki possibilty po'yazuvati all zavdannya z vіdpovіdnimi contractors, contacts, favors are formed and accumulated history of work with the skin client.

The generation of 80% of the task automatically according to the business process allows you to call for help during routine operations, the most rationally spreading the working hour, and do not forget the important work.

2.2.6 Automation of document management

CRM system delivers everything necessary tools cheruvati as zovnіshnіm, i vnutrіshnіm dokumentoobіg pripriєmstva. Tsі іnstrumenti nadavat zabob automatic formation of documents for templates, preparation of other forms of documents, versioning of documents, shvidkoy poshuk documents in the system, the creation of an electronic collection of documents and a lot more.

Under the hour of management in CRM documentation, it is possible to organize a collective work with documents with a flexible separation of access rights, electronic viewing, as well as vzahuvannya vzaymozv'yazykіv between documents.

2.2.7 Analytical capabilities of programsCRM

It is impossible to increase the profitability of business without a deep analysis of information about customers, their value and supply, the manifestation of "higher education institutions" in the company's business processes, analysis of the sales system. The CRM-system allows the company to take statistical information, conduct folding analysis data that is necessary for making strategically important business decisions.

Over 100 standard system calls give the ability to analyze and control all types of business. For the help of a wake-up caller, you can create analytical forms that support specific tasks of skin administration.

In addition, on the panel of summaries of the CRM-system, you can view KPIs (key indicators of activity), analysis of which will allow the dermatologist to evaluate the effectiveness of the skin practitioner.

Tsya software security is installed at the budіvelniy company at once from software 1C. For the development of changes, writing programs, installation, integration into 1C, and zastosuvannya on one working space, ~ 10 yew will be stained. ruble

Listed on Allbest.r

Similar documents

Analysis of the creation of the information system. Analysis of the basic systems of maintenance by data bases of a repair and service company. Wimogi to the warehouse and parameters of technical specifications. Program system structure Description of input and output information.

course work, donations 04/29/2015


The creation of an automated system for the appearance of a design and its development at a budding company for the repair of apartments. Zagalni vomogi to the information system. Database structure design. Pobudov ER-diagrams. Implementation of the information system

course work, donations 03/24/2014


Description of the management structure. The structure of software and hardware zasobіv. Analysis of the technical task. Razrahunok uzgalnenogo criterion of efficiency of the information system of project management in the hospital company. Select movi programming and DBMS.

thesis work, donations 06/29/2013


Software products Microsoft Access, Visual FoxPro7.0, dBASE Database management systems (DBMS), their main functions and components. Work with data in table mode.

course work, donations 12/15/2010


Stages of designing information systems. Corporate information systems, development trends. Vymogi to organize the database of data. Basic concepts of relational databases. Select system design. The logical structure of the program.

thesis work, donations 12/20/2012


The main classifying signs of the system of reference by data bases. Model danih, kind of programmed character її vikoristannya. Make programming for professional retailers. Organization of data processing centers at computer facilities.

presentation, donation 14.10.2013


Features of economic information management. Understanding the functions of a database management system, subtracting from a standard relational engine. Make arrangements for databases and work with them. Database management systems of the economy.

control of the robot, additions 11/16/2010


The emergence of a system of keruvannya data bases. Stages of designing the data base "Budіvelna firma". Infological and datatological model of data. Wimogi to the information software system to work with the data base "Budivelna Firma".

course work, donations 03/31/2010


Designated CRM as an information system, recognized as an automation of business processes in a company, as it ensures the interaction of all її updates with customers. Classification of systems: operational, analytical and collaborative.

course work, donations 06/05/2014


Logical design of the data base from the automation of the activity of the business company. Classification of calls. Relational model of the data base Functional deposits between attributes. Select keys. Normalization of vіdnosin. Drink to the base of data.

Entry

Forward analysis of the IC fold

1 Organizational structure

2 Vіdomostі about the object of automation

3 Obgruntuvannya need to create an information system

Description of the software product

1 Description of input and output information

2 Analysis of basic database management systems

2.4 Visual Basic

3 Wimogi to the warehouse and technical parameters

Description of the main design solutions

1 Structure of the software system

2 System testing

Visnovok

List of references

Entry

Tsey coursework project of vikonaniya vіdpovіdno to zavdannya on the course projectuvannya. The theme of the project is the development of an information system for a repair and service company.

Z tsієї meti squeal like this zavdannya:

Analysis of the subject area and activity of the organization.

Selection of the main set of data required for the compilation of the data base and the compilation of the infological model;

Practical implementation of the data base.

Creation of additional elements for simplification of work with a data base (creation of forms, requests and calls).

The main factors that contribute to the efficiency of this type of work, enterprises of this type are the organization of effective cooperation between the substitutes and the factories with the manufacture of components.

I have selected the following processes for the automation of communication: the appearance of components and consignments, the acceptance of the order, the appearance of partner firms and clients.

The database allows you to add, change, search for data, and also look at data.

1. Forward analysis of the IC valve

1 Organizational structure

The company vikonuє the whole complex of works for the manufacture and installation of metal-plastic window systems. The main types of activity are: assembly and installation of plastic windows and doors, window portals, blinds, as well as metal installations of forged gratings to the opposite doors and garage doors.

One of the direct activities of the company is the preparation and installation of plastic windows, as well as folding balconies.

Vyhodyachi zі svoїh possibilities, tsіley that zavdan, kozheny zamovnik can choose for yourself optimal option Vicon PVC:

color vikna, what to laminate;

vikna that self-purify;

sonceasis vikna;

mid-day break;

arched windows;

color pіdvіkonnya;

mowing ovnishni, including mowing from metal;

screened balconies.

The enterprise can sell to the patrons the components, which are necessary for the repair of window structures, doors, blinds.

The business management system was inspired by the linear-archarchical principle. On the skin level, the zones of viability and the zone of order are clearly marked.

The general director is responsible for the work of the firm. It is on the General Director's responsibility to carry out the main negotiations with the senior post-employees and in a row of vipadkiv - with the senior deputy (if it is especially significant for the company). The director is responsible for the purchase of components, and the cost of the purchase is paid for by accounting. Vіn vіdpovіdaє for mozhlivі reclamations vіd zamovnikіv yakіst vykonanih robіt.

Accounting is responsible for the entire financial activity of the company. The main functions of accounting are the payment of salaries and bonuses to workers with the necessary sums to the pension fund, to tax organizations. Payments for services given to the company and vikonnі work go through the accounting department. Through accounting, the equipment that the company buys is paid for.

The operator of employment by the reception of the lock, rozpodіl zamovlenya at the repair team, the workers of the transport service, the appointed term of the post-mortem, following the progress of the post-mortem, informing the customers about the post of the post. Operators keep documentary support of the engagement, fix the main information about the deputy and the engagement.

The repair team accepts the repair works, installation, dismantling, installation and insulation of windows and windows portals, doors, glazed balconies and other works. Її fahivtsі also diagnose inaccuracies, determine the necessary work, equipment for replacement and the hour for vikonannya robit.

The transport service arranges delivery to the replacements for repair, as well as the transportation of components from the postal worker.

2 Vіdomostі about the object of automation

The purpose of the ІС is the automation of the work of the advancing subdivisions:

Operator (formation of the order, appearance of the work and appearance of the configuration of the design, as well as acceptance of applications for purchases);

Repair brigade

The process of receiving this prayer can be briefly described in the following terms:

appointment, chi є klієnt by the postіyny zamovnik of the company (postіynі zamovniki otrimuyut znizhki on goods);

Early appointment of the day of the zamovlennya (zamovlenya) fallow according to the client's needs;

Vyznavchennya vikonavtsya zamovlennya. The operator has his own check in the magazine. Vіn zvertaєtsya before that master, who, in the opinion of the operator, is the least busy. However, at the time of the actual employment of the master, the operator redirects the application to another;

Making a request for a given form; fixing the withdrawal of prepayment; filling in the magazine;

Type of invocation, issued by the operator of the invocation along with it.

3 Obgruntuvannya need to create an information system

One of the factors that determine the rate of development of the current state of mind and intellectual capacity is the equipment of its counting technique- bases of automation of rozumovoy activity. The scope of EOM selection of any flooring is wide, but there is no such area, where EOM stagnation would be underestimated. Particularly important is the role of EOM in the development of science, the growth of industrial production and the promotion of efficient management. Managing various processes behind the help of a computer allows you to reach more high productivity and save a lot of time. The high automation of technological processes significantly facilitates the work of the enterprise and the production of fire.

Z development committee computer technology The need for saving and exchanging information has grown. Її zberіgannya plays an important role in robotic people and businesses. Adzhe vіd authentically correct and available information to lay down the success of yoga work. Deyakі organіzаtsії vykoristovuyut for tsgo shaffi with folders, and more importantly vvazhayut for better computerized ways - data bases, which allow you to efficiently save, structure and systematize great obsyagi danih. Today, without data bases, it is impossible to reveal the work of more financial, industrial, trade and other organizations.

The automated system is recognized for handy work with data. If you provide information, from which you can bring your mother to the right, do it great, but you can do it with a collapsible structure, then there are few problems with the organization of work. To overcome various problems, it is necessary to develop such a system of work with information, so as to implement automation of selection, processing and work with data. It is useful when zastosuvanni spetsializovanogo software - data base management systems (DBMS). The stench allows you to solve the problem on a greater level, to ensure efficiency, reliability, flexibility and lightness in victories, both for fahivtsiv, and for retailers-pochatkivtsiv.

The main pass of the automatic recovery - Skorchennya Uzmіrnosti Zberezheni Dani, and the Ozhee, the Ekononiye of the Osheguga Pam'yatі, Zmensny Vitrat on the Bagatorzov Operations, the Nadlishki of the Speers of the Supervisor of the Subroinths in the Riznikh, information and increased security of processing information; overworld number of internal intermediate documents, various journals, folders, applications, etc., re-introduction of one and the same information to various intermediate documents. Also, the hour of automatic search for information will pass significantly, which is prepared from special screen forms, in which the parameters of the search for an object are specified.

Modern DBMS - insurance on a rich data base management system, as they specialize in managing an array of information with one or an anonymous one at a time working on a data base.

Modern DBMS secure:

Nabіr zasobіv pіdtrimki tables і vіdnosin mіzh pov'yazanimi tables;

Responsible for the interface of the koristuvach, which allows you to enter and modify information, search for messages and present information in a graphical or text mode;

make the programming of a high level, for the help of which you can create good programs;

Improving the efficiency of retrieving stellar information for analysis.

In today's minds, great organizations have created effective and efficient information systems that serve the process of preparing and accepting accounting and management decisions, as well as virishal tasks: processing data, processing information.

In order to determine the efficiency of the internal company management system on rich business enterprises in the guise of that zvіtnostі becoming vikoristovuvatsya pokaznik vіdnoshevanny pributka to vytrat on tekhnіchnі zabіbі and zazpepechennya funktsiónvanâ vіshnyоємімоїції іnformа.

The main principles and goals of internal company information systems are:

vyznachennya could up to zmіstu іnformatsії її її character, zaleno vіd tsіlespravovanostі;

the development of the savings system, the adoption of that information in the centralized and decentralized management;

vyznachennya needs of technical zasobah (among them, at computer tekhnіtsі) on the undertaking;

software development, creation and selection of data banks;

automated processing of the entered and current information and the type of information from the accounting form and the input of the technical equipment;

automation of administrative and management work with the improvement of computer technology.

Important tasks of the internal company management system are:

coordinating the activities of the collection and processing of data on financial information on the most important level of management and at the production departments with a method of increasing the quality and timeliness of financial information on the enterprise in general;

designation of the main directives of the system of collection, processing and collection of primary data;

designation of the main directions for the development of technology for the processing of information.

Equipped with electronic technology allows you to save on management and bills of lading, ensuring efficient internal company planning.

The development of telecommunication systems, zocrema, technologies of local accounting measures, made it possible to unite all the technical features of the processing of accounting information into a single internal company information measure.

Representatives of the repair and maintenance company win at their work most importantly Microsoft Office programs, electronic software Excel tables for the maintenance of simple single-table databases in the form and search for information from these databases. The back-up discipline is not established by the corporate rules, so the back-up saving is due to the way to write the files on a laser disc for the court of a kerivnik.

The need for the development of an automated information system in the form of business activity is motivated by competition over the market of repair and service services and the need to ensure the efficiency of work, more reliability and accessibility, security, information

The study of the basic information processing system revealed the need to improve the actual processing of data, and the analysis of the situation made it possible to determine such a potential for directing a complete information processing system:

the adoption of obvious organizational and technical shortcomings, transferred from the front division, would allow us to meaningfully translate the current processing of information into a higher modern day;

the implementation of a single information system will enable me to practically increase the efficiency of the work, to be more efficient in the "manual" processing of information and switch to an automated form;

Vykoristannya _individual ІС usuvaє nedolіki PZ, recognized for the automation of business.

Shards of the development of an integrated automated control system as a distributed data base are collapsible and expensive, which require significant resources, including the team of viconists, to be promoted at the first stage of the project, which violates the low private enterprise.

2. Description of the software product

The object of distribution - the information system "Budivelna Firma", is recognized for the collection of that work with information about the work, as a way to collect the company's employees on the client's request.

The main stages of the design of the IC "Budivelna Firma":

high-profile system design;

Data structure design: select fields included before the table;

Designing and linking tables;

Field design: rules for data entry and verification of the admissibility of their values;

Designing requests;

Designing forms and sounds;

Design of automation tools: menu creation.

1 Description of input and output information

ІС "Budivelna Firma" to avenge the following facts:

Day of the "Postachalniki" - to collect information about companies: name of the company, address, location, address, telephone, location, fax.

Day of "Spivrobitniki" - to collect information about spivrobitnikiv: PIB, settlement, date of birth, date of employment, salary, addresses and telephone;

The day of "Remembrance" - to send information about the invocation: name, color, material, description, rozmir, varity, quantity, installation, dismantling, delivery, reduction, at a time;

Day "Clients" - to collect information about clients: ПІБ, addresses and telephone, caller, date of appointment, date of termination, form of payment;

Day "Complete" - to collect information about the goods: name, brand, postal order, color, material, unicity vimir, price and description;

Day "Type" - to collect information about the types of goods that are hoped for: name and description;

Sutnіst "Form of payment" - mіstit іnformatsіyu about the ways to pay for the goods that are bought: payment form, description;

The essence of “Vitrati” is to avenge information about the vitrati of firms, and to itself: the sum of vitrati and the method of payment.

Day "Pributok" - to collect information about the profit of the company for the last day.

The software security fails such tasks: the appearance of the components, the data on the protection, the maintenance of the stars.

In the mode of form, it is possible to add new information to the information base, add new components, edit information, implement input ordering by fields, send a search for information about components, and add that replacements.

Expanded software security is used to automate the appearance of components, to collect information from the data base, as well as to store calls.

The program warehouse includes the following functions:

Forming and appearance of applications;

keep the appearance of components;

Addition, editing and visualization of information;

Storing calls;

Druk zvіtіv;

2.2 Analysis of basic database management systems

The modern DBMS is more important than Windows add-ons, the shards of the medium allow for more victorious possibilities of the personal EOM, the lower DOS medium. Зниження вартості високопродуктивних персональних комп'ютерах зумовив не тільки широкий перехід до середовища Windows, де розробник програмного забезпечення може меншою мірою піклуватися про розподіл ресурсів, але також зробив програмне забезпечення ПК загалом і СУБД, зокрема, менш критичними до апаратних ресурсів елетронно-обчислювальної машини.

Among the best representatives of database management systems are: Lotus Approach, Microsoft Access, Borland dBase, Borland Paradox, Microsoft Visual FoxPro, Microsoft Visual Basic, and databases danih Microsoft SQL Server is the Oracle that wins in programs inspired by the "client-server" technology. Let's take a look at the presentation of Microsoft software products, Visual FoxPro, Paradox, Visual Basic, Visual C++, Access 7.0.

2.1 FoxPro (Fox Software) is notable for its high swidkish characteristics and in this respect it has been seen among interpretive systems. Equalized with dBaseIV її svydkіst y kіlka razіv vishcha i єєєєєєєєєєє svydkіstі sistem-compilerіv. Practically behind all ostentatious Fox-programs, it is significantly better than Clipper-programs. A set of commands and functions, proponated by the FoxPro rozrobniks, for the tightness and the gnuchkistyu, it will be possible for them to be presented before the data processing. You can implement the most convenient and efficient interface of the koristuvach. FoxPro has different mergers bagator_vne_ menu, work with the mouse, the implementation of the function of low-level access to files, color matching, printer settings, data can be presented in the view of "spreadsheets" and richly acceptability and handiness. In the "pre-industrial" era of FoxPro, the best-known, most efficient and most advanced DBMS for computers to the IBM PC standard.

2.2 Paradox was released by Ansa Software, and the first version was released in 1985. This product was handed down by Borland. Since 1996, the fate of the company Corel and warehouse Corel Office Professional. For example, the 80s - on the cob of the 90s rock Paradox, which lies with the same company Borland International.

Paradox's data storage principle is similar to dBase's data storage principle - the skin table is stored in its own file (*.db extension), MEMO and BLOB fields are stored in a separate file (*.md extension), and indexes (*.md extension). px).

However, in dBase's view, the Paradox data format is not acceptable, so access to data in this format requires special libraries. For example, among add-ons written in C or Pascal, the Paradox Engine library was popular, which became the basis of the Borland Database Engine. This library is found in some of the add-ons created for the help of Borland (Delphi, C++Builder), other call generators (for example, Crystal Reports) and in Paradox itself. Update and ODBC drivers to databases created by different versions of DBMS.

У порівнянні з аналогічними версіями dBase ранні версії Paradox зазвичай надавали розробникам баз даних істотно більш розширені можливості, такі як використання ділової графіки в DOS-додатках, оновлення даних у додатках при розрахованій на багато користувачів роботі, візуальні засоби побудови запитів, на основі інтерфейсу QBE - Query by Example statistical analysis data, as well as the ability to visually stimulate the interface of coristuvate add-ons with automatic generation of my PAL (Paradox Application Language) programming code. . Such a possibility of paradox's shortcomings was taken away by the hackers of the Borland Database Engine library and SQL Links drivers. Tse allowed Paradox to win as a universal task of managing various data bases.

2.3 Access - in translation from English means "access". MS Access is functionally the same relational DBMS. In addition, MS Access is one of the most difficult, flexible and simplest DBMSs in the world. You can create more add-ons without writing the same series of programs, but if you need to create more smoothly, then for this MS Access step, I’ll try my best to program - Visual Basic Application.

The popularity of the Microsoft Access DBMS is driven by the following reasons:

Access is one of the most accessible and sensible systems both for professionals and for koristuvachiv-pochatkivtsiv, which allows you to quickly master the basic principles of work with data bases;

the system may update the Russian version;

Full integration with Microsoft Office packages: Word, Excel, Power Point, Mail;

Ideology of Windows allows you to present information barvisto that directly;

the possibility of using OLE technologies, which allows you to establish links with objects in other programs, or to transfer objects to the Access database;

WYSIWIG technology allows you to constantly check the results of your activities;

Іnuє typing “majstrіv” from rozroby objects, which makes it easier to create a table, forms and zvіtіv.

Appointments for the creation of a sufficient form on the basis of various data and the development of non-commercial supplements. Minimum PC resources: processor 468DX, Windows 3.1, 95, NT, total RAM 12 (16) Mb, hard drive capacity 10-40 Mb.

2.4 Visual BasicBasic is a universal object-oriented language programming, dialects of which are introduced in Access, Visual FoxPro. Advantages: versatility, ability to assemble OLE components, low power to EOM hardware resources. Designed for the creation of programs of medium intensity, not associated with a high intensity of data processing, OLE component development, integration of Microsoft Office components. Minimum PC resources: processor 368DX, Windows 3.1, 95, NT, total RAM 6 (16) MB, volume used for HDD 8-36 MB.

The designation of software products may allow the visual design of the interface of the coristuvach, so that the retailer from ready-made fragments into the creation of the interface elements, the program only changes from the input to the be-yak_podії.

Borland has always been widely recognized by professional retailers as a company that promotes C and Pascal compilers, the Paradox database management system. Flying around the world with close to six million koristuvachs, dBASE is becoming the industry standard, staging up to various operating platforms, such as MS-DOS, UNIX, VAX/VMS and MS-Windows. Products that are developed in the programming classes - Borland C++ 4.5 and Delphi - with a unique combination of classical principles and modern technology.

Absolutely new product Borland Delphi for Windows is a software development system based on object-oriented Pascal. Delphi combines visualization tools for software development of add-ons, a highly productive object-oriented movie compiler, scaling mechanisms for accessing data, and other remaining access in the computer technology room. C++ is the most stressful object-oriented language programming, but not the least functional. Appointments for the creation of program components for the execution of operations that are critical for security.

For the creation of data bases, as well as the software itself, that it is possible to expand, that it allows access to data bases, Microsoft Access 2007 requests for the collection of data.

The data base at the warehouse of the automated system, which is being developed, is guilty of advancing attacks:

zberіgannya great obsyagіv actual and reliable information;

the simplicity of bridging to the database;

the possibility of introducing, changing, removing, sorting and other manipulations from the data of the database;

search for information from different groups of signs;

the possibility of expanding and reorganizing data in the database with changes in the subject area.

All that has been said is more to say about the need to use the DB and vodpovidno specialized systems database management (DBMS).

Grunty in the grossing of the CCTs VIBOR VIBORY, BUV Vibir's brows on MS Access 7.0 cinnamon, Oskilki is not necessary for the DBMS of the Small Corporate Merezhi, INNOMENSIA ONTH, ShO ZBEYTYASY LIGHT (VIMIRYUSHICHED. Also, MS Access 7.0 shows minimal complexity when setting up and administering the system.

3 Wimogi to the warehouse and technical parameters

For work with IC "Budivelna Firma" a computer with the following minimum configuration is required:

Processor - 300 MHz or more;

RAM -128 MB or more;

Video adapter and monitor - Super VGA (800×600);

Free space on a hard disk - 1.5 GB or more;

Optical storage devices - CD-ROM or DVD-ROM;

The keyboard is that mouse;

Installing Microsoft Office 2007

Minimum systemic help for MS Access 2007:

Processor: Frequency not lower than 500 MHz;

Memory: Not less than 256 MB;

Hard disk space: 2 GB;

Screen: Razdіlna zdatnіst no less than 1024x768 pixels;

Operating system: Microsoft Windows XP SP2, Windows Server 2003 SP3, Windows Vista.

In order to expand the IC function, copy the “Budivelna Firma” folder from the disk in the right place of the hard drive, after which open the folder and run the “Budivelna Firma” file on the icon.

Vrakhovuyuchi posibility of modern computers, tsі vimogi can be called declarative. MS Access 2007 ensures efficient work on any modern personal computer, which is equipped with business.

The following was chosen for IC: operating system - Windows XP Professional, DBMS and software development environment - Microsoft Access 2007.

3. Description of the main design solutions

1 Structure of the software system

When developing programs, an important stage is the designation and analysis of the structure of the program system. The program is to blame for the mother as a slanderous plan, for which there was a program appendage. At what stage should be treated with such mircovanations:

Information in tables may be duplicated;

Bazhano, that the skin table contained information on just one topic;

Information about the object bazhano razbivat on the minimum unit.

The structure of the database with information tables: Spivrobitniki (Fig. 1), Postal workers (Fig. 2), Completing (Fig. 3), Form of payment (Fig. 4), Clients (Fig. 5), Rozstrochka (Fig. 6) .

Malyunok 1 - Table "Spivrobitniki"

The Spivrobitniki table contains information about people who work for the organization.

Malyunok 2 - Table "Postachalnik"

The table "Postachalniki" contains information about companies that support the organization.

Malyunok 3 - Table "Complete"

The “Complete” table contains information about the goods, as a way to propagate the organization.

Baby 4 - Table "Form of payment"

The "Form of payment" table contains information about the payment methods that customers expect.

Figure 5 - Table "Clients"

The "Clients" table contains information about the patrons.

Malyunok 6 - Table "Rozstitchka"

The table "Rozstrochka" contains information about customers who bought goods for payment.

The scheme of the information system with different links is presented in small 7.

Figure 7 - Scheme of data

2 System testing

To carry out the test, it is necessary to choose the method of testing from the beginning. To test the system, you can test the following methods:

"White screen" method. Testing using the "white screen" method transfers the system as a "clear object" and allows you to look in the middle, focusing on respect for knowing more about specific software security for the correct selection of test data.

"Black Screen" method. Testing by the "Black box" method transferring the system as a "opaque object", in such a way, knowledge of the internal structure is clearly not victorious. Testing the cym by the method can be used to assess the re-verification of functional capabilities.

Ergonomics testing. A typical test for ergonomics is based on the fact that koristuvachs work with a prototype (or other system) a number of operations, while documenting everything that stinks and seems to stink. Such a test is carried out at the same time with one or the other dekіlkom coristuvacs, which can be done at once.

Testing growing integration. Tse without interruption the testing of the "stagnation" of new functional possibilities, as it is possible to add; it is necessary that the various components of the functionality be completed independent and practical, first all the necessary parts will be ready before integration into the system; designed by programmers and testers.

For testing the information system "Budivelna Firma" the "Black Screen" method was selected. Even testing the software using the "Black Screen" method, on the other side of the "White Screen" method, transferring knowledge only to a set of parameters that should be entered, and checking the output results, which way the program reaches these results is unknown. With such a test, the program code is not altered in any way, and there is no need for additional knowledge of the program, or a technical description.

Testing and adjustment programs were carried out on the basis of data taken from a repair and service company. Otrimanі results vіdpovіdat rozvyazkam taken zavdan.

For this robot, an analysis of the problem posed was carried out with the last її virishennya. It was taken into account that it was appropriated to proponate the theoretical material, which allowed it to be more and more quickly and quickly turned to the set goals and objectives.

The method of the program, which is being developed, was the development of the data base of the data of the business firm and its implementation, vicorist shell Access. As a result of the work carried out, the bula vikonana was won.

The meta bula was reached by the path of the successful vikonanny of the main tasks term paper: practical implementation data base in the Microsoft Access shell and the creation of additional elements for simple work with the data base (creation of forms, requesting that call).

At the process of robotics, the beginnings of the analysis of variability were added, and that knowledge was thoroughly taken away from the sphere of development of data base management systems for the purpose of a specific task.

The data base has been split up, which can significantly simplify the operator's robot, make it easier to take away additional information that is necessary for help workers.

emergency program management repair

List of references

1. D. Date. Introduction to database system. - M., St. Petersburg: BHV - St. Petersburg 1977. - 312p.

S. Glushakov. Basi data. - Kh., Folio, 2001. - 504 p.

P. Kimmel. Mastering independent programming for Microsoft Access in 24 years., M: Williams, 2000. - 448 p.

Ulman D., Widom D. "Fundamentals of relational databases", 2006

Bazhenova I.Yu. "Fundamentals of designing supplementary data bases", 2009

Kirilov V.V., Gromov G.Yu. «Entering relational databases», 2009

Thomas, Connolly, Caroline, Bigg. Basi data. Design, implementation and support. Theory and practice. - M: VD "Williams", 2003.

Karpova T.S. Data base: models, development, implementation. - St. Petersburg: Peter, 2001.

Automated information technologies of the economy: assistant / ed. I.T. Trubilina - M.: Financial statistics, 2006. - 416 p.

Petrov V.M. Information systems / V.M. Petrov. - St. Petersburg: Peter, 2007. - 688 p.

Phosby J. MS SQL Server 2008: management and programming / J. Fosby. - St. Petersburg: BHV - Petersburg, 2009. - 608 p.

It is often brought up that the main reason for this is high profitability in the middle in the region: even there, de pennies are still vistacha, there can not be a serious interest in complex automation - and so, movly, interest will appear at an hour, if through natural The market process will inevitably decrease in prices and, hence, the profitability of the future market, if the situation arises, only the one who cares the most is alive.

To your look, sound against the other: there, de pennies, there is more necessary security appearance, which allows corruption to disappear and to protect theft. And yet, the main reason for the low level of automation of business companies is the specificity of the hall: be it a business company, it will require automation over a large number of business activities, with which there is no need to support the economy.

Otzhe, what processes need to be automated in a budding company?

Control of profit and income

Contract management

Project management

Warehouse storage

Other automation

The largest number of diverse business processes that require automation, and the introduction of an acceptable software product for the business environment into the market, is, in general, a low rate of complex automation of business environments. It should be noted that, from the skin's edge, the business enterprise explores different options and automation. Be-yak budіvelnі the company step-by-step acquires computer programs that automate the work of various fіrodіlіv. Seen in other galleys, the “problem of hanging entry” here turns into the problem of tenfold entry - one and the same data are entered into different programs, in no way they are connected one by one. Navit it is important to evaluate the labor and financial expenses and spend the galleys in the aftermath of this I will become a reference. Obviously, as a way out of the situation it would be possible to promote the integration of various additives among themselves.

There are two ales here. First, through a large number of specific tasks and, obviously, possible programs for their automation, the appearance of a ready-made integration solution is small (impossible to transfer the integration of what is good to what is good). In another way, the degree of integrating such a quantity of products one with one can be even higher. It is notable that the “legs” of most projects with integration “grow up” to protect. Really, the economy is more summative - integration projects often wind up in the sum to create more, lower replacement of different programs for one, but still cover all the necessary tasks. Therefore, there are more post-employment management systems for turbovanie enterprises and the creation of a ready-made integrated solution for automating business companies.

Although the need for complex automation of the life-sustaining companies has been recognized by retailers-systems, it has recently been introduced to the market integration solutions for a large number of vendors. Let's look at the decision of the report.