Loader
whatsapp

TRAINING

Enroll Now microsoft-access-training

Online Training

Corporate Training

Classroom

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

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services