Download
App
Brochure download
Fill in your details
  • +91-80-42188793
  • enquiry@itasinc.in

Mega Package : Essential Skills for Data Science, Data Analytics, Business Analytics, MIS Reporting --> 26 Courses, 350+ Videos, 150+ Hours Video Contents, Downloadable Practice Files, 300+ Downloadable E-Books, 150 MS Excel Editable, Reusable templates, 300+ Excel, CSV Data Sets, 100000+ Infographics, Graphics & Images Library, 1000+ Sample Editable Resumes, 70000+ Designer Fonts, Instagram, YouTube Thumbnails & Stories

>

MS Access with SQL

Fees : Rs 8,500 Only

Duration : 24 Hours

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access helps you analyze large amounts of information and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.

Prerequisites:

You do not need any previous knowledge of MS Access, but should have basic windows, keyboard and mouse skills

Course Objectives:

After the course, you will be able to:

  • Create and maintain Databases and Tables
  • Query the database
  • Prepare Reports
  • Create simple Data Entry Forms

Course Contents

  • Understanding Database Terminologies
  • DBMS & RDBMS
  • Normalization,
  • Data Integrity, Database Relationship
  • Understanding Screen Layout
  • Creating a Database
  • Data Import & Export from Various Data sets
  • File Menu Tab
  • The Ribbon
  • Quick Access Toolbar
  • Options
  • General
  • Current Database
  • Datasheet
  • Object Designers
  • Proofing
  • Client Settings
  • Customize
  • Table
  • Query
  • Recordset
  • Form
  • Report
  • New Database Database Templates
  • Table Views
  • Adding New Fields
  • Data Types
  • Editing Data Types in Fields
  • Creating, Save, Rename Table
  • Understanding Various Data types
  • Setting field properties
  • Setting Field properties & Validation Rules
  • Modify Table Structure
  • Primary Key
  • Composite Key
  • Foreign Key
  • One-to-One Relationship
  • One-to-Many Relationship
  • Creating a Table Relationship
  • Print a Table Relationship Report
  • Add Records to a Table
  • Find and Replace
  • Totals
  • Sort Records
  • Filter
  • DML (Data Manipulation Language)
  • DDL (Data Definition Language)
  • Query Wizard
  • Query Design Feature
  • Query Criteria
  • Writing Queries using SQL & Design View
  • Using WHERE, GROUP, ORDER BY, HAVING
  • Different Types of JOINS
  • Expressions & Expression Builder
  • Using an IIF Function
  • Displaying Top or Bottom Values
  • Crosstab & Parameter Queries
  • Make-Table, Delete, Append, Update Queries
  • Expressions
  • Zoom
  • Form Views
  • Create a Form
  • Form Wizard
  • Report Views
  • Create a Report
  • Report Wizard
  • Custom Calculated Fields
  • Print a Report

iTAS (iTech Analytic Solutions) is a complete Analytics Solution provider with. unparalleled value-optimizing Information Insight to client organizations through the use of cutting-edge, customized reporting systems, analytical models, and database applications

iTAS (iTech Analytic Solutions) provides data driven business decisions with quantitative modeling expertise & deep understanding of business needs and state-of-the-art technologies to solve complex problems.

Contact Us

  • +91-80-42188793
  • Branch 1:No. 9, 1st Floor, 8th Main, 9th Cross, SBM Colony, Brindavan Nagar,Mathikere, Bengaluru, Karnataka, India - 560054
  • Branch 2:#403, 11th Cross,19th Main, 1st Block, Rajajinagar, Bengaluru - 560 010

Enquiry

  • M: +91 9066068793, 9066078793, 9902058793
  • E: enquiry@itasinc.in

Placements

  • M: +91 7619483672
  • E: jobs@itasinc.in

Copyright ©2018 iTAS. All Rights Reserved