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"
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) b...
Main Authors: | , |
---|---|
Format: | Course Material |
Language: | English |
Published: |
2021
|
Subjects: | |
Online Access: | http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545 |
id |
ftntunikharkhiv:oai:repository.kpi.kharkov.ua:KhPI-Press/55545 |
---|---|
record_format |
openpolar |
spelling |
ftntunikharkhiv:oai:repository.kpi.kharkov.ua:KhPI-Press/55545 2023-05-15T16:02:05+02:00 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" Orlovskyi, D. L. Kopp, A. M. 2021 application/pdf http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545 en eng 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" [Electronic resource] : for students of spec. 121 "Software engineering", 122 "Computer science", 126 "Information systems and technologies" / comp.: D. L. Orlovskyi, A. M. Kopp National Technical University "Kharkiv Polytechnic Institute". – Electronic text data. – Kharkiv, 2021. – 46 p. – URI: http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545. http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545 orcid.org/0000-0002-8261-2988 orcid.org/0000-0002-3189-5623 guidelines database management systems information technology programming Learning Object 2021 ftntunikharkhiv 2022-01-18T00:31:36Z 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. Course Material DML Electronic National Technical University "Kharkiv Polytechnic Institute" Institutional Repository (eNTUKhPIIR) |
institution |
Open Polar |
collection |
Electronic National Technical University "Kharkiv Polytechnic Institute" Institutional Repository (eNTUKhPIIR) |
op_collection_id |
ftntunikharkhiv |
language |
English |
topic |
guidelines database management systems information technology programming |
spellingShingle |
guidelines database management systems information technology programming Orlovskyi, D. L. Kopp, A. M. 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" |
topic_facet |
guidelines database management systems information technology programming |
description |
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. |
format |
Course Material |
author |
Orlovskyi, D. L. Kopp, A. M. |
author_facet |
Orlovskyi, D. L. Kopp, A. M. |
author_sort |
Orlovskyi, D. L. |
title |
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" |
title_short |
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" |
title_full |
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" |
title_fullStr |
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" |
title_full_unstemmed |
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" |
title_sort |
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" |
publishDate |
2021 |
url |
http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545 |
genre |
DML |
genre_facet |
DML |
op_relation |
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" [Electronic resource] : for students of spec. 121 "Software engineering", 122 "Computer science", 126 "Information systems and technologies" / comp.: D. L. Orlovskyi, A. M. Kopp National Technical University "Kharkiv Polytechnic Institute". – Electronic text data. – Kharkiv, 2021. – 46 p. – URI: http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545. http://repository.kpi.kharkov.ua/handle/KhPI-Press/55545 orcid.org/0000-0002-8261-2988 orcid.org/0000-0002-3189-5623 |
_version_ |
1766397704879996928 |