home
web development
about us
enquiry form
credentials
site map
   
     
     
   
IT Corporate Training
     
     
   
Microsoft Access - 2003
     
   
 
Enquire About This Course
     
Name
     
Contact
     
Email
     
Enquiry
     

Upcoming Workshop
   
  Advance Excel 2 Days Workshop In Mumbai
   
  Schedule For May - June 2010
   
  Classroom Video -
1st May '2010
   
 
   
   

Microsoft Office
   
 
 
 
 
  MS-Excel-Macros
 
 
 
  MS-Project Management
 
 
Creative Courses
   
 
 
 
 
 
 
   
Network Courses
   
 
 
 
   
 
Web Designing
 
 
 
 
 
 
   
 
Programming Courses
   
  C Programming
  C++Programming
  Java
  PHP & MySQL
  LAMP
  SQL Server 2005
  Oracle 9i SQL & PL-SQL
  Advance Excel+VB(Part)
  DOT NET Technologies
  Crystal Report 11

2 Days Workshop In Mumbai For
MS Project Management- Click Here



To study this course in classroom - CLICK HERE

Module 1: Introduction to MS-Access 2003
Duration : 2 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