>

DJ Dates

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.

Binary Decoder Wheel

Moore's Law as Illustrated using Blowtorches and Calculators

A Window into the Hard Drive

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.

1.1. Calculating your GPA

2.1. Formatting Spreadsheets

3.1. Using Functions

3.2. Absolute and Mixed Cell References

4.1. Pie, Column & Line Charts

PowerPoint 2007/2010 (2007 unless otherwise noted)

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)

PowerPoint 2007 3.1. Animations and Timing
3.1. Animations and Timing (Alternate Link)

PowerPoint 2010 3.1. Animations and Timing

3.2. Adding Sound and Video
3.2. Adding Sound and Video (Alternate Link)

4.2. Charts and OLE
4.2. Charts and OLE (Alternate Link)

Comments (12) Trackbacks (1)
  1. Will you post alternate links for Access 2007 4.1 and greater? Office blocks YouTube.

  2. DJ
    You have a knack for explaing things simply. Will you be doing any new videos on Excel PowerPivot

    • 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.

  3. you are a guru. many many thx to u.

  4. 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

    • 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!

  5. 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

  6. 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

    • 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.

  7. 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!

  8. 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.


Leave a comment