About the program
This course focuses on using Microsoft Access for creating and managing databases, while also covering advanced Excel techniques for data manipulation and reporting. This program is ideal for individuals looking to enhance their ability to handle and analyze large datasets in a professional environment.
Admission Requirements
- Basic computer literacy.
- Familiarity with Microsoft Office applications is recommended but not required.
- Access to a laptop or desktop computer with Microsoft Office (including Access and Excel) installed.
Course Outline
Introduction to Microsoft Access
Understanding databases and the Access interface. Creating and designing tables
Building and Managing Databases
Creating queries to extract and analyze data. Designing forms for data entry and management
Introduction to Microsoft Excel
Overview of Excel’s interface and functionalities. Introduction to Excel formulas and functions
Data Integration: Access and Excel
Importing and exporting data between Access and Excel. Using Excel to analyze data stored in Access
Advanced Data Analysis in Excel
Utilizing advanced formulas and functions (SUMIF, COUNTIF, etc.). PivotTables and PivotCharts for comprehensive data analysis
Final Project
Designing a fully functional database in Access. Analyzing and reporting data using Excel
Duration
12 Weeks
Costs
High-quality tech education at an affordable cost
Monthly
E650
/month
If you choose this plan, you will pay the same amount in tuition every month.
Upfront
Best Choice
E1600
once-off
If you pay in full when you resume, you get E350 off the tuition fee.
Career Outcome
Upon completing this course, students will be proficient in using Microsoft Access for database management and Microsoft Excel for advanced data analysis. These skills are highly valuable in various industries, including finance, marketing, operations, and any role that requires data management and reporting capabilities.