Integrity Training – Microsoft Office Access 2010 Intermediate
This very basic training course on Microsoft Windows 7 is part of the two course series on Microsoft Windows 7 operating system. The course gives an overview of the new features in Microsoft Windows 7 operating system and enables the students to navigate through Windows 7 interface by learning the basic concepts. This basic course is designed for inexperienced professionals who are beginning to use personal computers at their home, office or educational institute.
Microsoft Windows is the most widely used personal computer operating system in the world. Anyone who wants to use computers should have a little know-how of this operating system. This course develops the essential skills of navigation and usage of Windows 7 so that the beginners get the feel of the interface and the features it has to offer.
Course Curriculum
- Start
Course Introduction (1:00)
- Start
Instructor Introduction (0:37)
- Start
Relational Databases (0:19)
- Start
Topic A: Database Normalization (0:10)
- Start
Normalization (1:56)
- Start
Steps to Normalize: Rule 1 (2:08)
- Start
Steps to Normalize: Rule 2 (0:54)
- Start
Steps to Normalize: Rule 3 (2:36)
- Start
Demo A3: Using the Table Analyzer (4:01)
- Start
Demo A4: Identifying Object Dependencies (2:00)
- Start
Topic B: Table Relationships (0:07)
- Start
Establishing Relationships (1:00)
- Start
The Relationships Window (1:30)
- Start
Demo B1: Establishing a OnetoOne Table Relationship (2:14)
- Start
OnetoMany Relationship (0:56)
- Start
Demo B2: Establishing a OnetoMany Table Relationship (1:53)
- Start
Junction Tables (1:56)
- Start
ManytoMany with Junction (0:38)
- Start
Demo B3: Establishing a ManytoMany Table Relationship (2:06)
- Start
Printing Table Relationships (0:37)
- Start
Demo B4: Printing Table Relationships (0:55)
- Start
Topic C: Referential Integrity (0:07)
- Start
Referential Integrity (0:48)
- Start
Demo C1: Planning Table Relationships (1:10)
- Start
Orphan Records (0:51)
- Start
Demo C2: Working with Orphan Records (1:52)
- Start
Using Cascading Deletes (1:25)
- Start
Demo C3: Setting Cascading Deletes (0:58)
- Start
Testing Cascading Deletes (0:24)
- Start
Demo C4: Testing Cascading Deletes (0:57)
- Start
Cascading Updates (1:58)
- Start
Demo C5: Using Cascading Updates (1:25)
- Start
Unit 01 Review (0:15)
- Start
Unit 01 Quiz
- Start
Related Tables (0:21)
- Start
Topic A: Creating Look up Fields (0:07)
- Start
Lookup Field (0:47)
- Start
Creating a Lookup Field (1:28)
- Start
Demo A1: Creating a Lookup Field (4:54)
- Start
Multivalued Fields (0:58)
- Start
A Multivalued Lookup Column (0:29)
- Start
Demo A2: Creating a Multivalued Lookup Field (1:59)
- Start
Topic B: Modifying Look up Fields (0:05)
- Start
Display Column Headings (1:01)
- Start
Demo B1: Modifying Lookup Field Properties (1:40)
- Start
Types of Controls (0:45)
- Start
Using a Value List Combo Box (0:54)
- Start
Demo B2: Changing a Text Box to a Combo Box (1:52)
- Start
Topic C: Using Subdatasheets (0:06)
- Start
A Subdatasheet (1:10)
- Start
Inserting a Subdatasheet (0:32)
- Start
Demo C1: Using a Subdatasheet (2:37)
- Start
Unit 02 Review (0:25)
- Start
Unit 02 Quiz
Get Integrity Training – Microsoft Office Access 2010 Intermediate at tenco.pro
Reviews
There are no reviews yet.