MS Access Topics Covered
Microsoft Access Topics Covered |
Module 1: Introduction to MS-Access 2016,2013,2010 |
~ 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 |