MS - Access

Objective

The objective of the program is to Design and develop database applications that enable you to organize and control the data in your work environment. Gain the skills to manipulate data, perform queries, develop forms, and design sophisticated data analysis reports.

• Overview of Database concepts, Fundamentals of database design
• Discovering the interface
• Planning a new database - keys and data types, creating Tables for a new database, saving, adding and navigating the data.
• Creating relationships for database - set Referential Integrity, lookup fields, Queries
• Creating Forms - types of Forms, change Forms in Layout view
• Table queries, Append, Delete and Update queries
• Creating various Reports
• Designing effective macros, event-driven programming
• Data separation in Access, linking to external data sources