The Database Story 1- Long Lasting Relationships
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
740 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Database Story 1- Long Lasting Relationships to your Wishlist.

Add to Wishlist

The Database Story 1- Long Lasting Relationships

Basic guide to master in Database concepts like data manipulation techniques and built-in Database functionalities.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
740 students enrolled
Created by GreyCampus Inc.
Last updated 2/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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)
  • Use Table Wizards
  • Understand the need to create relationships between tables
  • Explore different types of relationships
  • Conditions for setting up a relationship
  • Enforce Referential Integrity
View Curriculum
Requirements
  • Knowledge of database design terms would be an added advantage.
  • A basic knowledge on computer,internet and MS Excel
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
Who is the target audience?
  • This course helps you to refresh your Access Knowledge and also update your skills with the new Access Techniques
  • Very much advantageous to novice who would like to master in Access Database
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
03:04:29
+
Course Introduction
1 Lecture 03:34
+
Designing a Table, Rules for entering Field Names
1 Lecture 09:24
+
Enter data types, field descriptions
1 Lecture 32:42
Enter data types, field descriptions
32:42
+
Setting a Primary Key
1 Lecture 09:16
Setting a Primary Key
09:16
+
Removing a Primary Key
1 Lecture 03:05
Removing a Primary Key
03:05
+
Defining Field Properties (Default values, Input masks, Validation rules and tex
1 Lecture 10:55
Defining Field Properties (Default values, Input masks, Validation rules and tex
10:55
+
Insert, Delete, Move and Rename Fields
1 Lecture 08:07
Insert, Delete, Move and Rename Fields
08:07
+
Table Wizards
1 Lecture 04:21
Table Wizards
04:21
+
Managing Data in a Table
1 Lecture 12:24
Managing Data in a Table
12:24
+
Modify Table Data
1 Lecture 03:30
Modify Table Data
03:30
8 More Sections
About the Instructor
GreyCampus Inc.
4.0 Average rating
2,078 Reviews
26,015 Students
53 Courses
Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.