Advanced Excel Courses Mumbai, VBA Macros in Excel Courses Mumbai
     
   
IT Corporate Training
     
     
   
Microsoft Access - 2003
     
 
Microsoft Office
   
 
 
 
 
 
 
 
 
 
 
 
 

Module 1: Introduction to MS-Access 2010,2007,2003
Duration : 2 Half Days

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

Contact us related to our Corporate IT Courses
Email
Mobile Number
faiyaz@compufield.net
corporates.training@gmail.com
+91-9819006132
(Mr. Faiyaz M Khairaz)
OFFICES: Kemps Corner | Bandra (W) | Andheri (W)
: +91 9819006132 / +912226551794

 


 




Solve your Queries Online related to our Courses

E_mail me E-mail me
khairaz@compufield.com

Yahoo MessengerYahooMessenger
compufield@yahoo.com
ICQ MSN Messenger
compufield@hotmail.com

MSN MessengerMobile Number
+91-9820134058

(Mr. Khairaz [MD])

OFFICE : Chinoy Mansion, First Floor, Block # 2, Opposite Church, Warden Road, Mumbai (Bombay)-400 036,India
: 091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772