Basic guide to master in Database concepts like data manipulation techniques and built-in Database functionalities.

Microsoft Access comes with many built-in functionalities to perform data modeling tasks. This is a practical course that explores the easy solutions for database management and thus helps in increasing efficiency of business users.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

Designing a Table, Rules for entering Field Names
Enter data types, field descriptions
Managing a Primary Key
Defining Field Properties (Default values, Input masks, Validation rules and text)
Insert, Delete, Move and Rename Fields
Use Table Wizards
Manage / modify Data in a Table
Understand the need to create relationships between tables
Explore different types of relationships
Conditions for setting up a relationship
Enforce Referential Integrity