Antonio Puglisi

EXAM SIMULATION

PRACTICAL TEST

Analysis of the resident population in Emilia-Romagna. 

File to download: http://campus.unibo.it/108616/

MS EXCEL

In the Analysis worksheet fill the blank cells with the required values; set the proper formatting before inserting the values into the cells. After the analysis, insert charts:

1. column representation of the resident population change in the capital provinces (Emilia-Romagna) for the years: 2008-2009 and 2008-2010
2. pie graph for the distribution of the capital provinces resident population in the year 2010 (only Emilia-Romagna)

MS ACCESS

Import the workbook EXAM_20_03_2012. Create the relationship between the 3 tables: CITIES, PROVINCES and REGIONS. Create queries for retrieve:

1. cities in Emilia-Romagna
2. capital provinces in Emilia-Romagna
3. number of inhabitants in the province of Bologna in 2010
4. name and resident population for all the cities in the province of Bologna in 2010
5. Emilia-Romagna resident population in the 2010