MS Access Database with SQL and VBA
Create business databases in MS Access 2024/365 with tables, queries, SQL, forms, reports, macros and VBA.
Course highlights
Sujeet Sir
21 Years Exp.
Excel | VBA | Power BI | SQL | Python
Data Analytics Expert & Corporate Trainer
- Sujeet Kumar Singh (MCA), founder of IPT Excel School since 2007
- Worked as MIS Executive and VBA Developer in 10+ companies
- Report consultant for 40+ organizations
What you will learn
Tables, data types and import or export with Excel, XML and PDF.
Cross tab, make table, append, update and delete queries.
SELECT, GROUP BY, joins, INSERT, UPDATE and ALTER TABLE.
Simple and multi-table forms with a live project.
Forms connected to queries and built-in functions.
Macros with events and conditions, VBA code in forms.
UserForm concepts, multi-page forms and charts on forms.
Excel, Oracle and web data, reports in PDF, Word and HTML.
BENEFITS
- Manage records better than a plain spreadsheet
- Create forms and reports for your office
- Use SQL and VBA to automate your database
YOUR GOAL
Design and deliver a working Access database project.
WHO SHOULD LEARN
Small offices that need a simple database.
COURSE OUTLINE
⬇ Download PDF1. Basic Access database
- Introduction
- Creating tables and data types
- Copying data from Excel
- Macros in tables
- Subdatasheets
- OLE objects
- Importing from Excel, Access, Oracle or Outlook
- Exporting to Excel, XML and PDF
2. Queries
- Query wizard
- Cross tab
- Find duplicates and unmatched
- Design queries with conditions and LIKE
- Calculations and built-in formulas
- Financial formulas (PMT, PV, FV, IPMT, PPMT)
- Make table, append, update and delete queries
- Relationships
3. Queries with SQL
- SELECT, AND, OR, BETWEEN and NOT
- GROUP BY with SUM, COUNT, MAX, MIN and AVG
- DISTINCT, LIKE, IN, EXISTS and HAVING
- UNION and INNER JOIN
- INSERT, UPDATE and DELETE
- CREATE, DROP and ALTER TABLE
4. Forms
- Simple forms with buttons
- Choosing fields
- Formatting
- Forms with 3 or more tables
- Form wizard
- Live project
5. Form with SQL and built-in functions
- Forms connected to queries
- INSERT from a form button
- Combo box by state
- Live project
- Logical, text, date and time, lookup, database and math functions
6. Access macros
- Macros in forms
- Macros with events
- Macros with conditions
7. VBA macros programming
- Introduction
- Data types
- Calculations
- Functions and formulas
- Connecting other applications
- VBA code in forms
- Events
- Pictures and objects
- List box and combo box automation
8. Advanced forms and picture automation
- UserForm concepts
- TextBox, Label, ComboBox and ListBox
- Duplicate filters
- Multi-page forms
- PDF and media player
- Pictures and charts on forms
9. Database connectivity and reports
- Excel, Notepad and web data
- Embedding applications
- SQL or Oracle
- File and folder access
- Reports with PDF, MS Word and HTML
- Live project for final certification
COURSE DETAILS
| Duration | 40 to 50 hours |
|---|---|
| Level | Advanced |
| Class time | Mon to Fri: 1 hour daily, or Sat and Sun: 2-hour classes |
| Batch size | 1 to 3 students (one-to-one or small group) |
| Mode | Live online on Google Meet |
| Language | Hindi or English |
| Projects | Live projects and a final certification project |
| Certificate | Yes, with real project work |
| Support | Phone and Google Meet doubt support |
| Demo | Free 3-4 day demo class |
| Fees | Contact Sujeet Sir: +91 88025 79388 |
HOW IT IS TAUGHT
Live on Google Meet by Sujeet Sir in Hindi or English, with real company examples, projects, a certificate and doubt support on phone after the course.
Join a free demo
Questions about this course
What is the fee of the MS Access Database with SQL and VBA course?
Fees depend on one-to-one or group batch. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.
Is there a free demo?
Yes. Join the 3-4 day free demo before you pay.
Which language is it taught in?
Hindi or English, as you prefer.