The database tools allow collecting, storage, handling and evaluation of different types of information. Using a database one can store data about persons, goods, services etc. In contrast to spreadsheet programs the databases usually uses several separate and interconnected tables to minimize duplicate records. The data can be easily accessed, managed and updated; regardless the database content is bibliographic, text, numeric or even graphical.
One of the tools to create and operate databases is Microsoft Office Access, a software product usually included in package MS Office. It offers standard objects to work with data including tables, forms, queries, reports, macros, modules etc. The theoretical information and principles of these objects are summarized in following presentations intended for preparation for practical exercises.
| Attachment | Date | Size | Availability [?] | Clinically sensitive [?] | Licence | |
|---|---|---|---|---|---|---|
| Databases in MS Access | 26.9.2022 | 1.22 MB | MEFANET user | – |  |
|
| Tables | 26.9.2022 | 667.6 KB | MEFANET user | – | |
|
| Forms | 26.11.2020 | 467.77 KB | MEFANET user | – | |
|
| Data selection | 26.11.2020 | 526.16 KB | MEFANET user | – | |
|
| Reports | 26.11.2020 | 321.24 KB | MEFANET user | – | |
4-D assessment:
 Textbooks and manuals |
 Educational websites and atlases |
 Digital video |
 Presentations and animations |
 Casuistics in images |
 E-learning courses (LMS) |
 Unreviewed |
 Undergraduate level |
 Graduate |
 Advanced Graduated |
 Complex |
HodnoceníPlease select achieved education degree and then evaluate the teaching material particularly in light of material suitability for self-learning.
Student – student of bachelor or master degree
Graduate – graduate of bachelor or master degree PhD. Graduate – Ph.D. student, Ph.D. graduate, researcher, ...
%
Number of users, who have already evaluated.: 12
47.5 %  user evaluation evaluate |
Courses
Contribution content is subject to licence Creative Commons Uveďte autora-Neužívejte dílo komerčně-Nezasahujte do díla Attribution 3.0 Czech Republic
Keywords: database, table, form, filter, query, report
citation: Jaroslav Majerník: Databases in MS Access. Multimedia support in the education of clinical and health care disciplines :: Portal of Pavol Jozef Šafárik University in Košice Faculty of Medicine [online] , [cit. 21. 11. 2024]. Available from WWW: https://portal.lf.upjs.sk/articles.php?aid=85. ISSN 1337-7000.