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 |