Provide the basic knowledge, theoretical and practical, for the creation of a database with Microsoft
Access and process data with Microsoft Excel.
Difference between information systems and computer systems.
Models of conceptual design:
- Database, DBMS (DataBase Management System)
- E-R diagram (Entity-Relationship)
- Cardinality (one-to-one, one-to-many, many-to-many)
Practical exercises in the laboratory with the use of Microsoft Access and Excel.
The course schedule will be available on the 'e-learning site for the course (Moodle) on January 15, 2020.
|Lughezzani F., Princivalle D.||Nuova ECDL. Syllabus 6. Base + full standard extension||Hoepli||2018||9788820383152|
The exam is divided into two parts:
1. multiple choice test;
2. creation of a database with Access and a spreadsheet (calculations, graphs, etc.) with Excel.
Due to the Coronavirus pandemic, and in accordance with the University of Verona guidelines, during the 2020 summer session the assessment modality will be modified as follows: [online oral exam, online written exam, etc.]
Viale dell'Università 4
VAT number 01541040232
Italian Fiscal Code 93009870234
© 2020 | Verona University | Credits