This compulsory course module aims to identify and learn advanced features of MS Excel to analyse, visualize and present data, learn how to integrate Excel and Access to manage data, learn basic features of Microsoft Access, learn to manage a small database using excel data and raw data, and then generate essential reports using the access database.
Intended Learning Outcomes
1.Examine database concepts and explore the Microsoft Office Access environment.
2. Design a simple database, build a new database with related tables, manage the data in a table.
3. Create and share compelling data visualizations.
4. Find and integrate data from multiple data sources in both Access and Power Bi applications.
5. Enrich data with calculations and other features available in Power BI.
The Corporate Skills Hub of the Enter Club operating under the Entrepreneurship Development Unit of the Faculty of Humanities and Social Sciences in the University of Sri Jayewardenepura organizes a work shop series which called CIGNO ’22 being partnered up …