Section - 1

• Microsoft Access Proficient 2010
• Access 2010 - 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 2010 – 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 2010 – 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
• Case Study III

Section - 4

• Microsoft Access 2010 – 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.