Excel, Access, VBA skills are used in every companies, specially in large bank and insurance companies.
This course is opening to meet students demand.
After you find a high pay job as a database analyst, you want yourself to be armed with advanced Excel, Access and VBA skills as well.
Stunning reports and visualizations with Excel, advanced VBA programming and Basic Access database are used in most of big companies, especially in large bank and insurance enterprises.
Week One : Introduction - Install Access and Import Data ( 4 Hours)
• Introduction
• Excel &Access (2013, 2016) Integration
• Open several Access Databases
• Table Datasheet View
• Different Types of Data
• Import an Excel Worksheet to Access
• Linking an Excel Worksheet to Access
• Lab1:Importing a Worksheet into a New Table
• Lab2: Interview Test-How to Design a Dynamic Financial Quarterly Result Report by Using Excel Formula
• Configure ODBC for SQL Server Database connections
• Import data from remote SQL Server database to Access tables
• Create table relations, concept of table constraints
• Access Query
• Select One Single Query From One Table
• Select Query From Multiple Tables
• Query Operation For Calculation
• Define a Query For Report
• Export a Access Report to Excel
• Creating and Modifying Grouped Reports
• Customizing Reports with Formatting
• Page Layout Techniques
• Lab1 Join Two Tables
• Lab2 Use The Find Duplicates Query Wizard
• Lab3 Find Unmatched Rows
Week Two: Access and SharePoint, Reports, Forms ( 4 Hours)
• Introduction of SharePoint
• Upload files to SharePoint Site
• Link Access tables to SharePoint List
• Export Access table date to SharePoint Lst
• Import SharePoint List to Access Table
• Move Access database tables to SharePoint Lists
• Create Access Web Applications
• Publish Access Web Application on Web
• Access Reports
• Import data from Remote SQL Server Database
• Access Forms for different businesses
• Develop a Patient Navigation Forms
Week Three: Excel in a Nutshell ( 4 Hours)
Chapter 1. Introduction : Excel in a Nutshell
Introducing Excel objects
Chapter 2. Excel Fromula and Formmatting: Tricks and Techniques
2.1 use Formulas
2.2 Formatting basics
2.3 Recording Marcos
2.4 Project 1
Week Four: Excel Visual Basic for Applications (VBA) Fundamental ( 4 Hours)
Chapter 3. Excel Visual Basic for Applications (VBA) Fundamental
3.1 Introducing VBE
3.2 Variables, Data type and Constants
3.3 Working with Sub Procedures
3.4 Createing Function procedures
3.5 VBA Programming Examples and Techniques
3.6 Project 2 : A real project.
Week Five: Advanced Excel VBA ( 4 Hours)
Chapter 4. Advance VBA: UserForms, Excel Utilities, Pivot Tables, Charts and Events.
4.1 Working with UserForm (important)
4.2 Advanced UserForm Techniques
4.3 Excel Utilities
4.4 Working with Pivot Tables
4.5 Working with Charts
4.6 Understanding Excel's Events
4.7 Interacting with Other Application
4.8 Project 3
Starging with VBA to walk through the application developing process which hopefully will benefit you in the future when you decided to learn anohter programming language.
Excel is still a very useful tool for a lot of companies.