COMPUTER SUPPORT FOR PLANNING CUSTOMER VISITS

V diplomski nalogi smo za manjše dimnikarsko podjetje v Avstriji izdelali aplikacijo za avtomatizacijo pisarniškega poslovanja. S tem smo bistveno skrajšali čas trajanja procesa izdelave dokumentov. Odpraviti smo hoteli probleme, kot so dolg čas izdelave dokumentov, napake, ki so se pojavljale pri izdelavi računov (napačni naslovi, izračun opravljenih storitev), letnih načrtov (planirani datumi na praznike) in delovnih listov (število planiranih hiš, ki jih je potrebno obiskati v enem dnevu). Prav tako pa je bila baza strank neurejena. Pojavljali so se podvojeni podatki strank. Pri podvojenih podatkih je problem predvsem v tem, da ko posodabljaš podatke oziroma naslove, jih je potrebno popraviti v obeh bazah. Zato je velikokrat prišlo do različnih naslovov za isto stranko. Z analizo trenutnih procesov in potreb smo izdelali program. Ta služi kot pripomoček dimnikarskemu podjetju v pisarniškem poslovanju. Po predhodnem vnosu podatkov program po določenih ključih generira račune, planirane obiske za stranke in delovne liste za zaposlene. Aplikacijo smo izdelali s pomočjo programa Microsoft Access 2010. Uporabniški vmesnik programa je enostaven za uporabo. Po izdelavi programa smo izdelali njegovo SWOT analizo in ga uspešno predstavili zaposlenim v podjetju.The thesis presents an application that automates office operations, which was developed for a small chimney sweep company from Austria. The application considerably shortens the duration of the document creation process. Our goal was to eliminate issues such as lengthy document creation process and errors in invoice creation (incorrect addresses, incorrectly billed services), annual plans (planned dates on holidays), and worksheets (the number of planned visits in one day). Additionally, the customer database was inaccurate. It contained duplicate client entries, which lead to inconsistencies due to updates of client data or address in one place only. This resulted in different addresses for a single client. After analysing the client\u27s current processes and requirements, we developed a program that better meets the needs of a chimney sweep company in office operations. After the input of data the program generates invoices, planned customer visits, and employee worksheets. The application was implemented using Microsoft Access 2010. The application\u27s user interface is easy to use. After the implementation we performed a SWOT analysis of the program and successfully presented the program to the company\u27s employees