TRAINING

Enroll Now

Microsoft Access Training

Database Fundamentals

1. RDBMS concepts
2. Database Design Principles
3. Introduction to MS-Access
4. Creating Database in MS-Access
5. MS-Access Objects - Introductions
6. Tables
7. Forms
8. Queries
9. Reports
10. Macros
11. Modules

Database Constraints (Primary Key, Foreign Key) SQL - Structured Query Language

• SQL Commands
• Data types

Data Definition Language

• Create Table Command
• Alter Table Command
• Drop Table Command

Data Manipulation Language

• Select Command
• Insert Command
• Update Command
• Delete Command

Filter Clause

• WHERE Clause
• GROUP BY Clause
• Having Clause
• Order by Clause

Operators

• Arithmetic Operators
• Comparison operators
• Logical Operators

Range Operators

• IN/NOT IN
• Between
Set Operators
• Union
• Union All
• Intersect

SQL Functions

• Aggregate Function
• Date Function
• String Function

Joins

• Simple Join
• Equi Join
• Non equi Join
• Self Join
• Inner Join
• Outer Join
• Left Outer Join
• Right Outer Join

Queries

• Simple Queries
• Sub queries
• Nested Queries
• Correlated Sub Query

Search expressions

• Like
• with Nulls

FORMS

• FORM Controls
• TextBox, Combobox, CheckBox, Option Button, ListBox, Labels, Command Buttons etc.
• Form Events
• Design Forms
• Sub Forms
• SQL commands using in VBA modules
• Linked Table,
• Import Text File, Excel File, CSV File
• Export Data to Excel File, Text File,
• Connecting to Excel
• Consolidate Excel Files to Access Database
• Automation Project