Riainstitute Bengaluru

MS Access Training in Bangalore

Best MS Access Training in Bangalore

MS Access Training in Marathahalli, Bangalore by RIA institute offers students an innovative way to learn MS Access in Bangalore. With experienced MS Access professional trainers and advanced lab Facilities to practice MS Access, students can complete MS Access training on real time scenario. Our MS Access Training institute in Bangalore is rated as one of the Best MS Access Learning Centre on Google.

Training methodology used for conducting MS Access course includes ease of understanding MS Access concepts, latest examples in MS Access classes and real time practical exposure. This ensures that students opting for MS Access training in Marathahalli, Bangalore get value for money. Our MS Access course content is structured to cover all concepts under MS Access Training.

Enquire This Course

    Advantages of Studying MS Access with Us

    • MS Access Hands on experience
    • Project support on MS Access
    • Real time exposure on latest MS Access modules
    • Advanced MS Access Training methodologies
    • Lab facilities and guidance

    MS Access Trainers at RIA Institute

    • 8+ Years of experience on MS Access Projects
    • Has worked on multiple real-time MS Access scenarios
    • Worked as Top MS Access Consultant in MNC’s across the globe
    • Trained over 100 students over the years
    • Certified MS Access industry professional
    • Strong Knowledge of MS Access Theory and Practical’s

    MS Access Training Facilities

    Coaching facilities for MS Access Training in Marathahalli, Bangalore are best suited for Fresher’s as well as experienced professionals who are actively looking for upgrading skills in MS Access. From MS Access training consultation to MS Access course completion we offer complete support to students. Regular reviews are conducted to ensure that MS Access Training is being conducted in a structured manner and the students are able to understand all the MS Access Training concepts.

    MS Access Training Batch Timings

    We offer flexible batch timings for MS Access Training in Bangalore. Students can choose to join our weekday batches for MS Access course and IT professionals looking for MS Access Training to advance in their career can join our Weekend classes based on their convenience. We also offer Fast Track Training for students who want to complete MS Access course in detail in a short span.

    MS Access Course Content

    Our MS Access Course content is structured to cover all the modules within MS Access. From basic to advance, we give MS Access training in Bangalore in a manner that is easy to understand.

    Below is the detailed course content for MS Access Training

    Introduction to Databases

    • Starting Access and Opening a Database
    • Understanding the Access Program Screen
    • Using Menus
    • Using Toolbars and Creating a New Workbook.

    Creating and Working with a Database

    • Planning a Database
    • Creating a Database Using the Database Wizard
    • Creating a Blank Database Creating a Table Using the Table Wizard
    • Modifying a Table and Understanding Data Types
    • Creating a New Table from Scratch.

    Working with Tables and Fields

    • Understanding Field Properties
    • Indexing a Field
    • Adding a Primary Key to a Table
    • Inserting, Deleting, and Reordering Fields
    • Changing a Field’s Data Type
    • Using Field Descriptions
    • Adding a Caption
    • Change the Field Size
    • Formatting Number, Currency, and Date/Time Fields Formatting
    • Formatting Text Fields
    • Setting a Default Value
    • Requiring Data Entry
    • Validating Data
    • Creating an Input Mask
    • Creating a Lookup Field
    • Creating a Value List
    • Modifying a Lookup List

    Finding, Filtering, and Formatting Data

    • Finding and Replacing Information
    • Sorting Records
    • Filtering by Selection
    • Filtering by Form
    • Creating an Advanced Filter
    • Adjusting Row Height and Column Width
    • Rearranging Columns
    • Changing Gridline and Cell Effects
    • Freezing a Field Hiding a Field Changing .

    Normalizing Data

    • Setting a Primary Key
    • Removing Non-related Data
    • Removing Redundant Data
    • Removing Repeating Data
    • Setting Required Values in Columns

    Establishing Relationships

    • Using the Relationship Tool
    • Identifying a Related Table
    • Creating Join Types
    • Enforcing Referential Integrity
    • Working with Cascading Updates and Deletes

    Designing & Working With Queries .

    • Creating Select Queries.
    • Creating Update Queries
    • Creating Delete Queries
    • Creating Append Queries
    • Creating Make-Table Queries
    • Creating a One-Parameter Query
    • Creating a Two-Parameter Query
    • Creating Calculated Fields
    • Using Common Functions in Calculated Fields
    • Using AND,OR Operators in Queries

    Designing & Working With Forms .

    • About Forms
    • Choosing an Appropriate Control
    • Placing Controls on a Form
    • Moving a Control
    • Resizing a Control
    • Setting Control Properties
    • Creating Page Headers and Footers
    • Creating Form Headers and Footers
    • Setting Form Properties
    • Working with Identifiers

    Working With Subforms

    • Creating a Subform
    • Creating a Form with Two Subforms
    • Creating Nested Subforms
    • Deleting a Subform

    Creating Pop-Up Forms

    • Creating a Modal Pop-up Form
    • Creating a Modeless Pop-up Form

    Working With Standard Reports

    • About Reports
    • Placing Controls on a Report
    • Moving a Control
    • Resizing a Control
    • Setting Control Properties
    • Creating Page Headers and Footers
    • Creating Report Headers and Footers
    • Sorting Records on a Report
    • Grouping Records on a Report
    • Setting Report Properties

    Working With Pop-Up Reports

    • Creating a Modal Pop-up Report
    • Creating a Modeless Pop-up Report

    Working With Sub reports

    • Creating a Subreport
    • Creating a Report with Two Subreports
    • Deleting a Subreport

    Working With Report Snapshots

    • Creating Report Snapshots
    • Distributing Report Snapshots

    Developing Data Access Pages

    • Using the New Data Access Page Wizard
    • Defining a Data Source for a Stand-Alone Data Access Page
    • Creating Stand-Alone Data Access Pages

    Working With Pivot Tables And Pivot Charts

    Creating Pivot Tables And Pivot Charts

    • Creating Pivot Tables
    • Creating Pivot Charts
    • Selecting Elements of a PivotT able
    • Selecting Elements of a Pivot Chart

    Creating Pivottable Forms

    • Using the PivotTable AutoForm Wizard
    • Deleting Items from a PivotTable
    • Filtering Items in the Pivot Table List
    • Using the AutoCalc Feature
    • Displaying Subtotals

    Creating Pivotchart Forms

    • Using the Pivot Chart Auto Form Wizard
    • Deleting Items from a PivotChart
    • Filtering Items in the PivotChart List
    • Changing Pivot Chart Types

    Importing And Exporting

    Linking To External Data Sources

    • Linking to Text Files
    • Linking to Microsoft Excel Spreadsheets
    • Linking to HTML Files
    • Linking to Other Access Databases
    • Linking to a SQL Server ODBC Data Source

    Importing Data Into Access

    • Importing from Excel Files
    • Importing from Other Access Databases
    • Importing from ODBC Data Sources

    Exporting Data From Access

    • Exporting to Files
    • Exporting to Access Databases
    • Exporting to ODBC Data Sources

    Building Expressions

    Using The Expression Builder

    • Using the Expression Builder in Queries
    • Using the Expression Builder in Forms
    • Using the Expression Builder in Reports

    Using Common Built-In Functions

    • Using Date/Time Functions
    • Using Financial Functions
    • Using Math Functions
    • Using Text Functions

    Using The Macro Builder

    • Using the Macro Builder in Queries
    • Using the Macro Builder in Forms
    • Using the Macro Builder in Reports .

    Working with Code Builder

    Working with Command button Wizard

    ACCESS MACRO- VBA Programming
    Time: 15 hrs

    Introduction to VBA:

    • What is VBA Programming?
    • Benefits of using Macro.
    • Recording Macro.
    • Running of Macro using an Object.
    • Editing Macro.

    Basic Programming Concept:

    • Overview of different programming language
    • Operators
    • Decision making and looping
    • Functions

    How VBA work with Access:

    • Working in Visual Basic Editor
    • Introducing the Access Object Model
    • VBA Sub and Function Procedures

    Use VBA programming concept in Macro:

    • Essential VBA Language elements
    • Working with Range objects
    • Using VBA and worksheet functions
    • Controlling program flow and making decisions; IF, If Else, Else If, Do While, Do Until Loop, Select Case
    • Automatic Procedures and Events
    • Error Handling Techniques

    External Connectivity:

    • Connecting to share point
    • Connecting to SAP
    • Connecting to web portals
    • Connecting to data base.

    Communicating with your Users:

    • Simple Dialog Boxes
    • User Form Basics
    • Designing User Form
    • Using User Form Controls
    • User Form Tricks and Techniques
    • Accessing the Macro through User Form
    • Linking one Form to another Form
    • Progress Indicator.

    Putting it All Together:

    • Creating worksheet functions and calling functions
    • Creating Access Add-Ins

    Completing the Project:

    • Creating User Manuals
    • VBA Security Option
    • Delivering the project

    Best MS Access Training institute in Bangalore

    • Trained over 2000 students
    • Over a Decade of experience in Training industry
    • Experienced and Certified trainers
    • Practical and Theory training
    • Flexible Batch timings