MS Access Training in Bangalore

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

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