The Database Story 1- Long Lasting Relationships

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | Lec: 17 | 960 MB

Genre: eLearning | Language: English

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