Integrity Training – Microsoft Office Access 2016 Intermediate
The Microsoft Office Access 2016: L2 course builds upon basic Microsoft Access skills acquired in Access Level 1 course to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage data and data entry, create forms and dialog boxes, split databases, and much more. The course focuses on the Access 2016 topics such as designing a relational database, joining tables, using data validation, creating advanced queries, organizing a database for efficiency and using advanced reporting techniques.
Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.
Course Curriculum
- Start
Course Introduction (2:05)
- Start
Courseware (0:15)
- Start
Instructor Introduction (1:02)
- Start
Designing a Relational Database (0:57)
- Start
Topic A: Relational Database Design (0:07)
- Start
Database Relationship (1:27)
- Start
Relational Database Design Process (1:17)
- Start
Statement of Purpose (0:34)
- Start
Existing Data (0:35)
- Start
Business Rules (0:40)
- Start
Primary Keys (1:13)
- Start
Primary and Foreign Keys (0:32)
- Start
Composite Keys (0:39)
- Start
One-to-One Relationships (1:15)
- Start
One-to-Many Relationships (0:41)
- Start
Relationships Window (0:30)
- Start
Guidelines for Designing Databases (1:43)
- Start
Demo – Exploring Table Relationships (3:39)
- Start
Topic B: Create a Table (0:07)
- Start
Table Views (1:21)
- Start
List of Data Types (1:07)
- Start
Calendar for Picking Dates (0:24)
- Start
Lookup Wizard (1:22)
- Start
The Table Properties Dialog Box (0:22)
- Start
Demo – Creating a Table (4:28)
- Start
Topic C: Create Table Relationships (0:11)
- Start
Edit Relationships Dialog Box (1:58)
- Start
Enforce Referential Integrity Options (0:54)
- Start
Join Lines (0:32)
- Start
Relationship Reports (0:21)
- Start
Guidelines for Enforcing Referential Integrity (0:48)
- Start
Demo – Creating a Table Relationship (4:01)
- Start
Chapter 01 Review (0:29)
- Start
Chapter 01 Quiz
- Start
Joining Tables (0:40)
- Start
Topic A: Create Query Joins (0:12)
- Start
Query Joins (1:25)
- Start
Inner Joins (0:43)
- Start
Left and Right Outer Joins (1:00)
- Start
Join Properties Dialog Box (0:24)
- Start
What the Join Options Return (1:12)
- Start
An Unrelated Table Join (0:56)
- Start
Demo – Creating Inner and Outer Joins (4:33)
- Start
Demo – Joining Unrelated Tables (3:14)
- Start
Topic B: Relate Data Within a Table (0:08)
- Start
Self Joins (1:18)
- Start
Demo – Creating a Self Join (2:47)
- Start
Topic C: Work with Subdatasheets (0:09)
- Start
Subdatasheets (0:58)
- Start
Demo – Modifying Data in a Subdatashee (3:24)
- Start
Chapter 02 Review (0:37)
- Start
Chapter 02 Quiz
Get Integrity Training – Microsoft Office Access 2016 Intermediate at tenco.pro
Reviews
There are no reviews yet.