Ms Access Training in Hyderabad, Bangalore, Pune, Chennai and Dubai

Ms-Access Training Hyderabad (24 Days)

Look beyond Excel and get trained on Ms-Access database to use it for work or business. Training with practical examples on creating & designing of tables, queries, relationships, forms and reports. Create interactive and professional tools using Ms-Access database.

MS ACCESS TEST ONLINE (CHECK YOUR MS ACCESS SKILLS)

What after Excel: Access

Working with Access Tables

Queries

Why Access when Excel.
Excel Flat File vs Access Database.
Creating Access Tables with Excel Data.
Linking Access to Excel.
Creating Excel Pivot with Access.
Creating Access Data Connection in XL.
Using Excel Features in Access Tables.
Using Access as backend DB for Excel.
Using XL Vlookups in Access Tables.

Various ways of creating Access Tables.
Field Properties in Access Tables.
Uses of Primary Key.
Working in Design/Datasheet View.
Entering and Editing Data in Tables.
Using Sort, Filter and replace in Tables.
Insert Calculated fields and Expressions.

Understanding Queries.
Creating basic Queries in design View.
Creating queries using Wizard.
Adding Calculate fields and Expressions.
Defining Relationships.
Query joining multiple tables.
Introduction to SQL.
Queries based on strings, numbers..

Forms

Reports

Project: Building a Database

Create Form using Design View.
Create form using auto form tool.
Creating form in Datasheet View.
Creating form within a form.
Working with controls on the form.
Making a dynamic and interactive form.
Setting data source/sql query for a form.
Editing form in design/layout view.

Create a Report using wizard.
Working with report Layout
Preview and printing/exporting a report.
Creating a grouped report.
Statistical report.
Adding, changing, deleting fields.

Analyze the change environment to move from excel reporting to access.
Create tables and queries required to get the final output in access.
Generate required queries and reports from access.