Section - 1

• An Introduction to Microsoft Access 2003
• Access 2003 - Overview
• Access  as a Development Tool
• Database, Tables, Queries, Forms, Reports, Data Access Pages
• Object Naming Conventions
• Building a New Table
• Selecting  Field Data Types
• Working with Field properties
• Primary Key - Importance
• Working with Table properties
• Indexes – To improve Performance
• Data Integrity – Relationships
• Establishing the Relationships
• Referential Integrity – Implementation
• Benefits of Relationships
• Indexes and Relationships
• Exercise I
•  
• Case Study I

Section - 2

• Microsoft Access 2003 – Continued
•  
• Queries
• Query Basics
• Ordering Query Results
• Query Refinement with Criteria
• Updating the Query Results
• Multiple tables Query
• Creating Calculated Fields
• Nulls and Query Results
• Building Parameter Queries
• Exercise II
•  
• Case Study II

Section - 3

• Microsoft Access 2003 – Continued 
• Forms
• Uses of Forms
• Anatomy of Form
• Creating a New Form
• Working with Form Design Window
• Selecting the Correct Control for the job
• Control Morphing
• Conditional Formatting
• Form Properties
• Building Forms- Based on More tables
• Exercise III
•  

Section - 4

• Microsoft Access 2003 – Continued
•  
• Reports
• Report Types
• Anatomy of Report
• Creating a New Report
• Working with Report Design Window
• Selecting the Correct Control for the job
• Report Properties
• Page Breaks
• Building Reports – More than a Table
• Working with Reports – Sorting and Grouping
• Exercise IV
•  
• Case Study IV

Section – 5 

• Project Work

 

Section - 6

Introduction to Outlook

Quickbooks as an Accounting tool

INTERVIEW QUESTIONS, RESUME & INTERVIEW TIPS

Each Day includes Theory and Lab practice

• Examples based on theory
• Exercises

What you’ll learn

• Creating of Database Tables, Query, Working with Forms, Building Reports using MS –Access 2003. Introduction to MS-Outlook and Quick books accounting Tool.