Microsoft Access |
| |
 |
| |
| Microsoft Access |
| |
|
| Module 1: Introduction to MS-Access 2010,2007,2003 |
| |
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 |
| |
| |
| |
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 20 sessions of 1 hr. each |
5,500 |
160 |
|
+91-22-23676218 / 23671772