Guidelines for laboratory works on the topic "Learning the basics of working with DBMS Microsoft Access: Database creation and fundamentals of work with DML tools of SQL"

Abstract

Experience in using computers in the building of applied data processing systems shows that universal programming languages are not the most effective tool in contrast with the specific languages of data management systems. Such tools are commonly included in the Database Management Systems (DBMS) but also might be stand-alone. DBMS provides users with the ability to manage data directly, as well as rapid application development tools used by programmers to develop the data processing software. These guidelines consider problems related to database development, work with data, and the basics of programming in the Microsoft Access DBMS environment. Today Microsoft Access DBMS is extremely popular, first of all, because it is provided as part of the Microsoft Office package. As well as the text processor Word and Excel spreadsheets, Access DBMS is widely used for business workflow automation. User-friendly and simple interface, advanced help system, and various in-built tools (so-called wizards) simplify the users’ training process and make Access DBMS very attractive especially for users without enough experience in database management systems. The set of tasks includes the complete list of problems – from database development to user interface design. During the study, students will learn various tools used to automate data storage and processing tasks. There are tools used to design forms, queries, reports, etc. It is recommended to use Microsoft Access 2007 or newer. Efficient learning of the Microsoft Access DBMS features is possible only by practical implementation of the proposed tasks on the computer.