Microsoft Access
Description
Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Curriculum For This Course
+ MICROSOFT ACCESS (10)
| Introduction to MS-Access 2010,2007,2003 - Getting Started, Creating a Databasen |
| Creating tables - Data types and sizes, Field properties, Creating indexes, Entering data, Editing and deleting data, Datasheet view and from view |
| Creating tables - Copying and moving data, Sorting data, Creating filters on data, Specifying relationships between tables |
| Creating simple queries using QBE grid - Queries involving multiple tables, Creating lookup queries |
| Prompting for selection Criteria - Using totals, averages, and other calculations, Creating crosstab queries, Action queries |
| Creating simple forms using Form Wizards - Main/sub forms |
| Introduction to macros -Creating and runing simple macros, Attaching macros to forms |
| Creating reports - Single-column reports, Tabular reports, Mailing label reports, Creating summary reports, Creating groups / totals reports, Creating a Word Mail Merge report |
| Creating graphs from your data - Importing data from Excel and other data sources, Exporting data to Excel and other formats |