Unit AAF-ADVANCED ACCESS
- Course
- Economics and culture of human nutrition
- Study-unit Code
- A001328
- Curriculum
- In all curricula
- Teacher
- Lorenzo Vergni
- Teachers
-
- Lorenzo Vergni
- Hours
- 10 ore - Lorenzo Vergni
- CFU
- 1
- Course Regulation
- Coorte 2020
- Offered
- 2020/21
- Learning activities
- A scelta dello studente
- Area
- A scelta dello studente
- Academic discipline
- NN
- Type of study-unit
- Opzionale (Optional)
- Type of learning activities
- Attività formativa monodisciplinare
- Language of instruction
- Italian
- Contents
- Medium/advanced design and management of relational databases.
- Reference texts
- Video lessons on Unistudium
- Educational objectives
- The course aims to provide the main knowledge for the design and management of relational databases with the Access program.
Knowledge: tables, relationships, data types, queries, query types, forms, reports.
Skills: knowing how to create and manage the various tools of a relational database - Prerequisites
- Confidence with basic PC interaction commands.
Informatica avanzata - Teaching methods
- The course is delivered through the Unistudium platform. To complete the course and to access the exam, all the video lessons have to be completed on the Unistudium platform
- Learning verification modality
- Practice test on advanced Access features.
- Extended program
- Introduction to databases, simplified management for creating fields and tables, text format-numeric properties, guided search of a field, search multiple wizard, data validation, default value. Relationships: introduction, relationships, types of joins and their management. Queries: criteria, comparison operators, query types, and subquery. The masks: design and creation, the controls. Pivot tables in Access and pivot charts in Access. The reports. The macro designer, the table events and the macros, the named macros. Macros and events. Import and export of data, tools and instruments.