Home » Ad Board » 2016 » 2016_02

09.12.2017, 04:02


UDC 004.91:338.48
DOI: 10.12737/19503

Svetlana A. KAZAKOVA

Russian State University of Tourism and Service (Moscow, Russia);
Research Associate, e-mail: rgutiskazakova@yandex.ru


The article considers the formation of private and corporate museums database on the base of Russian State University of Tourism and Service. The three stages of database formation are considered: 1) determination of database functionality; 2) development of the database menu, with preliminary preparation of basic information; 3) collection of information and entering of data into database. These stages include development of main specified requirements to the database, detection of key information blocks with descriptive part of their components, drawing up auxiliary tables for development of the database menu, the description of its functionality (the dropping-out lists, filters, calendar, etc.) with the indication of used tools and the MS Office Excel functions, collection of information about non-government museums from tourist information centers and administrations of entities of the Russian Federation, verification of the obtained data, their updating and already directly entering into the database. The author also describes the example of selection and information obtained about number of non-government museums in entities of Central Federal District of the Russian Federation.
The article considers the concept of «museum service», describes purpose of the functions «Data validation», «Dispatcher of Names» of the MS Office Excel program, and also defines the importance of the dropping-out lists in the database. The created database of the non-government museums is unique and can be a basis for analytical studies.

Keywords: database, museum, corporate museum, private museum, MS Office Excel, data validation, dispatcher of names, museum service.


1. Abdulaeva, A., & Zhuginisova, Zh. (2015). Proektirovanie bazy dannyh s pomoshh'ju Excel [Creation of a database using Excel]. In coll.: Perspektivy razvitija nauki i obrazovanija: Sbornik nauchnyh trudov po materialam Mezhdunar. nauch.-praktich. konf. [Development prospects of science and education: Proceedings based on the materials of the International scientific-practical conference]. Moscow, AR-Konsalt, 3, 135-136.
2. Antonov, A. (2015). Dispetcher imen v Excel – instrumenty i vozmozhnosti [Dispatcher of Names in Excel – tools and opportunities]. Internet portal «Office Guru», 2015. Available at: http://office-guru.ru/excel/dispetcher-imen-v-excel-instrumenty-i-vozmozhnosti-63.html (Accessed on April 26, 2015).
3. Bashmakova, E. I. (2014). Umnyj Excel. Ekonomicheskie raschety [Smart Excel. Economic calculations]. Moscow: Moscow Humanitarian University Press.
4. Veledinskij, V. G. (2004). Sociokul'turnyj servis. Ch.1. Istorija i teorija social'no-kul'turnogo servisa [Socio-cultural service. Part 1: History and theory of socio-cultural service]. St. Petersburg: Publ. SPSUSE.
5. Garnaev, A., & Rudikova, L. (2011). Microsoft Office Excel 2010: razrabotka prilozhenij: Spravochnik [Microsoft Office Excel 2010: Application development: A Handbook]. St. Petersburg: BHV-Petersburg.
6. Gelih, O. (2015). Proverka dannyh v Excel [Data validation in Excel]. Internet portal «Office Guru», 2015. Available at: http://office-guru.ru/excel/dispetcher-imen-v-excel-instrumenty-i-vozmozhnosti-63.html (Accessed on April 26, 2015).
7. Davlet-Kildeeva, N. G. (2012). Razvitie muzejnogo servisa v Rossii [Development of museum service in Russia]. Gumanitarnye, social'no-ekonomicheskie nauki [Humanities, Social-economic and Social Sciences], 3. Available at: http://www.online-science.ru/m/products/cultyrology/gid130/pg0/ (Accessed on April 26, 2015).

Bibliographic description 

  • Kazakova, S. A. (2016). On the formation of the private and corporate museums database. Sovremennye problemy servisa i turizma [Service and Tourism: Current Challenges], 10(2), 47-50. DOI: 10.12737/19503. (In Russ.).

Views: 21
Total comments: 0