2 Half Days Workshop In Microsoft Access

MS-Access 2016,2010,2007,2003

Microsoft Access is a software program used to build and run databases.Whether you are new to Access or an advanced user, this training will cover what you need to know as efficiently as possible.

Module 1: Introduction to MS-Access 2010,2007,2003

  • Getting Started
  • Creating a Database

 

Module 2: Creating tables

  • Data types and sizes
  • Field properties
  • Creating indexes
  • Entering data
  • Editing and deleting data
  • Datasheet view and from view

 

Module 3: Creating tables

  • Copying and moving data
  • Sorting data
  • Creating filters on data
  • Specifying relationships between tables

 

Module 4: Creating simple queries using QBE grid

  • Queries involving multiple tables
  • Creating lookup queries

 

Module 5: Prompting for selection Criteria

  • Using totals, averages, and other calculations
  • Creating crosstab queries
  • Action queries

 

Module 6: Creating simple forms using Form Wizards

  • Main/sub forms

 

Module 7: Introduction to macros

  • Creating and runing simple macros
  • Attaching macros to forms

 

Module 8: Creating reports

  • Single-column reports
  • Tabular reports
  • Mailing label reports
  • Creating summary reports
  • Creating groups / totals reports
  • Creating a Word Mail Merge report

 

Module 9: Creating graphs from your data

  • Importing data from Excel and other data sources
  • Exporting data to Excel and other formats

Talk to the Trainer or Enquire about the Program


A great learning experience!!! Teaching was in depth and explained very well. Mr. Faiyaz Khairaz covered all important aspects of Microsoft Excel and Outlook. Would definitely recommend to all those who want to learn about the various aspects of using Microsoft Office Package.
Paras Bhalla
Paras Bhalla
14:19 16 Jun 17
This was an amazing experience. The entire session was really a great learning experience. I would recommend this to all corporates.
ABHINAV CHAUDHRY-DM
ABHINAV CHAUDHRY-DM
04:03 19 Jun 17
The training by Mr Faiyaz was sublime.. I got to know many new things and revision of known things.. Overall it was splendid expereince of Excel training.. Thanks for imparting such good knowledge
SWATI MISHRA
SWATI MISHRA
05:28 01 Jun 17
A great workshop just ended for us at Mahindra buses and trucks...fayaz was very helpful and indeed persuasive in getting us ingrained in excel and outlook ... Would recommend ... Cheers
Bharat Raghavan
Bharat Raghavan
03:05 18 Jun 17
It was an excellent training session. Mr. Faiyaz has given us perfect guidance. The Excel Program was truly beneficial.
MIS India Private
MIS India Private
14:06 20 Jul 17
It was a great corporate experience of learning advanced excel in a good ..smooth..faster way with hardwork and determination lead by Faiyaz...Very Good Keep It up ...Sterlite Tech Employee
Kalpesh Sambhria
Kalpesh Sambhria
13:58 20 Jul 17
Good Teaching Skills. Opened the completely new area of EXCEL. Would definitely suggest to my colleagues.
Samir Maner
Samir Maner
11:10 17 Aug 17
We had a two-day intensive workshop on Microsoft Excel in our corporate office and to sum up the experience let's just say beginner to pro in two days. Great learning session from the certified tutor, Mr. Faiyaz Khairaz.
Gilbert Khakhlari
Gilbert Khakhlari
11:45 21 Aug 17
Hii. Excellent & very nice trainer and thanks for sharing your knowledge and experience with us.thanksJitendra Kumar
Excise Mumbai
Excise Mumbai
06:42 22 Aug 17