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.

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.

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.