Multimedia support in the education of clinical and health care disciplines :: Portal of Pavol Jozef Šafárik University in Košice Faculty of Medicine
Lekárska fakulta Univerzity Pavla Jozefa Šafárika v Košiciach
MEFANET Project (MEdical FAculties Educational NETwork)

Databases in MS Access

Databases in MS Access

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.

Attachments:
Attachment   Date Size Availability [?] Clinically sensitive [?] Licence
pdf Databases in MS Access Download - Databases in MS AccessOpen in new window - Databases in MS Access 30.9.2018 536.19 KB MEFANET user Creative Commons License
pdf Tables Download - TablesOpen in new window - Tables 8.10.2017 328.38 KB MEFANET user Creative Commons License
pdf Forms Download - FormsOpen in new window - Forms 22.10.2017 456.03 KB MEFANET user Creative Commons License
pdf Data selection Download - Data selectionOpen in new window - Data selection 29.10.2017 347.41 KB MEFANET user Creative Commons License
pdf Reports Download - ReportsOpen in new window - Reports 22.11.2017 292.47 KB MEFANET user Creative Commons License
 

Keywords: database, table, form, filter, query, report

4-D assessment:

typ
Textbooks and manuals
typ
Educational websites and atlases
typ
Digital video
typ
Presentations and animations
typ
Casuistics in images
typ
E-learning courses (LMS)
result
Unreviewed

level
Undergraduate level
level
Graduate
level
Advanced Graduated
level
Complex
   
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.: 7
70.0 %
rating
user evaluation
evaluate

author: Jaroslav Majerník | organization: Department of Medical Informatics | published on: 28.11.2010 | last modified on: 30.9.2018
citation: Majerník Jaroslav: Databases in MS Access. Multimedia support in the education of clinical and health care disciplines :: Portal of Faculty of Medicine [online] 2010-11-28, last modif. 2018-09-30 [cit. 2019-03-18] Available from WWW: <http://portal.lf.upjs.sk/articles.php?aid=85>. ISSN 1337-7000.
 

Comments and discussion

Insert new entry:

Author / e-mail: [ user login / verification ]
Title:
Text:
 
 Add tag:   The tag has been submitted, thank you