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