Best Microsoft Access Training In Bangalore, India

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

• Planning a Database Microsoft Access
• 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.

• Understanding Field Properties Microsoft Access
• 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, Lookup Field
• Creating a Value List
• Modifying a Lookup List

• Finding and Replacing Information
• Sorting Records Microsoft Access
• 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.

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

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

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

• About Forms
• Choosing an Appropriate Control
• Placing Controls on a Form
• Moving a Control Microsoft Access
• 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 and Nested Subforms Microsoft Access
• Creating a Form with Two Subforms
• Deleting a Subform

• Creating a Modal Pop-up Form and 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 in 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 Microsoft Access
• Defining and creating a Data Source for a Stand-Alone Data Access Page

Creating Pivot Tables And Pivot Charts

• Creating Pivot Tables and Pivot Charts
• Selecting Elements of a Pivot Table Microsoft Access
• Selecting Elements of a Pivot Chart

• Using the PivotTable AutoForm Wizard
• Deleting Items from a PivotTable Microsoft Access
• 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 Microsoft Access
• Filtering Items in the PivotChart List
• Changing Pivot Chart Types

Linking To External Data Sources

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

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

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

Using The Expression Builder

• Expression Builder in Queries, in Forms, and in Reports

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

• Macro Builder in Queries, in Forms, and in Reports. Microsoft Office

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

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

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

• Essential VBA Language elements Microsoft Office
• 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 MS Office

• Connecting to share point and to SAP Microsoft Office
• Connecting to web portals and to the database. M

• Simple Dialog Boxes Microsoft Office
• 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. MS Office

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

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

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

• Assignment
• Final Assessment
• Interview Preparation
• Resume Support
• Project