• Introduction of Database and Relational Database
• Building a Simple Database in MS Access
• Creating Table Relationship
• Manage the data in Tables
• Querying a Database using different types of queries (creating query, adding criteria to query, adding calculated field to a query, select query, append query, update query etc.)
• Designing Form (View data using Access Form, Create a Form Modify the design of a form)
• Generating Reports (View report in MS Access, Create a Report, Add a custom calculated field to a Report, Prepare a Report for Print etc.)
• Import and Export data in MS Access
• Working with Macro (Create a Macro, Attach a Macro, Automate Data Entry Using a Macro etc.)
• Advanced Queries in MS Access (Creating Sub queries, Summarize Data using a Cross tab Queries, Create a Pivot Table and Pivot Chart).