AT The basis for organizing and maintaining accounting records of a pharmacy organization is the Federal Law “On Accounting” dated November 21, 1996 No. No. 129-FZ (as amended by federal laws No. 123-FZ dated July 23, 1998, No. 32-FZ dated March 28, 2002, No. 187-FZ dated December 31, 2002, No. 191-FZ dated December 31, 2002, No. 191-FZ dated 10.01.2003 8-FZ, dated June 30, 2003 No. 86-FZ, November 3, 2006 No. 183-FZ).

AT in accordance with the law,Accounting is a system for collecting, registering and summarizing information in monetary terms about the property, obligations of the organization and their movement through continuous, continuous and documentary accounting of all business transactions.

Given the legislative regulation, it is possible to distinguish 4 levels of regulatory accounting regulation:

2. System of National Accounting Standards (Unified Chart of Accounts for Financial and Economic Activities of Organizations).

3. Guidelines (Regulations on accounting, see Appendix 1).

4. Internal documents of the organization (Orders, instructions). Responsibility for the organization of accounting in organizations,

compliance with the law in the performance of business operations is the responsibility of the heads of organizations. The head has the right to introduce the position of chief accountant to the staff of the organization, who reports directly to the head of the organization and is responsible for the formation of accounting policies, accounting, timely submission of complete and reliable financial statements. The chief accountant ensures the compliance of ongoing business operations with the legislation of the Russian Federation, control over the movement of property and the fulfillment of obligations.

AT Depending on the structure of the institution (enterprise), types and volumes of activities, an accounting service can be organized that performs the following functions of accounting and control:

Control over the execution of the cost and income estimates of the organization; - control over the timely and correct execution of primary

documents; - control over reasonable and economical spending of funds in

in accordance with their intended purpose; - control over timely settlements with contractors;

- participation and control over the inventory of property and liabilities.

Accounting in a pharmacy organization is an integral part

and a link in the unified accounting system for the entire national economy of the Russian Federation. Accounting is maintained for the purpose of monitoring and controlling economic activities in the process of providing the population with drugs and providing parapharmaceutical services.

The basis of accounting is strict documentation. At the same time, the following accounting meters are used in accounting documents: natural - when accounting for material assets (pieces, kg, m, etc.); labor

- to reflect the amount of time spent on the provision of a specific medical service (days, hours, minutes); monetary - when registering data on heterogeneous accounting objects.

Accounting sets itself the following tasks:

- providing information necessary for management and control (both internal and external users), through continuous and continuous monitoring of the economic activities of a medical institution;

- control over expediency financial and economic activities;

- control over the safety and movement of material assets;

- control over the measure of labor and the measure of consumption in accordance with the approved standards, norms, norms and estimates;

- prevention of a negative financial result of economic activity and identification of on-farm reserves to increase financial stability.

Within the framework of a unified accounting system, there are the following requirements for accounting in healthcare institutions:

- accuracy and objectivity;

- clarity and accessibility;

- lighting of all accounting objects;

Profitability.

Questions for self-control.

1. Name the functions of the accounting service.

2. List the tasks of accounting.

3. List the requirements for bookkeeping

2.2 Subject matter of accounting

The subject of accounting is the movement of economic assets and their sources in the process of financial and economic activities of the organization. The objects of accounting are business assets (A), their sources (B) and business processes (C) (Fig. 2, 3).

HOUSEHOLD RESOURCES

Rice. 2. Household funds

A) means of labor transfer their cost in parts to the service performed and thus contribute to the course of the provision of the service (pharmacy building, commercial equipment, vehicles, household and production equipment, etc.).

Objects of labor participate in the process of the organization's activities once and fully transfer their value to the service provided to the consumer (medicines and medical supplies, containers and packaging, various types of energy carriers, household equipment, postal stationery, etc.).

Funds in the sphere of circulation provide material resources (money in the cash desk of the organization and on its settlement accounts, the cost of the service rendered).

SOURCES OF HOUSEHOLD RESOURCES

OWN

INVOLVED

Rice. 3. Sources of economic funds

B) Own sources economic assets - funds that are the property of the organization, receivables and profits of the organization.

Sources involved economic assets are funds temporarily owned by the organization that are used on an equal basis with their own (bank loans and credits, accounts payable, obligations to allocate funds to created reserves).

AT ) Business processes, as objects of accounting, within the framework of the management and economics of pharmacy, they are divided into the process of procurement and the process of selling goods (provision of services).

harvesting process- supplying the pharmacy with means and objects of labor, goods for sale.

The process of selling goods (providing services) – sale of medicines and other pharmacy products, provision of services for

production of extemporaneous medicines, as well as advisory services, services for organizing the circulation of medicines.

Questions for self-control:

1. Define the subject matter of accounting.

2. Define the concept of economic resources.

3. Give the concept of sources of economic funds.

4. Describe the business processes in a pharmacy organization.

2.3 Accounting method

The set of methods that provides control over the safety and movement of economic assets and their sources in the process of circulation of economic assets is called accounting method. In this context - objects of accounting

accounting, are the means of the institution, the sources of their formation and the process of performing work and providing services (Fig. 4).

So, for example, economic assets include such accounting items as: trade equipment, production equipment, medicines in retail trade or in a warehouse, organization's cash. The sources of economic funds include profit and authorized capital (own), accounts payable and targeted financing (attracted). Economic processes are represented by technological complexes for the procurement of raw materials, the sale of finished dosage forms or services for the manufacture of extemporaneous recipes.

ACCOUNTING OBJECTS

Household		Sources		Household
funds		economic		processes
			Procurement	Rendering
Funds	Non-production			parapharm.
production
				implementation
				medicines
Funds in the field		Own	Attracted
appeals				Production

Rice. 4. Objects of accounting

The speed and quality of customer service, optimization of accounting and replenishment of inventories, the ability to quickly monitor and regulate the level of retail prices and many other aspects that affect the final result of the pharmacy are always relevant. It is impossible to survive without considering these factors. What then to say about the current situation, when the problem of the struggle for the buyer has long been the most urgent. The desire of managers to use every opportunity to increase the competitiveness of their business has increased dramatically. In particular, the demand for various computer and software solutions has noticeably increased, allowing for the comprehensive automation of the entire cycle of pharmacy activities.

A pharmacy as a trading institution is characterized by a high degree of accountability. Given the significant volume and rate of turnover of goods, the specific requirements for its storage and sale, it is very important to establish a quick and high-quality collection, processing and analysis of information related to the commercial activities of the pharmacy. This can be done through the introduction of automated control systems that make it possible to combine the entire process of goods turnover - from ordering the next batch from the supplier to the moment of sale and accounting of funds received from it.

The software product is an information system designed for comprehensive automated accounting and analysis of the movement of all categories of goods in pharmacies or pharmacy chains. They cover all aspects of the pharmacy and take into account all the features of its work.

These are the advantages of the system noted by pharmacy workers who have been successfully using the software product in everyday practice for a long time. Firstly, it is a full accounting of goods in real time with the maintenance of the necessary financial documentation. You always know exactly the profit and balance of goods in any department of your pharmacy, you can control purchases, dispensing, assortment and retail prices of goods. Naturally, all this reduces labor costs, simplifies the work of pharmacists, and the management of the pharmacy allows you to optimize the assortment policy of the enterprise, getting rid of "ballast" positions and reducing the amount of inventory to the required minimum. For example, an inventory, if necessary, can be carried out in just a few hours. The reports generated by the system make it possible to timely identify possible errors, simplify accounting and provide analytical information for the pharmacy manager. Any report can be created in a few minutes.

Thanks to the automated system, the work of the pharmacist-informer has accelerated. Information about the availability of medicines and prices is sent to the city certificate and to medical institutions. The system is easy to use, it allows you to quickly train staff on the job. In addition, the system provides the pharmacy with great analytical opportunities for planning its activities. For example, you can perform a full rating calculation for all medicines for a year in less than 5 minutes. Such a high speed of functioning is achieved, in particular, due to the fact that during operation the system does not create any temporary, unnecessary files, which is typical for many computer programs. Usually these files remain on the disk and slow down the program. A comparative analysis of the assortment is carried out taking into account the "break-even point" of individual groups of goods, the structure of sales volumes, the profitability of commodity items is determined. Thus, it becomes possible to plan sales volumes, commodity-cash flows, profits and costs.

The most preferable and beneficial for the pharmacy is integrated software and hardware systems, or automated control systems. Such systems make it possible to comprehensively take into account and control the financial and economic activities of a pharmacy or pharmacy chain, i.e. form complete and reliable information about business processes and results of the enterprise. And this, in turn, means the release of managers and accountants from tedious calculations, allowing them to fully concentrate on the analysis and business planning. Over the past years, the development of information products has been associated with the use of economic and mathematical methods for the implementation of marketing functions for predicting the consumption of pharmacy products, as well as for testing the market.

The automated system allows you to provide accurate knowledge of the profit and stock of goods in any department at any time (this is necessary in order to minimize the inventory in the warehouse, while maintaining an irreducible stock of medicines established by special lists).

Recently, the pharmacy has been using the “Suppliers” software package. The system is designed for automated accounting and analysis of the movement of pharmacy goods. It covers all aspects of activity - from the arrival of goods at the warehouse to its implementation on the trading floor. This program takes into account the peculiarities of the work of a pharmacy, allowing you to keep a subject-quantitative account of goods, financial control and operational monitoring of commodity balances. With the help of the program, contacts with suppliers are maintained and the order is updated. Rapid determination of real balances is one of the main advantages. In addition, the use of cash registers using bar coding as part of a software package simplifies the process of dispensing drugs and their accounting, greatly facilitates the work of pharmacists, improving the quality of control and reducing the cost of personnel errors. The delivery of goods to the pharmacy from suppliers takes several hours.

Pharmacies that purchase software are well aware of how important service begins to play in this case. In general, the system solves almost any problem of a modern pharmacy. But most importantly, according to its users, it allows you to make drug care really "emergency".

1

Management of a pharmacy organization requires the manager to skillfully combine the use of financial indicators obtained on the basis of the analysis of financial statements with other indicators to justify management decisions at time intervals when there is no completed reporting yet. This forms the basis of management accounting, which is considered as an internal information system that provides information for making management decisions and monitoring the organization's activities. Information for management accounting is formed on the same base as information for financial and tax accounting. The difference lies in the grouping of the information provided for making managerial decisions. The absence of a single standard for management accounting allows the formation of various approaches to the development of a management accounting system and methods of its command.

MANAGERIAL ACCOUNTING IN PHARMACY ORGANIZATIONS AS INFORMATION SYSTEM FOR ADMIN-ISTRATIVE DECISION-MAKING

Gavrilina N.I. one

1 Pyatigorsk State Pharmaceutical Academy

Abstract:

Pharmacy management organization requires the head of a skilful combination of financial indicators obtained on the basis of the analysis of accounting data, with other indicators to support management decisions at time intervals, when there is no more complete reporting. This is the basis of managerial accounting, which is considered as an internal information system that provides information for management decision-making and oversight of the Organization’s activities. Information for managerial accounting is formed on the same basis as the information for financial and tax accounting. The difference consists in grouping information for management decision-making. The lack of a single standard for managerial accounting enables you to generate a variety of approaches to developing managerial accounting system, and its dictates.

keywords:

Bibliographic link

Gavrilina N.I. MANAGEMENT ACCOUNTING IN PHARMACY ORGANIZATIONS AS AN INFORMATION SYSTEM FOR MANAGEMENT DECISION-MAKING // Scientific Review. Pharmaceutical Sciences. - 2014. - No. 1. - P. 17-17;
URL: http://pharma.science-review.ru/ru/article/view?id=12 (date of access: 02/01/2020). We bring to your attention the journals published by the publishing house "Academy of Natural History"

The task of information support for the accounting of medicines (drugs) and medical devices (IMN) among other tasks of informatization of the activities of medical institutions occupies a special place. It is the success of its solution that determines not only the correctness of accounting, but also the accuracy of planning the purchase of medicines and medical devices, as well as the rationality of spending the funds allocated for these purposes. Ideally, this task should be solved in a comprehensive manner within the framework of creating an integrated information system for managing the treatment process and the quality of medical care in a medical facility.

Accounting principles for pharmaceutical materials

Pharmacy information systems (AIS) are based on the following principles for accounting for pharmacy materials (medicines and medical devices):

The entire path of the movement of materials up to their write-off (for a specific patient) should be traced both in quantitative and in sum terms.

For purchased materials, AIS should provide full analytics in terms of funding sources, expense items, suppliers and manufacturers, product and pharmacological groups.

For used (released) materials - provide full analytics: by departments and offices; by nosology groups (based on the ICD 10 classifier of diagnoses, medical and economic standards or clinical and statistical groups); by categories of patients (compulsory medical insurance, contractual, employees, pensioners, etc.); for individual patients (invoices).

AIS should provide complete information on all the remains of pharmacy materials: in the central warehouse of the pharmacy, in the first-aid kits of senior, guard and procedural nurses, in other departments and offices.

Based on the accumulated statistical data, AIS should allow the formation of minimum stock standards for all or part of the product range, as well as purchase requisitions for the planning period (usually a year).

Materials must be controlled for expiration dates. Materials to be written off according to requirements should be automatically selected from started batches, and new batches should be selected by expiration dates.

AIS should support the possibility of targeted reservation of materials: in batches (reserve and superreserve), for certain groups of nosologies (for example, only for patients with acute heart failure), for certain categories of patients (for example, those receiving treatment under targeted funding), and even for individual (specific) patients.

AIS should take into account the work of the prescription and production department (including the printing of labels for finished dosage forms) with the possibility of automated write-off of components from the pharmacy warehouse and registration of finished dosage forms.

AIS should track the placement of materials in warehouse storage areas with full analytics on them and printing product (shelf) labels.

It should be provided for the formation of all necessary documents accompanying the movement of pharmacy materials: receipt and expenditure invoices, requirements from departments, applications, inventory lists, detailed and aggregated reports on the movement for an arbitrary period.

AIS should provide physicians with the ability to fulfill medication prescriptions based on information about the availability of drugs in their department and in the central warehouse of the pharmacy, as well as the ability to control the write-off of medicines by nurses for patients.

5.3. Independent work on the topic:

1. Viewing the lecture-presentation "Irkutsk Diagnostic Center" on the distance learning website.

2. Acquaintance with the interface and main features of the MIS qMS.

3. Watching the video "Medical laboratory".

4. Performing independent work "Overview of medical information systems."

End of work -

This topic belongs to:

Collection of guidelines for students for practical exercises for the specialty 060101 - General Medicine (full-time education)

of the Russian Federation.. SBEI VPO KrasGMU named after prof. VF Voino of the Yasenetsky Ministry of Health of Russia.. Department of Medical Informatics and Innovative Technologies with a course of software..

If you need additional material on this topic, or you did not find what you were looking for, we recommend using the search in our database of works:

What will we do with the received material:

If this material turned out to be useful for you, you can save it to your page on social networks:

tweet

All topics in this section:

For students to practical classes
in the discipline "Medical Informatics" for the specialty 060101 - General Medicine (full-time education)

The Importance of Studying a Topic
The study of these aspects will lay the foundation for further effective study and use of informatics in the modern information society. Developing skills and abilities to use

Human Information Activity
In the modern world, the role of informatics, the means of processing, transmitting, and accumulating information has increased immeasurably. The means of informatics and computer technology now largely determine the scientific and technical

The main areas of informatics are as follows
Theoretical computer science is a mathematical discipline that uses the methods of mathematics to build and study models for processing, transmitting and using information, it creates

Medical Informatics
Medical informatics is a scientific discipline, which is a system of knowledge about information processes in medicine, healthcare and related disciplines, substantiating

For computer science, a computer is not only a tool for working with information, but also an object of study. According to its purpose, a computer is a universal technical tool for a person to work with information.

Architecture of a modern personal computer. The main devices of a computer, their purpose and relationship
The easiest way to get a general idea of ​​​​a computer is to consistently reveal the functional purpose of one or another of its hardware components, paying special attention to the information interaction.

Laser printers
Laser printers use a laser beam to form an image. With the help of lens systems, a thin laser beam forms a latent electronic

Interface. Information systems interfaces
The interaction of the components of information systems, as well as the interaction of information systems with objects external to them (users, programs, devices) is carried out when

Independent work 2. Interfaces
Go to the electronic textbook "Medical Informatics". The electronic textbook is placed in the KIS KrasGMU (krasgmu.ru) in the section Resources, Electronic resources of the portal, Electronic educational

Interfaces
Interface name Image Interface purpose Main characteristics Connected device (for hardware

Generations of personal computers
Generation name Picture

Computer as a means of information processing
Task number 1: Computer service employees have prepared a list of computer products (components) that you need to purchase for the quality functioning of your

Computer as a means of information processing
A. The principle of the scanner. Flatbed and slide scanners. Scanner software interfaces (TWAIN, WIA and ISIS). Evaluation criteria for scanners. The use of scanners in medicine. B. Digital imaging

There are three classes of software products: § system software; § application software packages; § programming technology tools.

Functions of operating systems (OS). Windows OS, the evolution from the graphical shell to the operating system
The operating system is designed to manage the operation of user programs, planning and managing computer computing resources. The operating system is running

The evolution of the Windows family
Windows 3.0 Graphical shell for OS MS DOS. OS was not. Windows 3.11 Graphical shell for MS DOS OS with built-in

File system. File names and rules for writing them. File types. Association of files with software
At the heart of any operating system is the principle of organizing the work of an external storage device. Despite the fact that external memory can be technically implemented on different materials

Archiving and backup of information by means of OS. Programs - archivers. Archivers - programs that allow you to create and process archive copies

Personal computer software
Name Example of software tools Purpose of software tools Image (logo or screenshot)

History of MS DOS and Windows
OS name Creation date OS features OS interface image MS-DOS version 3.0

Independent work No. 3. Information archiving
Let's consider working with the archiver on the example of using one of the most common archivers at present, 7-Zip. Launch the Microsoft Word text editor through "

Independent work No. 5. Disk Cleanup of Temporary Internet Files
Run a disk cleanup of temporary Internet files. To do this, go to the Start menu. Select All Programs, Accessories, System Tools, Disk Cleanup.

Computer software
1. A FILE NAME CANNOT CONTAIN: 1) a combination of Russian and Latin letters at the same time 2) characters \ / : * ? ") 3) characters - _ , . 4) Latin letters

Computer service software
1. A SPECIALLY ORGANIZED FILE CONTAINING ONE OR SEVERAL FILES IN A COMPRESSED OR UNCOMPRESSED FORM IS ... 1) a virus 2) an archive file 3) an archiver

Computer service software
A. NERO software package. Appointment. Capabilities. Application in medicine. Demonstration of the program. B. ABBYY Fine Reader and ABBYY Form Reader Software Packages Purpose. Capabilities.

Information search problem
There is a largely fair opinion that today the Internet “has everything” and the only problem is how to find the necessary information. The very open architecture of the Web contributes to the fact that it lacks

Working with search servers
When entering the main page of the search server, it is enough to type your query in the form of a set of keywords in the input field and press Enter or the button to start the search. Requests may contain any

Search rules
As a summary, let's try to give a few simple tips regarding searching on the Web: clearly define in advance the topic of the search, keywords and the time you are willing to spend on this search

Search for professional medical information on the Internet
At all times, information has been one of the key factors determining the development of medicine. Modern data are necessary both in the scientific and practical activities of a doctor. Search question

Boolean search
The most powerful mechanism for doing keyword searches on the Internet is the use of boolean search. Request processing, i.e. keywords entered in the search form, osu

Saving search results
A number of systems provide special tools for saving found articles or annotations on a hard disk or floppy disk. Usually files with extension .txt or .pdf are used. The first option is

Evaluation of the quality of Internet medical resources
To date, the number of medical resources on the Internet is estimated at tens or even hundreds of thousands. The quality of many of them leaves much to be desired. Medical content sites

Criteria for the quality of medical resources posted on the Internet
General information about the site. The purpose of the site and its characteristics. Head organization, founders, editorial board. Sources of financing. staff

Ethical and deontological criteria
In addition to the above criteria, it was suggested that certain ethical and deontological Principles should be followed. The initiator of their creation was the Swiss organization

What is MEDLINE
Index Medicus is published by the US National Library of Medicine (NLM), the unrivaled leader in the development of information services. In recent years, more than 3.5 thousand biomedical journals have been indexed there.

Access to MEDLINE
Since access to the database is a commodity, the creators of the database not only provide access to them themselves, but also transfer their databases to other holders (vendors) for a fee. Therefore, MEDLINE information can be obtained from

The principle of searching in a computer database
Almost every site uses its own "proprietary" interface and search algorithm in MEDLINE. Naturally, each tool needs to be mastered, so for constant and high search efficiency, you need to

Operational analysis on a clinical problem
This option is best implemented on the NLM/PubMed server. If you need to quickly find the most reliable information on a clinical problem (for example, on diagnostics), then you need to apply

Search results analysis
In an exciting search for literature, keep in mind the universal law of life's resistance to our efforts - Murphy's law. In the realm of stochastic effects, this law takes the form known as the law

Situational tasks
Task number 1: To solve a practical task in one of the disciplines, you need to conduct a detailed analysis of the existing literature both in Russian and in other languages.

Formulation of research results using a text editor
Text documents are executed using a computer on one side of a sheet of A4 white paper according to GOST 2.301-68 in Times New Roman size 14, the line spacing is one and a half

Formulas
Formulas are separated from the text into a separate line. If the formula does not fit on one line, then it can be moved after the signs of the actions to be performed, and the sign at the beginning of the next line is repeated

tables
Tables are used for better clarity and ease of comparison of numerical or textual material. The table, depending on its size, is placed directly below the text in which the given

Illustrations
Illustrations (drawings, diagrams, photographs, diagrams) are used in the text of the document to make the material presented clear and specific. Illustrations are placed directly after

Guidelines for working in MS Word
How to open a new document and start typing? 1. Click the File tab. 2. Press the button

Situational tasks

Working with non-printable characters
Goal: Replace non-breaking spaces with regular spaces and line breaks with paragraph marks. Remedy: 1. make sure the dock view mode is set

Creating titles for figures and tables
1. Cut out Fig. 1 and the caption to it “Fishing passion for the health of the soul and body” and insert it before the section Forming a healthy lifestyle. 2.Table and figures

Create an endnote
1. Copy the name of the literary source of the author Shukhatovich V. R. 2. Place the cursor in the text next to the mention of this source. 3. Go to the Links ribbon, Footnotes group,

Situational tasks
Task number 1: You have prepared an essay or term paper at home. But when you brought it to print, the text formatting changed. 1. For what reason is m

List and standards of practical skills
1. In a MS Word document, change the cell borders (thickness, line style). 2. In a MS Word document, remove a non-breaking space using AutoCorrect. 3. In a MS Word document, split a cell

Excel menus and toolbars
Unlike previous versions, Excel 2007 has a slightly modified interface. As in the Word editor, there is:

Work with sheets
Each workbook by default contains three sheets with standard titles; Sheet1, Sheet2, Sheet3. The choice of a particular sheet is carried out using the sheet tabs in the lower left

Entering information on a worksheet
You can enter two types of data in cells: formulas and constants (numbers, text, or date and time values). Before you enter data, you should consider how best to place it on the sheet. Convenient at first

Copying and moving cells
In the Excel editor, copying and moving data is carried out in the standard Windows way, which consists of the following steps: 1. Select one or more cells or part of the

Using Paste Special
Sometimes it is quite convenient to apply addition, multiplication, etc. operations to the data copied to the clipboard. In these cases, the Paste Special command is used, called from the context

Adding rows and columns
When entering data, the user will most likely encounter the need to insert an empty row or empty column into a table. In Excel, to solve this problem, you should do this:

Working with formulas and functions
The main advantage of the Excel spreadsheet editor is the presence of a powerful apparatus of formulas and functions with which you can perform mathematical, financial and statistical

Use of links
A link in the Excel editor uniquely identifies a table cell or a group of worksheet cells. The links indicate which cells contain the values ​​that you want to apply as

Mathematical, financial and other functions
For the convenience of the user, when building formulas, functions in Excel are divided into categories: database and list management functions, date and time functions, financial, statistical, text

Syntax rules for writing functions
The following are the rules that must be followed for the competent and optimal construction of a formula using one or more functions. If the function appears at the very beginning

Meaning of error messages
If an error is made when entering formulas or data, an error message appears in the resulting cell. #### - cell width does not allow displaying a number in a given format

Graphical presentation of tabular data
The construction of a chart begins with the selection of the range of the data that should be reflected. Then, on the Insert tab, in the Charts group, select the button for the type of chart you are creating (G

Building charts and graphs
Selecting a range of data is optional, but it simplifies the rest of the process. At the same time, data labels can also be included in the selection area.

Changing the source data range
To change the source data for constructing a chart, use the Select data button from the Data group on the Design tab. This will display the Select Image window.

Graphs
Graphs are usually used when it is required to determine the behavior of a function or process. Excel allows you to build 7 types of graphs, divided into 3 categories: graph, graph with a marker

List and standards of practical skills
1. In the MS Excel table, enter the formula for calculating the amount into a cell. Fill in several cells with numbers and use Excel to determine the average value of these numbers. 2. MS Excel table will add

Sorting and filtering
Sometimes tables can contain a fairly large amount of data, and this data will often be presented in the form of a list. In this case, tools such as a toilet are very helpful in the work.

About statistical functions
Statistical functions are used in data analysis. Using most of the functions in this category requires knowledge of mathematical statistics and probability theory. Rasche

Using the Analysis ToolPak
An analysis pack is an add-in (an add-on, an auxiliary program that adds special commands or features to Microsoft Office), i.e. a program

Creating a Macro in Excel with Macro Recorder
Working with the application can be more efficient if you use macros or VBA programming. Excel macros are created using the Visual Basic f programming language.

Menu-Developer-Stop macro
After the cell widths are manually defined, the worksheet will look like this. Go to another sheet, enter

List and standards of practical skills
1. In the MS Excel table, set up an autofilter and select information. 2. Record a macro. 3. Calculate the MAX, MIN, AVERAGE of a series of numbers. 6. Homemade

tables
A database table is similar to a regular table in which the rows correspond to the units of observation, and the columns correspond to the studied parameters of these units of observation. The units of observation can be people, l

Differences between database tables and regular tables
Database tables are similar in appearance to ordinary tables that we see in books or can be created in editor programs. However, they have a number of features and severe limitations that make e

Data types
Type 1. Numeric. Information represented by numbers. This type is divided into several subtypes. Type 1.1. Floating point number (Continuous). Odie

Search and selection of information
A database is a repository of information that can store anything from a few records in one table to thousands of records in many related tables. Regardless of the amount of information, the database

Creating the database structure
3. After you have created a new database, the program will automatically create a new table. Switch to table design mode: Home tab/Mode button/Design item

Create a lookup column with a fixed set of values
4. Let's make the "Gender" field so that when filling out the table, you can choose from two possible values ​​(male/female). There are 2 ways to create such a lookup column.

Situational tasks
Task No. 1: The database of patients is presented: Surname of the patient First name of the patient Patronymic of the patient Go

General guide to creating forms
Example 1.Create a form for filling in new personal data according to the model: 1. On the tab

General guidance on creating reports
Creating a report with the Report tool The Report tool is the fastest way to create a report because it generates a report right away, without requiring you to

Creating a report using the Report Wizard
The Report Wizard provides more options regarding the selection of fields to include in the report. At the same time, you can specify how the data is grouped and sorted, as well as include fields and fields in the report.

Editing Reports in Design View
Example #3 Let's add fields to the report created in example #1 that calculate the average value of the "body temperature on admission" field. To do this, in the navigation area, select the name

Situational tasks
Task #1: You are a medical practitioner who has decided to create an electronic database of your patients with information about tests, surgeries, allergic reactions, and

Computer modeling of physiological processes
Mathematical modeling of both normal physiological and pathological processes is currently one of the most relevant areas in scientific research. The point is that

Computer modeling of morphological processes
Biological models have less predictive power than physical ones. Biological modeling demonstrates model-driven emergence and change over time.

Computer modeling of molecular genetic and biochemical processes
Computer simulation of molecular genetic and biochemical processes is the youngest and most promising direction in the development of biomedical sciences. In this area of ​​knowledge continues

Automated medical decision support systems
In modern conditions, the provision of services to patients of medical institutions is carried out with the continuous development of information technologies, equipping medical institutions with new devices and devices.

Computer modeling in education
Practical classes are one of the most important components of biomedical education. Experiments in vivo and in vitro are widely used to help students acquire

Rat CVS (Cardiovascular System)
The Rat CVS program simulates an experiment on the effects of various drugs on the rat cardiovascular system. The program allows you to register changes in systemic blood pressure, yes

TheVirtualCat
The Virual Cat program simulates an experiment on the effects of various drugs on the cardiovascular and muscular system of a cat. The program allows you to register changes to the system arterial

Situational tasks
Challenge #1: Only one amino acid substitution in the beta chain of human hemoglobin is known to cause sickle cell anemia. Using the StarBioC program

Information systems of the territorial level
These software systems provide management of specialized and specialized medical services, outpatient (including clinical examination), inpatient and emergency medical care for the population.

General information about MIS IODC
MIS IODC was developed for functioning in medium and large outpatient facilities with various treatment and diagnostic departments (ultrasound, functional, radiation, laboratory, consultative

Doctors' workstations
In the doctor's workstation, you can see information about the patients who submitted the material. The doctor can get acquainted with the electronic protocols of previous services stored in the database. If you have a scan

Workplaces
The term "Workstation" (AWP) is one of the most widely used in computer science. According to GOST 34.003-90 “Automated systems. Terms and Definitions",

Overview of Health Information Systems (HIS)
Purpose of the work: getting an idea about medical information systems and their capabilities. Sources of information: 1) electronic textbook "Medical infor

General overview of informatization of Russian regions
The regional level of healthcare management occupies a special place in the system of organizing medical care for the population of the country. It is here that the transformation of the global goals of the state takes place.

Information resources of territorial healthcare
To date, the most valuable information resources of territorial health care include: databases of the insured population, a fragment of which is data on benefits

Single information space of the healthcare system and CHI of the region
A single information space is understood as a set of information that: · circulates within the boundaries of a particular system; operates on the basis of unified unified

Personalized registers
Personalized registries (population registries, databases and databases) contain information about certain groups of patients (occupational diseases, diabetes, narcology, etc.)

Problems of healthcare informatization
In particular, the following problems should be noted: existing information systems partially overlap each other in terms of implemented functions, are weakly connected structurally, support different

Socio-economic effect from the implementation of the project to create a UIS
The main socio-economic result of the creation of the system will be an increase in the efficiency of the activities of the Ministry of Health and Social Development of Russia, its subordinate executive authorities, the territory

Basic principles of legal regulation in the field of information technology
Work with information systems of all types is determined by the current legislation and, in particular, by Federal Law No. 149-FZ of July 27, 2006 “On Information, Information Technologies

Categories of information
The state itself owns the information of the first category and, of course, it is it that puts forward the requirements for its protection and controls their implementation. Relevant provisions enshrined

Organization of password protection
User access to the information resources of the computer and / or local area network of the enterprise should be allowed only after his identification by pseudonym (login) and password. When org

We looked at ways to prevent unauthorized access to information stored on a computer. However, a user who has successfully overcome the previous barrier is a potential source of

Cases of violation of information security
The realization of a threat (actual breach of security) becomes possible due to the existence of vulnerabilities. Vulnerability - some unfortunate characteristic of the system (software error, incompatibility

Common Attacks
1. Data interception. As the name implies, this attack, if successfully implemented, leads to data leakage. Interception of data such as usernames and passwords is especially sensitive.

Protection of information from the user
Detailed information on the topic of the lesson is available in electronic textbooks (Lessons and Medical Informatics). 5.4 Final control of knowledge: - answer

Information security and local area networks
Connecting a computer to a local area network (LAN) means a transition to more stringent information security requirements. This is due to several reasons:

Information protection in information systems
In the conditions of use in the institution of information systems for collective use, the most important object of information protection is their databases. Therefore, all

Electronic form for filling in information on the conference
Theme and number of the report Full name of the speaker Score for the speech and answers to the question (maximum 5 points) The final score of the participant

Tele-learning (distance learning or tele-education)
Tele-education implies the introduction of telemedicine teaching methods into the continuous system of medical personnel training (telementoring). A feature of the direction is the introduction of telemedicine

History of telemedicine
In Sweden in 1905, an electrocardiogram signal was transmitted over telephone lines. Since 1922 at the University Hospital of Gottenburg, medical

Legal aspects of telemedicine
At present, with the active introduction of telemedicine technologies in many countries, it has come to the realization that for the implementation and operation of these technologies, it is necessary to create and develop laws

Basic aspects of telemedicine
At the international consultations on telemedicine, WHO emphasized the importance of awareness by healthcare leaders of a new historical stage in the development of medicine, the promotion of telemedicine as a technology

Telemedicine. Foreign telemedicine projects
The need for the development of telemedicine is recognized in the leading countries of the world, among which telemedicine technologies are especially widely used in the USA, Greece, Great Britain and Norway. Projects related

Russian telemedicine projects
In Russia, a large-scale telemedicine project was implemented for the first time in the world in 1978-1984. the creation of a "System for Remote Diagnosis of Emergency Conditions" in "acute abdomen", including diseases

Telemedicine projects
Country Name of the project Brief description of the project Amount of financing Provided telemedicine

Internet medical resources
1. THE EXACT WORD ORDER IN A SEARCH QUERY CAN BE INDICATED WITH THE HELP: 1) () 2) "" 3) || 4) 5) () 2. TO DISABLE MORPHOLOGY IN SEARCH MACHINES

Medline
1. INDEX MEDICUS IS PUBLISHED BY: 1) The National Library of Medicine of Canada (deletion of the symbol) 2) The National Library of Medicine of Great Britain 3) The Regional Medical

Microsoft Word
1. FORMATTING TEXT INCLUDES THE FOLLOWING ACTIONS: 1) copying a fragment of text 2) deleting a character 3) setting the alignment mode 4) selecting a fragment

Microsoft Excel
1. RELATIVE REFERENCE IS ... 1) a reference to a cell with data used in the formula, which automatically changes when the position of the cell with the formula changes

Database
1 MS ACCESS IS... 1) programming language 2) database management system 3) graphics editor 4) spreadsheet editor

Computer modelling
1 EXPERT SYSTEM IS ... 1) a system that will completely replace doctors in the future 2) a database management system 3) a computer program that can partially replace

Medical Information Systems
1 FROM THE INTRODUCTION OF A COMPREHENSIVE MEDICAL INFORMATION SYSTEM A THERAPIST CAN RECEIVE A BENEFICIAL EFFECT 1) simplicity and efficiency of monitoring the performance indicators of the LP

Introduction

. Theoretical part

.1 The need for automation

.2 What IP does a pharmacy need

.3 Trends and outlook

. Analytical part

.1 Characteristics of the automation object

. Design part

.1 Statement of the problem

.2 Software

. Economic part

.1 Selection and justification of the methodology for calculating economic efficiency

.2 Calculation of indicators of economic efficiency of the project

Conclusion

List of used literature

Annex A

Introduction

This course project is devoted to the development of an information system in the accounting of medicines.

The object of development is an information system for the accumulation, access, processing and administration of information stored in the pharmacy network database.

To date, information technology has reached a high level of development in the world. In this regard, some pharmacy chains use automatic tools to efficiently store, process and distribute the accumulated data. Based on the modern requirements for the quality of the work of the enterprise, it should be noted that their effective work depends entirely on the level of equipment with information tools based on computer-aided accounting systems.

When organizing accounting in a network of pharmacies, an important role is played by software and hardware automation, both mobile and stationary: barcode scanners, label printers, data collection terminals. All this, along with the software, allows you to keep track of the goods at the moment when they are moved or sold. The pace of modern business does not allow postponing the process of registering the movement of goods.

In this regard, the topic of this course project is currently relevant and significant for the effective functioning of the network of pharmacies.

The purpose of the course project is to develop an information system for accounting for medicines that will ensure the correct maintenance of a database containing data on the product range, customers and suppliers, the receipt and consumption of goods, bills, invoices, invoices, checks, and also supplement it with accurate and partial search for information, ensuring the referential integrity of the database, generating various reports, etc.

The object of the study is the network of pharmacies "Solnechnaya"

The developed system is designed to automate the trading and purchasing activities of an enterprise, taking into account all the requirements put forward for software specific to this subject area.

The main objective of this project is to create an interactive automated trading management system that will eliminate the shortcomings of real trading processes.

An important task of creating a system is to reduce the time spent on basic operations by the organization's personnel, which, of course, should lead to qualitative improvements in the organization's activities.

Formation of reliable information in the form of various reports and diagrams for an objective assessment of the current state of affairs in the enterprise.

The system should ensure the performance of functions related to keeping records of purchases and sales of products, namely, the program should provide:

1. Correct maintenance of the database (adding, deleting, editing records);

2. Keep records of the arrival/expenditure of goods;

The data must be able to be exported to MS Excel. It should also be possible to graphically display the output.

The general requirement of the system is to create a user-friendly interface with which the user could easily and quickly enter information into the database, according to the above requirements.

In addition to the main functions for practical use, a user interface should be developed (made more compact and systematized).

The program must:

have an advanced graphical interface. Users of various qualifications will be able to work with this program.

allow you to enter and store information in the database, edit it, generate reports.

significantly reduce the time spent on the preparation of current documentation and final reports, eliminates the possibility of errors in calculations, can be used on a different scale, i.e. can work with a huge amount of data, does not require reprogramming when changing equipment models, characteristics, prices, etc.

The program must be created in the Borland Delphi 7.0 application development environment, which implements modern approaches to programming: an object-oriented approach and visual tools for rapid application development.

1. Theoretical part

.1 The need for automation

A pharmacy is primarily a point where sales are made, so many business processes here are the same as in a regular store. The list of tasks to be automated in a separate (independent) pharmacy includes:

Accounting;

2. ordering goods from suppliers (a wide range and the presence of a large number of suppliers dictate the need to implement an electronic order using special features to compare prices from different suppliers);

Analysis of the movement of goods and the formation of analytical reports for different groups of goods;

Registration and accounting of sales.

For a pharmacy chain, the list of such tasks will be longer, it includes, for example, maintaining product classifiers, centralized financial and economic accounting, logistics (transferring goods from a warehouse to retail outlets), and personnel management. In addition, depending on the accepted schemes of work, ordering goods from suppliers can be carried out either centrally or by the points of sale themselves (i.e., decentralized). The same applies to pricing: the pricing of pharmaceuticals can be carried out both directly in pharmacies and at the central office.

In addition, today retailers use a whole range of tools to increase consumer loyalty to boost sales. "One of them is discount programs of various types. They include holding time-limited promotions; in addition, automated work with doctors and the ability to book goods by phone are in demand. The Vidal directory integrated into the system allows you to directly from the program terminal select a drug by disease, ATC and pharmaceutical groups, providing access to annotations of drugs, information about analogues and their availability in a pharmacy.

However, in addition to tasks similar to those of any retail outlet (or chain of stores), there are many specific business processes in the pharmacy business that require a non-standard approach and other (than in ordinary trade) solution algorithms.

Firstly, pharmacy chains work with a huge assortment and almost all products in the pharmacy have an expiration date. "This imposes specific requirements on the information system, which must have the functionality to account for the expiration dates of several thousand positions. Another feature of the product range in a pharmacy is the presence of several types of the same drug: it can be one medicine in various forms of release - spray, gel, ointment, etc., in various dosages, preparations for children, adults, etc. IS should allow you to view and select commodity items, moving through the product catalog, creating subgroups within one product group, and help to carry out an operational search drug in the process of working with the client.

Secondly, pharmacies maintain strict batch records (sometimes records by serial numbers) in accordance with GMP requirements, especially if they have their own production (preparation of medicines to order). "In the latter case, this standard (GMP) provides for the provision of a certain workflow, storage rules, as well as accounting for the composition of the substance in the raw material. It has its own specifics: all incoming batches of substances, drugs undergo mandatory incoming control in pharmacies. All actions related to obtaining , production, distribution, including control, are described by standard procedures. Control is carried out in accordance with the pharmacopoeia, a collection of standards and regulations governing the quality of medicines (drugs). A unique number is assigned to each batch in order to be able to on the finished drug collect a dossier of the series, which indicates the place and date of purchase of all components (substances, excipients) that are included in the finished product according to the specification, as well as the test results of these components, production conditions and the course of the technological process (how much, at what temperature the mixture was kept, what kind reactions occurred, etc.). In addition, there is such a thing as a specification. This is a list of substances included in the finished product. Usually, it is indicated here what moisture content and / or what concentration of the active substance in the substance should have the components from which the drug is prepared, and therefore, the information system must have the functionality to work taking into account the mass, humidity, content of the active substance.

With regard to finished products, the importance of batch accounting is also not in doubt, since situations may arise when it is necessary to withdraw an entire batch of defective goods. The manufacturer needs to know where it sold - to which outlets, through which distributors. IS should make it possible to trace the path of the defective goods almost to the purchase receipt.

Experts name a number of other functions that are mandatory for the pharmacy information system: product pricing in accordance with the rules of regulated pricing for certain groups of drugs, serial registration of drugs and tracking of rejected batches, the availability of the function of dispensing on preferential and free prescriptions and personalized accounting for the release of this type of drug to patients who are eligible for benefits; counterfeit tracking, control over the mandatory assortment, special accounting for a number of drug groups - potent drugs, groups A and B, etc. Organization of a help desk with the function of providing information about the availability of goods in any subdivision of the pharmacy network in real time, the interaction of an automated pharmacy management system with external reference systems, work with bank cards; the possibility of using gift certificates, promotions, trading "by samples".

To ensure all these requests, ISs with the appropriate functionality are needed.

.2 What IP does a pharmacy need

automation assortment pharmacy medicine

The basic software package for a pharmacy should provide electronic interaction with suppliers (from ordering to receipt of invoices), batch accounting, control of expiration dates and rejected batches of medicines, the ability to return goods to a supplier (for example, in cases when a medicine in a pharmacy runs out of expiration date or any defects are found) and the return of goods from the consumer (if, say, it is found that this batch is counterfeit) revaluation of goods, inter-pharmacy transfer of goods for chains and pharmacies with remote kiosks, retail sales (cash module), inventory, uploading data to the accounting system and providing operational reporting.

An average pharmacy today includes the following equipment: two or three automated trading places based on a fiscal registrar (a computer, a fiscal registrar itself, a barcode scanner, a customer display, a cash drawer), one computer of a materially responsible person, one computer as a database server.

Open display pharmacies may also use security systems (particularly anti-theft devices) and video surveillance. In large retail chains, there is already a practice of integrating such systems with IS (for example, with cash systems - to prevent or suppress abuses by staff and customers), but in the pharmacy business, even in large chains, this is still of little demand due to the secondary nature of such a task in relation to to automate core business processes.

The access control system (ACS) can be used to record visits to a warehouse with medicines. "This is due to the fact that pharmacies work with narcotic drugs, and in order to prevent abuse of these products, ACS is very effective. Their integration with the back office allows you to create a single information space and monitor warehouse attendance in real time. In case of any violations the system helps to easily identify the culprit. In addition, it makes it possible to severely restrict access to the information stored here. In this way, the top manager of the company gets a complete picture of the security system throughout the network and can monitor the occurrence of emergency situations in time and take measures to resolve them" .

The key criteria for choosing an IP are:

The cost of the basic package and technical support services (which is especially critical for non-network pharmacies);

Possibility of timely improvements of the system to new market requirements and wishes of the customer (user);

· low requirements for equipment (server, director's workplace, cashier's workplace) - this allows you to avoid additional costs for the purchase of new equipment and use existing computers;

· system support for a wide range of peripherals (fiscal registrars, barcode scanners, customer displays, thermal barcode printers, etc.);

Availability and affordable price of additional modules to increase the functionality of the basic set (especially important for dynamically developing pharmacies);

· for the DBMS used, the cost of the DBMS itself and additional licenses for the workplace, the qualifications of IT personnel for administration are important;

· ability to interact with the most common accounting programs.

For pharmacy chains, especially large and dynamically developing ones, the hierarchy of key criteria will be somewhat different than for individual pharmacies. So, here the high requirements for the DBMS used in the office for data consolidation, as well as for the office hardware (server, manager's workplace) will come first. For large pharmacy chains, we recommend equipment that guarantees fault tolerance and uninterrupted operation, since failures in office equipment can have a negative impact on the entire pharmacy network.

It is very important that the IS has the ability to quickly consolidate data, to quickly exchange information about the availability of goods in real time, both between several pharmacies of the same network, and between pharmacies of the network and the central office. The central office receives reports on the sale of goods from pharmacies and, on their basis, carries out procurement planning. The scalability of IS is also extremely important, especially at the present stage, when pharmacy chains are growing rapidly. If a company is growing by more than 30% per year, this means that the system should easily cope with an increase in the number of users.

A large number of peripheral equipment supported by the system is of particular relevance for interregional pharmacy chains. Today, we should not forget about acquiring systems either: providing work with credit cards has already become a common practice, and moving away from a separate EFT terminal to a built-in one reduces customer service time and, most importantly, eliminates errors caused by additional manual information entry.

For network pharmacies, such a criterion as the cost of software development for individual orders is also important: as a rule, large pharmacy chains develop their own know-how over time, following marketing trends in their regions, and provide requests for software development taking into account local specifics.

In other words, it is necessary to pay attention to the following: the client ultimately buys not a program, but a technology in which not only the functionality of the IS is essential, but also the implementation time, the cost of the project and the total cost of ownership of the product (TCO, including the cost of adaptation and accompaniments).

.3 Trends and outlook

As already mentioned, one of the most serious trends today is the intensive development of pharmacy chains and the decrease in the number of independent pharmacies. It is clear that not only the full development, but the very existence of a trading network is now impossible without the use of appropriate IT. That is why the most demanded will be solutions that allow centralized, but at the same time flexible management of the assortment, marketing programs, pricing policy within the pharmacy network. At the same time, high requirements for the reliability of software operation in pharmacies must be observed so that the costs associated with its operation do not increase. The advantage will be given to companies that offer solutions not for a pharmacy as such, but for a network of pharmacies and use highly reliable DBMS as a platform.

One of the new directions in this market is the creation of companies that outsource the management of pharmacy inventory, pricing policy, and marketing programs. At the same time, pharmacies retain legal and financial independence and receive the advantages that pharmacy chains have in terms of price levels (when purchasing goods from suppliers) and the use of highly qualified (and, therefore, highly paid) managers.

An interesting trend in the pharmaceutical market is the birth of new trade formats: for example, today not only pharmacies are relevant, where only medicines are sold, but the so-called "health stores", where you can buy beauty products, get advice from an ophthalmologist who can work here, etc. To ensure the operation of such complex shopping centers, IS with an expanded range of capabilities is needed.

However, independent pharmacies do not want to give up their positions, striving to optimize their work, to ensure transparency in accounting for product circulation and financial resources with the help of IT. After all, small pharmacies often need to automate the receipt of goods, print invoices and price tags, and maintain the necessary primary documentation. For independent pharmacies (however, for many chains) important criteria are the ease of use of the system, ease of training staff to work with the software, as well as the cost and quality of service.

The current state of pharmacy retail automation is in many ways reminiscent of the situation with the introduction of IT in retail chains a few years ago, when an integrated approach to automation was just emerging here, not all types of information systems were in demand, there were no special requirements for system integration. By the way, the fact that in conversations with experts we failed to obtain estimates of the total volume of this market segment speaks of the initial stage of its development. "At this stage of automation of pharmacies, an integrated approach mainly consists in the introduction of an accounting and accounting system. The reduction of input duplication alone frees up to 50% of the time of staff, usually highly qualified and receiving considerable remuneration for their work. In addition, providing access to data for the entire history of the operation of the pharmacy enterprise makes it possible to use specialized demand forecasting systems.

Today, in the sector of traditional (non-pharmaceutical) retail, analytical systems and packages for planning and forecasting are already used by the most advanced market participants, and the day is not far off when they will become an integral part of every self-respecting retail chain. Therefore, the fact that participants in the pharmaceutical market are already thinking about such systems clearly indicates that it is actively gaining momentum. And it is quite possible that the pace of its development will be higher than that of ordinary (non-pharmaceutical) retail in its time; Based on the experience of the latter (in combination with the already significant capital that has come here), the pharmacy retail segment can make a very significant breakthrough in the near future.

2. Analytical part

.1 Characteristics of the automation object

The object of the study is Solnechnaya Pharmacy LLP for the sale of medicines.

Solnechnaya Pharmacy LLP was established in 2001. In 2005, 2 pharmacies were opened, in 2007 2 more, at the moment Solnechnaya Pharmacy LLP has 9 branches.

In our country, as well as in many other countries, pharmacy chains began to take the first place in the pharmacy business. This can be explained by the following factors.

First, network pharmacies purchase much larger batches of drugs than individual pharmacies, and consequently they receive much larger discounts on purchase prices, they can be granted a deferred payment, or they can even afford to buy directly from the manufacturer.

Secondly, pharmacy chains have a centralized management apparatus, which significantly reduces marketing research costs, accounting and financing costs, and reduces storage costs.

Thirdly, a network of pharmacies can afford to make high-quality advertising to attract customers. It can hold various promotions, provide discounts to certain segments of the population, issue discount and accumulation cards.

In addition, as a rule, in such pharmacies we can find a very large assortment of not only medicines, but also various related products - cosmetics, personal hygiene items, baby food and various products for children, their mothers and pregnant women. This is a real family pharmacy where you can buy products for the health of all family members. All this makes it possible to attract wide sections of the population to the pharmacy, since almost any person, having gone there, will be able to buy everything necessary for the whole family.

An important point is the availability of qualified personnel in the pharmacy, and especially a doctor, from whom you can get advice about a particular disease. Naturally, it is best to go to a doctor in a clinic, but there are times when this is simply not possible, and then a consultant doctor in a pharmacy, just a doctor, and not just a pharmacist, is just a godsend! In the same emergency cases, round-the-clock pharmacies are indispensable. Any network of pharmacies has round-the-clock pharmacies, and they must be located in different parts of the city, one of which must be in the center.

These are the most important factors, due to which single pharmacies have practically disappeared in our cities, but there are many pharmacies, pharmacy kiosks or round-the-clock pharmacies owned by one company.

In the external system, Solnechnaya Pharmacy LLP acts as an intermediary between manufacturers of goods and customers for these products. This can be clearly seen from Figure 1.

Figure 1. Scheme of the external environment of the company

Solnechnaya Pharmacy LLP conducts wholesale and retail trade. Satisfying the needs of retailers, the wholesale trade enterprise receives income from the trade allowance for the goods sold.

Products come from wholesalers and are sold directly to consumers who need this type of goods.

Acceptance of goods in terms of quantity and quality is carried out in accordance with the instructions adopted by the organization.

Acceptance of goods by quantity is a reconciliation of the mass, number of places, units of actually received goods with indicators of accompanying documents.

Acceptance of goods by quality is the identification of the quality and completeness of the goods, the compliance of containers, packaging, labeling with established requirements, as well as accompanying documents.

After acceptance of the goods, the required quantity enters the trading floor, and the rest is moved to the warehouse. When organizing the storage of goods, the main attention should be paid to combating product losses. The rational organization of storage involves the creation of storage conditions for goods in accordance with their physical and chemical properties, the optimal placement of goods in storage places, taking into account the time of their receipt and the order of sale, the frequency of demand, and the efficient use of storage space.

Let us describe the organizational structure of enterprise management.

At the head of the company is a director who mainly decides management issues, as well as issues of a strategic nature. He oversees the activities of all departments. Also in his competence are the issues of the movement of financial flows. The Director is appointed by the Founder The Financial Director analyzes, forecasts and accordingly develops the company's development strategy in the field of finance. He heads the financial department: he is responsible in accordance with the job description. Purchasing of goods is carried out by the supply department. Its functions also include the search for new suppliers with more favorable delivery terms. This department deals with the procurement of the entire range. The purchase is made on the basis of customer orders and stock balances.

The accounting department includes three subdivisions: it is the chief accountant, statement, payments and cash desk.

The chief accountant maintains accounting records, makes a balance sheet, various cross-reconciliations, considers all taxes and resolves issues that arise in departments under his subordination.

In the process of studying the existing system for processing economic information at the enterprise LLP Apteka Solnechnaya, shortcomings were identified.

Consider organizational shortcomings:

The organization uses a personal computer to a minimum.

Irrational use of information technology tools.

Insufficient qualification of employees.

Among the technical shortcomings, it should be noted the lack of a unified information system that provides centralized data storage, end-to-end accounting of the sale of goods and automated preparation of all necessary printed documents.

An important requirement for pharmacy software is the ability to quickly master the entire accounting complex, both by the owner of the pharmacy and by the staff. Most pharmacies use a simplified scheme and work on a single tax. At the same time, the entrepreneur often takes an active part in accounting. As a rule, he does not have time to master the basics of accounting. The program must "communicate" in a language understandable to the entrepreneur. This greatly simplifies the development of the system and its subsequent operation.

3. Design part

.1 Statement of the problem

Create a software application "Accounting for medicines" that organizes operations with medicines (registration, sale, accounting, etc.), monthly profit.

The application must provide reports that include calculations of the most popular drugs and the most popular indications for the month.

Let us describe the fundamentals of the functioning of the object in question, that is, the Pharmacist's Handbook, using the BP Win program.

At the zero level, the input data are: drug information, supplier information, order.

Indirectly, this enterprise is influenced by laws, the charter of the enterprise and demand. Employees and equipment are also very important for the operation of the enterprise, so they also indirectly affect it.

The output data is: income, reports and response to the order.

Figure 2 - Functional diagram 0 level

As a result, it is possible to develop the logical structure of the database using the ERWin program.

Database structure.

Rice. 3. Logical structure of the database

Table 2 - Physical structure of the database

3.2 Software

The software product "Accounting for medicines" was developed on Microsoft Access 2003 and Borland Delphi 7.

Access 2003 is included with Microsoft Office 2003 and works like other components on Windows 2000 and above.

The practical minimum required by Access 2003 for a personal computer is a Pentium 2 and 64 MB when running under Windows 2000. With a standard installation of a set of applications: Word, Excel, Outlook, Power Point, Access, FrontPage, approximately 250 MB of hard disk space is required. SVGA monitor recommended, VGA possible.

Microsoft Access is a functionally complete relational DBMS. It provides all the necessary tools for defining and processing data, as well as for managing them when working with large amounts of information. When it comes to ease of use, Microsoft Access has made a real revolution here, and many people turn to it to create their own databases and applications.

Microsoft Access gives you maximum freedom in specifying the type of your data (text, numbers, dates, times, money, pictures, sounds, documents, spreadsheets). You can also set storage formats (string length, precision of numbers and date/time) and presentation of this data when displayed or printed. To make sure that only correct values ​​are stored in the database, you can set conditions on values ​​of varying degrees of complexity.

In Access, you can use macros or Access Basic to dynamically exchange data with other applications. OLE allows you to link to objects in another application or embed objects in an Access database. These objects can be pictures, charts, spreadsheets, or documents from other OLE-enabled Windows applications.

Microsoft Access can work with a wide variety of data formats, including file structures of other DBMSs. The DBMS allows you to work with data using various methods. For example, you can search for information in a single table or create a complex search query across multiple related tables or files. With a single command, you can update the content of a single field or multiple records. To read and correct data, you can create procedures that use DBMS functions. Many systems have advanced data entry and reporting capabilities.

Microsoft Access uses the powerful SQL (Structured Query Language) to process the data in your tables. Using, you can select from one or more tables the information necessary to solve a specific problem. Access greatly simplifies the task of data processing.

Borland Delphi 7 visual programming environment was chosen for writing the program.

The syntax of Borland Delphi 7 is based on the Object Pascal programming language. Borland Delphi 7 fully supports OOP (object-oriented programming), which greatly expands the possibilities of the environment.

Another important advantage of the chosen Borland Delphi 7 environment is that Borland Delphi 7 is considered to be one of the simplest programming environments all over the world, and, unlike all widespread programming environments, it is strongly typed, which makes it possible to reduce the number of errors to almost zero. (with the exception of logical algorithm errors). Delphi 7 provides a wide range of database management tools, even with different technologies for structure and support.

To develop a database in this program, the choice fell on ADO technology, Microsoft Corporation, for its wide capabilities and ease of use.

In accordance with the structural diagram given above in the paragraph "Structural diagram", in the presented program, program modules have been developed on Borland Delphi 7. As well as queries in the Microsoft Access 2003 language.

During the execution of the program, the following messages may appear on the screen:

"Error reading database" message.

The error occurs when the database file cannot be read.

In this case, the operator must:

Check for file "task.mdb" The file may not exist or is located in a different folder than the program.

The error may have been caused by a media problem.

"Date Mismatch" message.

An error occurs when generating a report due to incorrectly entered dates.

In this case, the operator must:

Check if the dates are spelled correctly.

Main form

Figure 4 - Main form

Work description:

Reflection of basic information from the database tables Medicines and Warehouse.

Line Find: searches for a drug by initial letters in its name.

Figure 5 - Selection of data by condition

The Suppliers row: searches for a supplier by its code in the Suppliers table, reflecting the name of the medicine, its quantity in stock and the date of delivery, and displays the result in a separate form "Search result".

Figure 6 - Search result

Section Order:

Name - choice of medicine

Date - specifying the date

Price - indication of the price of the medicine

Amount - calculation of the total amount of the order

By pressing the OK button, the sale of the medicine is carried out with the information entered in the Order table with its reflection in the Sales Report form.

Menu Edit:

Figure 7 - Menu Edit

Add record - calls the Add / edit medicine form with the added data entered into the Medicines and Warehouse tables.

Figure 8 - Form Add / edit drug

Edit record - calls the Add / Edit medicine form with updating the corrected data in the Medicines and Warehouse tables.

Figure 9 - Form Add / edit drug

Menu Reports

Figure 10 - Reports menu

Calls the Sales Report form.

Figure 11 - Sales Report Form

Menu Suppliers

Figure 12 - Suppliers menu

Calls the Suppliers form.

Figure 13 - Suppliers form

Add button - calls the Add / edit supplier form with adding the added data to the Suppliers table.

Figure 14 - Form Add / edit supplier

Edit button - calls the Add / Edit Supplier form with updating the corrected data in the Suppliers table.

Figure 15 - Form Add / edit supplier

The Delete button - removes the current record from the Suppliers table.

Exit button - closes this form.

Menu References

Figure 16 - Reference menu

Calls the forms City and Types of medicines.

Figure 17 - Shape of the City

Figure 18 - Medicine Type Form

Menu Sort

Figure 19 - Sort menu

Sorts medicines by name or price in the Medicines table.

Menu Exit

Figure 20 - Menu Exit

4. Economic part

.1 Selection and justification of the methodology for calculating economic efficiency

The cost estimate includes the following items:

basic salary of information system developers;

additional salary of information system developers;

social security contributions;

calculation of the cost of depreciation of computers;

the cost of electricity used in the development of the information system;

overheads.

Let's take a closer look at each of these cost items.

Remuneration of labor represents a set of funds paid to employees in cash and in kind both for hours worked, work performed, and in the manner prescribed by law for hours not worked. The accrual of basic wages is made depending on the forms of remuneration adopted at the enterprise. With time wages, the basic wage is accrued to employees for the time actually worked, and with piecework for the work actually performed.

The time-based form of remuneration is used in calculating the wages of workers, employees, specialists and managers. With this form of remuneration, wages are calculated based on the monthly official salary for the hours worked. Overtime pay must be taken into account. The surcharge is charged in excess of time earnings at the rate of 20% of the tariff rate of a time worker.

Thus, we will consider those cost components that will be affected by the modernization of the information system. As a result of the reduction of working hours, the wages of the employees of the enterprise will not change, because. they are given a fixed salary, not an hourly rate. Moreover, overtime work is not paid with the corresponding indexation (3 times), for overtime hours, employees can be awarded personal bonuses or can take time off. Therefore, there will be no direct reduction in costs from increasing the efficiency of work. But the general wage fund will be reduced as a result of the reduction of positions, mainly the positions of supervisors and recheckers. It is expected that the same amount of work in the new system will be able to perform 1.5 times fewer workers than in the existing traditional system.

The cost of basic wages (3 main) with a time-based form of remuneration are calculated according to the formula (1):

W main =About month. *T slave * K d / D r.month. , (one)

where: About month. - monthly salary of the seller;

D r.m. - the average number of working days in a month;

T slave - actual hours worked

K d - coefficient taking into account additional payments to the basic salary

A certain amount of stationery - paper, writing utensils and others - is approximately calculated per year for the work of Solnechnaya Apteka LLP for the amount of Sk1, which amounted to 100,000 tenge per year. in a central server will reduce these costs by 70-80%.Final output of data on paper is required only for those reports that are used by management as official documents.

That. the reduction in the cost of consumables is determined from the expression:

DZ r.m. = 0.7 * S k 1; (2)

where S k 1 - the amount of annual expenses for stationery;

DZ r.m. = 0.7 * S k 1 = 70,000 tenge.

The work rate per month is 146 hours. In reality, some workers work overtime, which leads to energy overruns. A desktop computer that performs the functions of a tax inspector's workplace consumes on average N pc = 350 W.

The cost of electricity per year will be:

where T is the number of hours worked by users overtime per year

T = 1321 hours in about a year.

E year \u003d 350 * 1321 \u003d 462350 W.

If the financiers manage to do their work during working hours, then the cost reduction as a result of saving e / energy will be:

DZ ee \u003d E year * C square, (4)

where Tsq is the price of one kWh of e / energy. C sq = 3 tenge;

DZ ee \u003d 462350 * 1.50 * 10-3 \u003d 1400 tenge;

In total, we have the material advantages of introducing a new financial accounting system in the amount of cost reduction during the year:

DI S \u003d DZ s / n + DZ r.m. + DZ ee (5)

DI S = 1,200,000 + 266,000 + 1400 = 1,467,400 tenge

.2 Calculation of indicators of economic efficiency of the project

To build the system, we use an existing LAN. It consists of:

Windows Server network file server;

Computers based on Pentium 4;

· cable system based on a thin coaxial cable;

active cable equipment.

According to the technical characteristics, the network is suitable for creating a client / server financial accounting system on its basis. This requires additional components:

a database server;

· database server software;

software for client computers;

The price of a database server based on Pentium IV will be:

C sbd = 200 000 tenge

Intel EtherExpress Pro Network Card for D-Link 10-100 DB Server

Csk = 1500 tenge

Network OS Windows NT 4.0

C os = 60 000 tenge

Software server for 10 simultaneous connections:

C ps = 140,000 tenge

It is planned to use a group of 3 specialists to implement the new system.

The system development time is defined as:

T p = 1000 hours, or 6 months.

That. developer labor costs will be:

Z prog \u003d Z salary * 18 \u003d 60,000 * 18 \u003d 360,000 tenge;

Delphi 7.0 package has market value

C Delphi = 250 000 tenge

The total one-time investment will be:

K = C sbd + C sk + C os + C ps + C prog + C Delphi , (6)

K = 200,000 + 18,500 + 175,000 + 140,000 + 360,000 + 250,000 = 1,143,500 tenge.

The annual efficiency of the system creation is determined from the expression:

E g \u003d D3 / (E n + K p), (7)

where DZ - change in the amount of costs for the creation and maintenance of the information system is determined from the expression:

DЗ = DИ S - К(Е н + К р), (8)

where DI S is the absolute change in the costs of the department;

E n - the standard for the efficiency of capital investments, for computer equipment and software is taken equal to 0.15;

K p - renovation coefficient, taken as a depreciation rate, taking into account the service life of existing equipment (system service life T sl - 3 years) and is determined by the formula:

K p \u003d E n / ((1 + E n) T sl - 1), (9)

Kp = 0.15 / ((1 + 0.15)3 - 1) = 0.29;

Then the change in cost will be:

DЗ = 1 466 700 - 1 143 500*(0.15+0.29) = 963 560 tenge,

Thus, the annual efficiency is planned in the amount

Eg = 963 560 / (0.15+0.29) = 2 189 909 tenge.

Now we can determine the payback period Current of creating a new system from the expression:

T ok \u003d K / E g, (10)

Current = 1,143,500 / 2,189,909 = 0.52 years.

Moreover, this payback period takes into account only the material advantages of creating a new system.

Thus, I have calculated all the costs of creating the system and substantiated all the advantages of its implementation.

Conclusion

As a result of the work done, an information system (IS) was developed for the Solnechnaya pharmacy network. The system was developed in accordance with the requirements of the customer, taking into account the peculiarities of this subject area.

The information system was created in the Borland Delphi 7.0 visual application development tool environment. As a result, an information system for accounting for a trade enterprise was developed. The information system supports all operations related to accounting, processing and provision of the necessary data. This system provides input, deletion, storage and editing of information contained in data tables.

These features allow you to maintain reporting documentation, generate work results, store data on medicines and their prices, suppliers, etc.

The application is easy to use even for an inexperienced user. It is colorfully designed (pictures, icons, etc. are added) to make it pleasant and fun for the user to work in this program.

This project can be more detailed and carefully developed in the future, which will bring considerable profit to its developer.

The Delphi system allows you to solve many problems, in particular:

1. Create complete applications for Windows of various kinds: from purely computational and logical to graphic and multimedia.

2. Quickly create (even for novice programmers) a professional-looking window interface for any application.

Create powerful systems for working with local and remote databases

4. Create help systems (.hlp files) for your applications and more. others

Delphi is a combination of several essential technologies:

1. High performance compiler to machine code

2. Object-oriented component model

Visual (and, therefore, high-speed) building applications from software prototypes

4. Scalable tools for building databases.

The purpose of the course work was to study the DELPHI programming language and develop practical tasks.

When doing coursework:

1. the theory and technology of working with the Borland Delphi7 programming environment was studied;

2. the relevant literature was studied and analyzed;

3. a comparative analysis of the languages ​​of this class was carried out and the advantages and disadvantages of the Delphi language were shown;

4. Elements of methodical work were given in the form of developing options for tasks (from applied areas) for high school students studying Delphi in computer science lessons.

The information system significantly reduces the time spent on compiling current documentation and final reports, eliminates the possibility of errors in calculations, can be used on a different scale, i.e. can work with a huge amount of data, does not require reprogramming when changing equipment models, characteristics, prices, etc.

Thus, the assignment for the course project was completed in full. The developed information system fully satisfied the requirements of the customer and is at the implementation stage.

List of used literature

1. Shumakov P.V. "Delphi 7 and database application development." - M.: "Knowledge", 2007;

2. http://www.licinfo.com.ua/ru/biznes-plan-seti-aptek.html

http://www.aip.ru/list_articles/preimushestva_.html.

4. http://www.nedug.ru/news/popular_about_health/2000/5/22/Future-for-pharmacy-chains#.VI3aiFVwt6Q.

5. Omarova Sh.E., Drozd V.G., Kosova E.G. -Tutorial "Database Design".

6. Pestrikov, V.M. Delphi by examples / V.M. Pestrikov, A.N. Masloboev. - St. Petersburg. : BHV-Petersburg, 2005. - 496 p.

7. Steven, R. Delphi. Ready-made algorithms / Rod Stevens; Per. from English. Mereshchuk P.A. - 2nd ed., erased. - M.: DMK Press; SPb. : Peter, 2004. - 384 p.

8. www.wikipedia.com

9. Sapkov V.V. Information technology and computerization of office work: a study guide. Kyiv: ACADEMIA, 2009.

10. Ten T.L., Mukanova Zh.A. Software IS / study guide. - Karaganda: KEUK, 2010

11. Ten T.L., Mukanova Zh.A. Software IS / uch.-prakt.posobe for DO. - Karaganda: KEUK, 2009

Labor V.V. Sea Sharp: Creating applications for Windows / V.V. Laboratory. - Minsk: Harvest, 2003

13. http://business-up.ucoz.ru/publ/2-1-0-10

14. Timoshonok, T. Microsoft Access 2003. Quick guide /T. Timosh-nok. − M: Williams, 2005. - 320s.

15. MS Access tutorial. [Electronic resource]. - Access mode: http://www.taurion.ru/access.

16. http://business.gov.kz/ru/aspiring-entrepreneurs/business-ideas/detail.php?ID=60897

17. Koglovsky M.R. - Technology of databases on personal computers. - M.: Finance and statistics, 2008.

18. Informatics / Ed. N.V. Makarova. M.: Finance and statistics, 2010.

19. Orlov S.A. Software Development Technology: Textbook. - St. Petersburg: Peter, 2008 ..

20. http://www.1001statya.ru/

21. http://forum.triz-ri.ru/forum/mess.asp?thr=19407

22. Strange K. Magic Quadrant for Data Warehouse DBMSs// Gartner Research Note M-22-2154. 2011

Annex A

unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, Grids, DBGrids, Menus, ImgList, StdCtrls, DBCtrls, Mask, Buttons; type TForm1 = class(TForm) DBGrid1: TDBGrid; MainMenu1: TMainMenu; ImageList1: TImageList; N1: TMenuItem; N2: TMenuItem; N3: TMenuItem; N5: TMenuItem; N6: TMenuItem; N7: TMenuItem; N8: TMenuItem; N9: TMenuItem; N10: TMenuItem; N11: TMenuItem; N12: TMenuItem; N13: TMenuItem; N14: TMenuItem; N4: TMenuItem; DBGrid2: TDBGrid; Edit1: TEdit; Label1: T Label; N15: TMenuItem; N16: TMenuItem; N17: TMenuItem; GroupBox1: TGroupBox; N18: TMenuItem; Label2: T Label; Label3: T Label; DBEdit2: TDBEdit; Label4: T Label; DBEdit3: TDBEdit; Label5: T Label; DBEdit4: TDBEdit; Label6: T Label; DBEdit5: TDBEdit; DBLookupComboBox1: TDBLookupComboBox; BitBtn1: TBitBtn; BitBtn2: TBitBtn; Label7: T Label; Edit2: TEdit; BitBtn3: TBitBtn; Label8: T Label; DBEdit1: TDBEdit; Label9: T Label; DBEdit6: TDBEdit; Label10: T Label; procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure N4Click(Sender: TObject); procedure N5Click(Sender: TObject); procedure N8Click(Sender: TObject); procedure N9Click(Sender: TObject); procedure Edit1Change(Sender: TObject); procedure N7Click(Sender: TObject); procedure N13Click(Sender: TObject); procedure N14Click(Sender: TObject); procedure N11Click(Sender: TObject); procedure N16Click(Sender: TObject); procedure N18Click(Sender: TObject); procedure BitBtn1Click(Sender: TObject); procedure BitBtn2Click(Sender: TObject); procedure BitBtn3Click(Sender: TObject); procedure DBLookupComboBox1Click(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form1: TForm1; implementation uses Unit2, Unit3, Unit4, Unit5, Unit6, Unit7, Unit8, Unit9, Unit10; ($R *.dfm) procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction); begin if DataModule2.ADOTable1.Modified then DataModule2.ADOTable1.Post; if DataModule2.ADOTable2.Modified then DataModule2.ADOTable2.Post; end; procedure TForm1.N4Click(Sender: TObject); begin DataModule2.ADOTable1.Insert; DataModule2.ADOTable2.Insert; Form3.ShowModal; end; procedure TForm1.N5Click(Sender: TObject); begin Form3.ShowModal; end; procedure TForm1.N8Click(Sender: TObject); begin DataModule2.ADOTable1.IndexFieldNames:="Name"; end; procedure TForm1.N9Click(Sender: TObject); begin DataModule2.ADOTable1.IndexFieldNames:="Price"; end; procedure TForm1. Edit1Change(Sender: TObject); begin if Length(Edit1.Text)>0 then DataModule2.ADOTable1.Filtered:=true else DataModule2.ADOTable1.Filtered:=false; DataModule2.ADOTable1.Filter:="Name>"""+Edit1.Text+""""; end; procedure TForm1.N7Click(Sender: TObject); begin Form4.Show; end; procedure TForm1.N13Click(Sender: TObject); begin Form6.Show; end; procedure TForm1.N14Click(Sender: TObject); begin Form7.Show; end; procedure TForm1.N11Click(Sender: TObject); begin Form1.Close; end; procedure TForm1.N16Click(Sender: TObject); begin Form8.Show; end; procedure TForm1.N18Click(Sender: TObject); begin Form9.Show; end; procedure TForm1.BitBtn1Click(Sender: TObject); begin DataModule2.ADOTable6.Post; DataModule2.ADOQuery2.Active:=false; DataModule2.ADOQuery2.SQL.Clear; DataModule2.ADOQuery2.SQL.Add("UPDATE Warehouse"); DataModule2.ADOQuery2.SQL.Add("SET Warehouse.[Quantity in stock]=Warehouse.[Quantity in stock]-"""+DBEdit4.Text+""""); DataModule2.ADOQuery2.SQL.Add("WHERE Warehouse.[Code] LIKE """+DBEdit1.Text+""""); DataModule2.ADOQuery2.ExecSQL; DataModule2.ADOTable2.Refresh; DataModule2.ADOTable6.Refresh; end; procedure TForm1.BitBtn2Click(Sender: TObject); begin DataModule2.ADOTable6.Insert; end; procedure TForm1.BitBtn3Click(Sender: TObject); begin DataModule2.ADOQuery1.Active:=false; DataModule2.ADOQuery1.SQL.Clear; DataModule2.ADOQuery1.SQL.Add("Select Suppliers.[Vendor ID], Drugs.[Name], Warehouse.[Quantity in stock], Warehouse.[Delivery date]"); DataModule2.ADOQuery1.SQL.Add("FROM Suppliers INNER JOIN (Warehouse INNER JOIN Drugs ON Warehouse.[Key]=Drugs.[Key]) ON Suppliers.[Vendor ID]=Warehouse.[Vendor ID]"); DataModule2.ADOQuery1.SQL.Add("WHERE Suppliers.[Vendor ID] LIKE """+Edit2.Text+""""); DataModule2.ADOQuery1.Active:=true; Form10.ShowModal; end; procedure TForm1.DBLookupComboBox1Click(Sender: TObject); begin DataModule2.ADOQuery3.Active:=false; DataModule2.ADOQuery3.SQL.Clear; DataModule2.ADOQuery3.SQL.Add("Select Medicines.[Key], Medicines.[Price]"); DataModule2.ADOQuery3.SQL.Add("FROM Medicines"); DataModule2.ADOQuery3.SQL.Add("WHERE Drugs.[Key] LIKE """+DBEdit6.Text+""""); DataModule2.ADOQuery3.Open; DBEdit3.Text:=DataModule2.ADOQuery3.FieldValues["Price"]; DataModule2.ADOQuery3.Active:=True; DataModule2.ADOTable6.Refresh; end; end. unit Unit2; interface uses SysUtils, Classes, DB, ADODB; type TDataModule2 = class(TDataModule) ADOConnection1: TADOConnection; ADOTable1: TADOTable; DataSource1:TDataSource; ADOTable2: TADOTable; DataSource2: TDataSource; ADOTable1DSDesigner: TAutoIncField; ADOTable1DSDesigner3: TWideStringField; ADOTable1DSDesigner5: TDateTimeField; ADOTable1DSDesigner6: TBCDField; ADOTable2DSDesigner: TAutoIncField; ADOTable2DSDesigner2: TDateTimeField; ADOTable2DSDesigner3: TWideStringField; ADOTable2DSDesigner4: TWideStringField; ADOTable3: TADOTable; ADOTable4: TADOTable; ADOTable5: TADOTable; DataSource3:TDataSource; DataSource4: TDataSource; DataSource5:TDataSource; ADOTable1DSDesigner2: TWideStringField; ADOTable2DSDesigner6: TIntegerField; ADOTable3DSDesigner: TWideStringField; ADOTable3DSDesigner2: TWideStringField; ADOTable3DSDesigner3: TWideStringField; ADOTable3DSDesigner4: TWideStringField; ADOTable3DSDesigner5: TWideStringField; ADOTable4DSDesigner: TAutoIncField; ADOTable4DSDesigner2: TWideStringField; ADOTable5DSDesigner: TAutoIncField; ADOTable5DSDesigner2: TWideStringField; ADOTable6: TADOTable; DataSource6:TDataSource; ADOTable6DSDesigner: TAutoIncField; ADOTable6DSDesigner2: TDateTimeField; ADOTable6DSDesigner3: TIntegerField; ADOTable6DSDesigner5: TWideStringField; ADOTable6DSDesigner6: TBCDField; ADOTable6Field: TIntegerField; ADOQuery1: TADOQuery; DataSource7: TDataSource; ADOTable2_: TWideStringField; ADOQuery2: TADOQuery; DataSource8: TDataSource; ADOQuery3: TADOQuery; DataSource9:TDataSource; ADOQuery4: TADOQuery; procedure ADOTable6CalcFields(DataSet: TDataSet); private ( Private declarations ) public ( Public declarations ) end; var DataModule2: TDataModule2; implementation uses Unit9; ($R *.dfm) procedure TDataModule2. ADOTable6CalcFields(DataSet: TDataSet); begin DataModule2.ADOTable6Field.Value:=DataModule2.ADOTable6DSDesigner6.AsInteger*DataModule2.ADOTable6DSDesigner3.AsInteger; end; end. unit Unit3; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, Mask, DBCtrls, ComCtrls, Buttons, ExtCtrls; type TForm3 = class(TForm) DBEdit1: TDBEdit; Label1: T Label; Label2: T Label; Label3: T Label; Label4: T Label; DBLookupComboBox1: TDBLookupComboBox; DBEdit2: TDBEdit; BitBtn1: TBitBtn; DBEdit3: TDBEdit; DBEdit4: TDBEdit; DBEdit5: TDBEdit; DBEdit6: TDBEdit; DBEdit7: TDBEdit; Label5: T Label; Label6: T Label; Label7: T Label; Label8: T Label; Label9: T Label; DBLookupComboBox2: TDBLookupComboBox; Image1: TImage; Label10: T Label; procedure BitBtn1Click(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form3: TForm3; implementation uses Unit2, Unit1; ($R *.dfm) procedure TForm3.BitBtn1Click(Sender: TObject); begin if DataModule2.ADOTable1.Modified then DataModule2.ADOTable1.Post; if DataModule2.ADOTable2.Modified then DataModule2.ADOTable2.Post; close; end; end. unit Unit4; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, Grids, DBGrids, Menus, StdCtrls; type TForm4 = class(TForm) DBGrid1: TDBGrid; Button1: TButton; Button2: TButton; Button3: TButton; Button4: TButton; procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure Button1Click(Sender: TObject); procedure Button2Click(Sender: TObject); procedure Button3Click(Sender: TObject); procedure Button4Click(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form4: TForm4; implementation uses Unit2, Unit5, Unit1, Unit3; ($R *.dfm) procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction); begin if DataModule2.ADOTable3.Modified then DataModule2.ADOTable3.Post; end; procedure TForm4.Button1Click(Sender: TObject); begin DataModule2.ADOTable3.Edit; DataModule2.ADOTable3.Insert; Form5.Show; end; procedure TForm4.Button2Click(Sender: TObject); begin Form5.Show; end; procedure TForm4.Button3Click(Sender: TObject); begin if Application.MessageBox(PChar("Are you sure you want to delete " +DataModule2.ADOTable3DSDesigner.AsString), "Attention!!!", MB_OKCANCEL)=id_OK then DataModule2.ADOTable3.Delete; end; procedure TForm4.Button4Click(Sender: TObject); begin Form4.Close; end; end. unit Unit5; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, DBCtrls, StdCtrls, Mask; type TForm5 = class(TForm) Label1: TLabel; DBEdit1: TDBEdit; Label2: T Label; DBEdit2: TDBEdit; Label3: T Label; Label4: T Label; DBEdit4: TDBEdit; Label5: T Label; DBLookupComboBox1: TDBLookupComboBox; Button1: TButton; DBComboBox1: TDBComboBox; procedure Button1Click(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form5: TForm5; implementation uses Unit2, Unit1, Unit4, Unit3; ($R *.dfm) procedure TForm5.Button1Click(Sender: TObject); begin DataModule2.ADOTable3.Post; Form5.Close; end; end. unit Unit6; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, Grids, DBGrids, StdCtrls, Buttons; type TForm6 = class(TForm) DBGrid1: TDBGrid; Button1: TButton; Button2: TButton; procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure Button1Click(Sender: TObject); procedure Button2Click(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form6: TForm6; implementation uses Unit1, Unit2; ($R *.dfm) procedure TForm6.FormClose(Sender: TObject; var Action: TCloseAction); begin if DataModule2.ADOTable4.Modified then DataModule2.ADOTable4.Post; end; procedure TForm6.Button1Click(Sender: TObject); begin Form6.Close; end; procedure TForm6.Button2Click(Sender: TObject); begin DataModule2.ADOTable4.Edit; DataModule2.ADOTable4.Insert; end; end. unit Unit7; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, Grids, DBGrids; type TForm7 = class(TForm) DBGrid1: TDBGrid; Button1: TButton; Button2: TButton; procedure Button2Click(Sender: TObject); procedure Button1Click(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form7: TForm7; implementation uses Unit2; ($R *.dfm) procedure TForm7.Button2Click(Sender: TObject); begin Form7.Close; end; procedure TForm7.Button1Click(Sender: TObject); begin DataModule2.ADOTable5.Edit; DataModule2.ADOTable5.Insert; end; end. unit Unit8; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, jpeg, ExtCtrls; type TForm8 = class(TForm) Image1: TImage; Label1: T Label; Label2: T Label; Label3: T Label; Label4: T Label; Label5: T Label; Label6: T Label; private ( Private declarations ) public ( Public declarations ) end; var Form8: TForm8; implementation ($R *.dfm) end. unit9; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, Grids, DBGrids, StdCtrls, Buttons, RpRave, RpDefine, RpCon, RpConDS, DB, ADODB, ComCtrls; type TForm9 = class(TForm) DBGrid1: TDBGrid; BitBtn1: TBitBtn; procedure FormCreate(Sender: TObject); private ( Private declarations ) public ( Public declarations ) end; var Form9: TForm9; implementation uses Unit2, Unit1; ($R *.dfm) procedure TForm9.FormCreate(Sender: TObject); begin if DataModule2.ADOTable6.Modified then DataModule2.ADOTable6.Post; end; end. unit Unit10; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, Grids, DBGrids; type TForm10 = class(TForm) DBGrid1: TDBGrid; private ( Private declarations ) public ( Public declarations ) end; var Form10: TForm10; implementation uses Unit2; ($R *.dfm) end.

http://bramit.ru/96-dtk-zakrytogo-tipa dtk open type vertebrae vertebrae dtk.