ADVANCE EXCEL Basic of Excel, Getting Advance In Excel, Custom And Conditional Formats, Range Names, Using Formulas And Functions, Absolute And Relative Cell Reference, Excel Auditing Tool, Managing Tables, Working With Charts, Working With Pivot Tables, Multiple Workbooks, What-if Analysis, Working With Macros. MS ACCESS: Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools
1: Getting started with Access : Orientation to Microsoft Access, Create a Simple Access, Database, Get Help and Configure Options in Microsoft Access 2:Working with Table Data: Modify Table Data, ISort and Filter Records
3: Querying a Database : Create Basic Queries, Sort and Filter Data in a Query, Perform Calculations in a Query
4:Using Forms: Create Basic Access Forms, Work With Data on Access Forms
5: Generating Reports : Create a Report, Add Controls to a Report, Enhance the Appearance of a Report, Prepare a Report for Organize Report Information, Format Reports