RIA

MS Access

MS Access Training in Marathahalli

MS Excel is a hidden gem, that contains countless possibilities that could make your job much easier and faster. To save your time and to organize your monotonous errands in the most operative way you can get MS Access training in Bangalore. This training will save you from bewilderment and tedious tasks.

 

Why choose RIA MS Access training in Bangalore

If flexible timing is what you are looking for, then the good news is that we facilitate you with flexible timing hours that you can pick to suit your comfort. You can select our weekend classes or weekday classes as per your choice, and start excavating the field. Our MS Access training in Marathahalli provides you the best-certified professionals who also possess several years of experience. There are advanced lab facilities that you can benefit from and we also provide assistance for you with your projects. Our efficient mentors train you by incorporating innovative and creative methods of teaching to make the learning experience fun and engaging. Through an applied teaching approach we give you an environment to practice the theories that you have learned.

 Another unique thing about our MS Access training in Bangalore is that we facilitate you with flexible timings and you can select appropriate classes according to your schedule. There will be weekend classes and weekday classes for you to choose from. We train both professionals as well as freshers, despite age limits, hence if you are looking for a perfect place to find answers to your doubts and discipline your work then joining our MS Access training in Bangalore will help you with it.

 

Why get MS Access Training in Bangalore

If you are dealing with a bulky amount of data on a day-to-day basis, then the basic understanding of MS Excel is not sufficient, as this tool is not apt to syndicate enormous information. But, by mastering MS Access training in Bangalore you can reference, report, and analyze information effortlessly. Moreover, if you prefer an affordable database that could handle large information, then studying MS Access in Bangalore is the best opportunity for you. MS Access can import many data at a time, without erasing existing ones, which means it is a time-effective, effort-effective solution that also avoids human errors.

Course summary

Study MS Access in the right way through practice and real-time examples with RIA MS Access training in Marathahalli. In our Coaching Centre, we instruct you from the beginning, that is, from opening a database, using menus, toolbars and creating a new workbook. We will train you how to work with a database, creating a new table from the beginning, an extensive study on how to manage tables and fields, indexing, adding captions, formatting text fields, validating, creating a value field, and so on. In our MS Access training in Bangalore we will learn about finding, filtering, and formatting, normalizing data, and establishing relationships by learning the usage of relationship tools, join tables, etc.

We will instruct you with designing and working queries, designing and working with forms, identifiers, subforms, pop-ups, standard reports, pop-up reports, sub reports, and report snapshots. Lessons on Pivot tables, Pivot charts, importing and exporting, building expressions, and code builder will be also provided by our course specialists. 

SYLLABUS

  • 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
  • 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
  • Creating a Subform
  • Creating a Form with Two Subforms
  • Creating Nested Subforms
  • Deleting a Subform
  • Creating a Modal Pop-up Form
  • Creating a Modeless Pop-up Form
  • 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
  • Creating a Modal Pop-up Report
  • Creating a Modeless Pop-up Report
  • Creating a Subreport
  • Creating a Report with Two Subreports
  • Deleting a Subreport
  • Creating Report Snapshots
  • Distributing Report Snapshots
  • 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
  • Creating Pivot Charts
  • Selecting Elements of a PivotT able
  • Selecting Elements of a Pivot Chart
  • Using the PivotTable AutoForm Wizard
  • Deleting Items from a PivotTable
  • Filtering Items in the Pivot Table List
  • Using the AutoCalc Feature
  • Displaying Subtotals
  • Using the Pivot Chart Auto Form Wizard
  • Deleting Items from a PivotChart
  • Filtering Items in the PivotChart List
  • Changing PivotChart Types

Importing And Exporting

  • 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 from Excel Files
  • Importing from Other Access Databases
  • Importing from ODBC Data Sources
  • Exporting to Files
  • Exporting to Access Databases
  • Exporting to ODBC Data Sources

Building Expressions

  • Using the Expression Builder in Queries
  • Using the Expression Builder in Forms
  • Using the Expression Builder in Reports
  • Using Date/Time Functions
  • Using Financial Functions
  • Using Math Functions
  • Using Text Functions
  • Using the Macro Builder in Queries
  • Using the Macro Builder in Forms
  • Using the Macro Builder in Reports.

Working with Code Builder.

ACCESS MACRO- VBA Programming

Duration-15 Hours

  • What is VBA Programming?
  • Benefits of using Macro.
  • Recording Macro.
  • Running of Macro using an Object.
  • Editing Macro.
  • Overview of different programming language
  • Operators
  • Decision making and looping
  • Functions
  • Working in Visual Basic Editor
  • Introducing the Access Object Model
  • VBA Sub and Function Procedures
  • 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
  • Connecting to share point
  • Connecting to SAP
  • Connecting to web portals
  • Connecting to data base.
  • 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.
  • Creating worksheet functions and calling functions
  • Creating Access Add-Ins
  • Creating User Manuals
  • VBA Security Option
  • Delivering the project
×