Microsoft Certified Trainer No Comparison on Quality Emphasize on Industry best practices Fully Practical oriented sessions Concentration on Individual's challenges Customized training as per your needs Free access to online Blogs Get Video coverage for complete training

Topics Covered

1. Concept of MS Access 2. Starting Access 3. Familiarity with Quick Access Toolbar 4. Work Area of MS Access 5. Customization 6. Creating Database and Tables 1) Planning 2) Keys 3) Records 4) Data 5) Fields 7. Working with Fields and records 1) Modify Table 2) Sorting and Filter 8. Creating Data Entry Rules 1) Properties 2) Masks 3) Other useful rules of Data Entry 9. Relational Database Techniques 1) Keys 2) Relationships 3) Referential Integrity 4) Sub-data Sheets 10. Working with Queries 1) Query Wizard 2) Query Scratch 3) Query Design 4) Query Count 5) Different types of queries 11. Working with Forms 1) Overview 2) Form Wizard 3) Form scratch 4) Form design 5) Sub forms 6) Form commands 7) Sorting and Filter 8) Switch-board 12. Working with reports 1) Report Wizard 2) Report Design 3) Report calculations 4) Report format 5) Report Summary 6) Report labels 7) Report printing 13. Working with Macros 1) Create a macro 2) Attach a macro 3) Automate input 4) Validation macro 5) Auto execution 14. Sharing data with Word and Excel 1) Importing 2) Package design 3) Email 4) Export 15. Working with Pivot table and charts

Who should attend

Trained Engineers, Managers,General Managers,Executives,BPO Executives, MIS Personals, Accounts Personal, HR, Quality Analyst, Software Engineers, Project Managers, Developers, Test Leads, Program Managers, Research workers, Data Analysis departments, Students etc

Pre-requisites

Passion to Learn

What you need to bring

Concentration and zeal to learn

Key Takeaways

Audio Video Coverage for complete training Training Presentations solved samples discussed during the class Example Files