Videos
Computer Literacy
Links to videos on YouTube. See the Computer Literacy category for related blog posts.
From networks that block or slow access to YouTube, try the alternate link.
Moore's Law as Illustrated using Blowtorches and Calculators
Database Literacy: Why use a database? (Papercraft Version)
Database Literacy: Paper Data Models
Database Literacy: Why use a database?
Database Literacy: Why use a database? (Alternate Link)
Access 2007
Links to videos on YouTube. See the Access category for related blog posts.
From networks that block or slow access to YouTube, try the alternate link.
1.2. Tables and Relationships
1.2. Tables and Relationships (Alternate Link)1.3. Many to Many Relationships
1.3. Many to Many Relationships (Alternate Link)2.1. Importing Data
2.1. Importing Data (Alternate Link)2.2. Queries and Group By
2.2. Queries and Group By (Alternate Link)3.1. Forms and Subforms
3.1. Forms and Subforms (Alternate Link)4.1. Reports
4.1. Reports (Alternate Link)5.1. Many to Many Import
5.1. Many to Many Import (Alternate Link)5.2. Make Table and Append Queries
5.2. Make Table and Append Queries (Alternate Link)5.3. Delete Duplicate Records
5.3. Delete Duplicate Records (Alternate Link)5.4. Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Event
Excel 2007
Links to videos on YouTube with closed captions. See the Excel category for related blog posts.
From networks that block or slow access to YouTube, try the alternate link.
PowerPoint 2007
Links to videos on YouTube. See the PowerPoint Category for related blog posts.
From networks that block or slow access to YouTube, try the alternate link.
The first three videos start slow and are a little rough, being my first videos, so I would recommend skipping to Series 2 if you are already familiar with PowerPoint.
1.1. PowerPoint Basics
1.1. PowerPoint Basics (Alternate Link)1.2. Views and Printing
1.2. Views and Printing (Alternate Link)1.3. Text Boxes
1.3. Text Boxes (Alternate Link)2.1. Vector vs. Raster
2.1. Vector vs. Raster (Alternate Link)2.2. Art Objects and Effects
2.2. Art Objects and Effects (Alternate Link)2.3. Using Web Images
2.3. Using Web Images (Alternate Link)3.1. Animations and Timing
3.1. Animations and Timing (Alternate Link)3.2. Adding Sound and Video
3.2. Adding Sound and Video (Alternate Link)
September 27th, 2010 - 06:21
Will you post alternate links for Access 2007 4.1 and greater? Office blocks YouTube.
September 27th, 2010 - 07:05
Sure. I will have them posted in the next day or two. Another option for you is to copy and paste YouTube links into the URL section on http://www.zamzar.com and download the videos from there.
November 10th, 2010 - 18:43
DJ
You have a knack for explaing things simply. Will you be doing any new videos on Excel PowerPivot
November 10th, 2010 - 19:02
Thanks! It’s unlikely that I would do a video on something like PowerPivot unless I teach it in a class. My BI background is really in Oracle, but PowerPivot looks like a neat product … and anything that lets people use the tools they are already know is a plus for me.
June 26th, 2011 - 01:07
you are a guru. many many thx to u.
September 22nd, 2011 - 15:14
Even though i didn´t got exactly what i want or needed, i was wery impressed by your way of teaching.
you explain everything in such calm and slow way so everybody have time to recieve it and understand it.
Your woice is fantastic to compare with others that forgot half of the explanation and sometimes sound hysteric.
I really hope that you will continue to send (for my interest) Access relational tasks also more complicated ones.
Like:
I have a Refrigeration Service Company (2 men) and that company have customers and those customers have different locations
Those locations have different systems wich have different components.
THEN hm… maybe it is a good task to make a table for service jobs, hm.. How and where to connect that one in a relation.
Then:
who is doing the job, and when.
I really lack this kind of information.
I have read a lot of books but cant find books that stright on show how to build different a database for tasks.
And more: Im willing to pay you for some help. Though Im not rich
Anyway….. Thank you wery much.
Reguards // Dick Schweiger
Stockholm Sweden
September 24th, 2011 - 09:04
Thank you for your kind comments.
You probably aren’t going to find something that specifically applies to you, but you are already on the right track. Look at your written description. Each noun is an entity (table) and each verb is a relationship set. Customer has a Location. Location has a system. System has components. Employee services a system. Then figure out cardinality — is a relationship set one to one, one to many, many to many? Many customers have many locations. So customer is one table, location a second table, but the verb “have” is not just a single relationship, but a many to many relationship so it must include a junction table, such as a customer-location table with foreign keys and one to many relationships connecting to the primary keys in both the customer and location tables.
This is called Entity Relationship Modeling. Google “Entity Relationship Modeling” and you will find a number of pages on the topic. I would also recommend the Animated Database Courseware at http://adbc.kennesaw.edu/ which has examples that walk through this process.
I am afraid that teaching is keeping me really busy, so I am not able to help any further (or create a video on this topic any time soon.)
Best of luck!
October 5th, 2011 - 17:53
DJ,
you make stuff so simple, hat off for your efforts, ingenuity and above all spirit to spread knowledge.
More videos on Access would do great service for the society.
With many thanks
January 28th, 2012 - 11:33
hello sir how r u i hope you are fine i really like your videos and i learn a lot from it so thank you so much for that uploads if you don’t mind i request u to upload some videos in MCSE how you reaply me soon and again thank you so much
January 30th, 2012 - 06:57
Thank you for your kind comments. My background is really in Linux, Oracle, Apache, and PHP, so it would be unlikely that I would create any videos on Microsoft server products.
April 10th, 2012 - 22:18
Thank you for the amazing videos. I would be willing to purchase courses led by you as your videos are so thorough. Please let me know if you ever come up with something like this! MS Office Suite Advanced would be great. There is such a low availability of classes like these, but such high demand!
April 15th, 2012 - 16:11
After attempting to learn Access 2007 by using the Microsoft online course, and giving up due to its complexity, I stumbled onto your videos. Want to thank you for taking this subject and simplifying it. By just spending minutes watching these videos, you supply answers to questions that I’ve been pursuing for 18 months.
Your work is greatly appreciated.