The Database Story 1- Long Lasting Relationships

Udemy

Course Summary

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

+
Course Description
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

Course Description

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