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.