Each Topic is covered in depth with practical working on projects.

Topics Covered

Session 1 The Fundamentals - Objectives Describe the seven main Access 2003 objects Start Access and open a database Understand the Access Program Screen Add, Edit and Delete Records in Table View Add, Edit and Delete records in Forms Open and run a query Open and run a report Close down and exit Access Session 2 Creating and Working With A Database - Objectives Understand Primary Keys Understand data types Create a database Create a table Create a query Create a form Use the form wizard Create a report using the report wizard Session 3 Finding, filtering and formatting data - Objectives Find and replace information Sort records Filter records Adjust and re-arrange rows and columns Freeze fields Hide columns Session 4 Working with tables and fields - Objectives Understand field properties Index a field Change a field’s data type Apply formats to number and text fields Set default values and apply field validation Create input masks Create and modify lookup fields Create value lists Session 5 Creating Relational Databases - Objectives Understand table relationships Create relationships between tables Understand referential integrity Implement and test referential integrity Understand relationship types If anything is missed in above contents than that too would be covered without extra charge.

Who should attend

Anyone who use Excel or SQL

Pre-requisites

Basic understanding of Excel and Access.

What you need to bring

Your attention.

Key Takeaways

Great Knowledge with full Satisfaction.