Witty.ca - Mr. Rich's Professional Archives

  • Home
  • Courses
    • Course Listing & Updates
    • HCS Archive 2015-2016 >
      • HCS'15 Media Studies 120
      • HCS'15 Nutrition for Healthy Living 120
      • HCS'15 Visual Art 9
      • HCS'16 Intro to Electronics 110 >
        • Purchasing a Computer in 2016 >
          • HCS'15 Visual Art 110/120
      • HCS'16 Housing & Design 120
      • HCS'16 Visual Arts 10
      • HCS Winter Decoration Ideas
    • HCS Archive 2014-2015 >
      • HCS'15 - Digital Production 12
      • HCS'15 - Graphic Art & Design 11
      • HCS'15 - Media Studies 12
      • HCS'15 - Visual Art 10
      • HCS'14 - BBT 10
      • HCS'14 - Info Tech 11/12
      • HCS'14 - Visual Art 9
      • HCS'14 - Visual Art 11/12
      • HCS Art Club
      • HCS Announcement Text
    • HCS Archive 2013-2014 >
      • HCS'14 - English 12
      • HCS'14 - Graphic Design 11
      • HCS'14 - Individual & Family Dynamics 12
      • HCS'14 - Info Tech 12
      • HCS'14 - Social Studies 8
    • Student Introduction Form
  • Tech Units
    • Safety & Citizenship >
      • Work Place Safety
      • Digital Safety & Citizenship
      • Digital Communication
      • Digital Rights & Responsibilities
      • Digital Etiquette
      • Digital Wellness
      • Digital Business
      • Digital Access
      • Digital Literacy
      • Digital Law
    • Audio / Video >
      • Sound (Audacity)
      • Video (One Minute PSA)
      • Make a Movie Trailer
      • Blender Video Editor - Test
    • Automotive >
      • Auto - Careers
      • Auto - Engines
      • Auto - 4-Stroke vs 2-Stroke
    • Raster Graphics >
      • How to Submit - Raster Graphics
      • Photoshop Activities
      • GIMP Overview
      • GIMP Install & Setup
      • GIMP Activity 1
      • GIMP Activity 2
      • GIMP Activity 3
      • GIMP Activity 4a
      • GIMP Activity 4b
      • GIMP Activity 6a
      • GIMP Activity 6b
      • GIMP Activity 6c
      • GIMP Activity 6d
      • GIMP Activity 6e/f
      • RG Final Project - Magazine Cover >
        • HCS'16 Graphic Art & Design 110
      • RG Final Project - Cereal
      • RG Marking Breakdown
    • Vector Graphics >
      • Inkscape Act.1
      • Inkscape Act.2
      • Inkscape Act.3
      • Inkscape Act.4
      • Inkscape Act.5
      • Inkscape Act.6
      • Inkscape Challenge
    • Coding - Teacher Start
    • Python (Coding) >
      • Python - CS 110 PD - July 2016
      • Python - CS 110 PD Part 2 (Projects)
      • Python - CS 110 PD Part 3 (GUI)
      • Install Python 3.5 + PyGame
    • Scratch 2 (Coding) >
      • Scratch 2 - Introduction to Coding
      • Scratch 2 - How to
      • Scratch 2 - Introduction
      • Scratch 2 - Frogger (p1)
      • Scratch 2 - Frogger (p2)
      • Scratch 2 - Frogger (p3)
      • Scratch 2 - Frogger (p4)
      • Scratch 2 - Frogger (p5)
      • Scratch 2 - A 2nd Project
      • Scratch 2 - Teacher Notes
      • Scratch 2 - Choosing another language
    • Scratch 1 (Coding) >
      • Scratch (Scripts 1 & 2)
      • Scratch (Script 3)
      • Scratch (Frogger)
      • Scratch (Frogger 2)
      • Scratch (Frogger 3)
      • Scratch (Frogger 4)
      • Scratch Mini-Challenge 1
      • Scratch Final Project
      • Notes for Teachers >
        • Teaching Scratch
    • Design (AutoCAD) >
      • Design Act. 1
      • Design Act. 2
      • Design Act. 3
      • Design Act. 4
      • Design Act. 5
      • Design Act. 5b and 5c
      • Design Act. 6
      • Design Act. 7
      • Design Act. 8
      • Design Act. 9
      • Design Act. 10
      • Design Act. 11
      • Design Act. 12
    • Design (Sketchup) >
      • Sketchup House Setup
    • Portable Apps >
      • Cam Studio
      • Virtual Dub
      • Scratch (and Zip File for Students)
      • TuxPaint (and Zip File for Students)
      • TuxTyping (and Zip File for Students)
      • Google Chrome
    • Project Management >
      • Intro to Project Mgmt.
      • Assignment for Project Management
    • Database >
      • Tasks Database
    • Final Projects and Exam Review >
      • Final Project - BBT 10 - 2015
      • Final Project - Digital Production 2015
      • Final Project - Media Studies 2015
      • Exam Review 2013
    • Cybersecurity
  • Art Units
    • Elements and Principles >
      • Elements of Art
      • Principles of Design
    • Photographic Composition
    • Visual Art 9
    • Graphic Art & Design 110 >
      • Colour Theory
      • Layout
      • Fonts and Type
    • Visual Art 110
    • Previous Box Projects - Visual Art 10
  • Other Units
    • Housing >
      • How to Design a House
    • Media Studies >
      • Media Studies Handouts
      • What is media? Why study media?
      • Film, Television and Video
      • Advertising, Marketing and You
      • Media and the Internet
      • Self-Study Project
    • Nutrition >
      • Recipes >
        • Black Bean Cake and Cupcake
  • Sports
    • Volleyball >
      • NMS Volleyball 2019
      • Volleyball Contact
      • (Old) Volleyball 2017
      • (Old) Volleyball Spring 2016
      • (Old) 2016 Tournament - MS Boys Volleyball
      • (Old) Volleyball Spring 2015
      • (Old) 2015 Tournament - MS Boys Volleyball
    • Soccer >
      • (Old) Soccer Fall 2015
    • Basketball
  • Blogs
    • Computer Science Blog
    • Personal Blog
  • Contact
  • About
    • About Mr. Rich
    • About Technology and Computer Science
  • Archives
    • Teaching Software >
      • Purchasing a Computer (notes) >
        • Purchasing a Computer
        • Computer Scenarios
        • Computer Presentation
        • PAC Test Instructions
        • PAC Peer Review
        • How to Submit Computer Comparisons
        • How to Submit Computer for Helen
      • Scratch 2 (Coding)
      • Scratch 1.4 (Programming)
      • ARCHIVED - GIMP (Raster Graphics)
      • ARCHIVED - Inkscape (Vector Graphics)
      • AutoCAD (2D Design)
      • Sketchup (3D Design) >
        • Google Sketchup (2011)
        • Google Sketchup (2012)
      • Excel vs Calc (Spreadsheet)
      • Cam Studio (Screen Capture Videos)
      • TuxPaint (for young kids)
      • TuxTyping (Typing Tutor)
    • Links >
      • Career Links in Fredericton
      • Job Hunting Tips
    • Presentations >
      • Scratch Workshop Oct 11, 2013
      • Scratch Workshop Sept 18, 2013
      • Math for French Immersion
    • Software That Is No More >
      • Setup (for an older version of Weebly) >
        • Setup - Day 1
        • How To Setup Your Weebly Pages
        • Marks (link to Canvas)
        • Web Portfolio
    • Previous Teaching >
      • Old Teacher's Logs >
        • Teacher's Log 2015-2016
        • Teacher's Log 2014-2015
        • Teaching Notes - Hartland 2014
        • BBT9 Teacher's Log (Apr-June2013)
        • BBT9 Teacher's Log (Jan - Apr 2013)
        • BBT9 2012
      • Sept2010-Jan2012 >
        • Old Home
        • Middle School >
          • Literacy
          • Social Studies 6
          • Social Studies 7 >
            • Online Test - Canada at Confederation
      • Jan2012-Nov2012 >
        • Book Blog >
          • Blog to Book
        • About Mr Rich
    • PD Sessions >
      • BBT9-10 Oct6 2016
      • BBT Teachers PD (Jan 2013)
      • Cyber-bullying (May 2013)

Database (activities from S.R. Miles)

Many thanks to Scott Miles for originally posting these free resources on his site, DatabaseMentor.com. 
2020 Update - DatabaseMentor.com site no longer exists, but the videos are still on YouTube, under their author, Stuart Roger Miles (YouTube channels one and two).  Thankfully, the text from this free online resource was stored in Archive.org's "Wayback Machine", so ​we've been able to replicate and store this great resource here.
​

Your Choice:  This all-in-one page... or each series on it's own page with descriptions

Introduction to Databases (and MS Access)
  • Short intro document to Databases - by Scott R Miles (4-page PDF)
  • ​5 intro videos (see bottom of this page)

Here's Mr. Miles' full list of MS Access Database videos
  • TASKS Database (Beginner)
    • Tasks Part 1 - Create New Database
    • Tasks Part 2 - Access Lookup Table
    • Tasks Part 3 - Access Table Properties
    • Tasks Part 4 - Add Field to Table
    • Tasks Part 5 - Creating Query
    • Tasks Part 6 - Access Query Sort
    • Tasks Part 7 - Access Main Menu
    • Tasks Part 8 - Criteria in Query
    • Tasks Part 9 - Main Menu Buttons
    • Tasks Part 10 - Properties of Database
    • Tasks Part 11 - Report Wizard​
      ​
  • EXPENSES Database (Beginner 2)
    • Expenses Part 1 - Transaction Table
    • Expenses Part 2 - Lookup Table Example
    • Expenses Part 3 - Sum In Access Query
    • Expenses Part 4 - Between Query
    • Expenses Part 5 - Display Dialog Box
    • Expenses Part 6 - Forms Buttons
    • Expenses Part 7 - Access Form Button

  • MUSIC (CD's) Database (Beginner 3)
    • Music Part 1 - Create Access Table
    • Music Part 2 - Many Many Relationship
    • Music Part 3 - Database Referential Integrity
    • Music Part 4 - Auto Number In Access
    • Music Part 5 - Query Multiple Tables
    • Music Part 6 - Access Database Relationship
    • Music Part 7 - Add Data to Table
    • Music Part 8 - First Order Function
    • Music Part 9 - Dialog Box Query
    • Music Part 10 - Access Switchboard Form
    • Music Part 11 - Switchboard Automatic
    • Music Part 12 - Access Update Form
    • Music Part 13 - Editing Mode
    • Music Part 14 - Create Subform In Access
      ​
  • WEBSITE Database (Beginner 4)
         I started designing this database this week and its something that will be on going for at least the next few weeks. I have around 3 new websites that am designing and once they are up and working I need to do some marketing for them. This database will keep track of my video marketing, article marketing and social book marking.
         In the first video we create the website table and a tasks table which will list the tasks that I have to do for each website.
    • Website Part 1 - Access Marketing Database
    • Website Part 2 - Connect Tables
    • Website Part 3 - Database Many-to-Many Relationship
    • Website Part 4 - Add More Fields
    • Website Part 5 - Referential Integrity Access

​

  • SCHOOLS Database (Intermediate)
    • Schools Part 1 - Many To Many Database
    • Schools Part 2 - Database Create Table
    • Schools Part 3 - Relationship Integrity
    • Schools Part 4 - Add New Table
    • Schools Part 5 - Connect Fields
    • Schools Part 6 - Fields Required
    • Schools Part 7 - Add Data to Datatable
    • Schools Part 8 - Access Lookup Wizard
    • Schools Part 9 -  Sort Query
    • Schools Part 10 - Calculation Query
    • Schools Part 11 - Access Sum Query
    • Schools Part 12 - Sum Queries Continued
    • Schools Part 13 - How To Design Report
    • Schools Part 14 - Relationship Between Tables
    • Schools Part 15 - Access Report Design View
    • Schools Part 16 - Access Report Grouping
    • Schools Part 17 - Grouping and Sorting
    • Schools Part 18 - Database Form Wizard
    • Schools Part 19 - Form Wizard Add
    • Schools Part 20 - Form Drop Down
    • Schools Part 21 - Access Form Events
    • Schools Part 22 - Form Subform
    • Schools Part 23 - Subform in Access
    • Schools Part 24 - Access Form Wizard
Introduction to Databases (and MS Access)
  • Short intro document to Databases - by Scott R Miles (4-page PDF)
  • Video - Intro to MS Access Part 1 - ​​Linking Tables in Access 2007 (also embedded below)
  • Video - Intro to MS Access Part 2 - Access Database Relationship Advantages (also embedded below)
  • Video - Intro to MS Access Part 3 - Database Table Examples (also embedded below)
  • Video - Intro to MS Access Part 4 - Access 2002 Intro (also embedded below)
  • Video - Intro to MS Access Part 5 - Access 2007 Intro​ (also embedded below)

Introduction to Databases (and MS Access)
  • Video - Intro to MS Access Part 1 - ​​Linking Tables in Access 2007​
    From Scott R. Miles

These videos are an introduction to what a database can be used for and how it works. Look at following videos for step by step instructions and lots of examples.

In this video we use an example to show you what kind of data a database table usually holds and how we can link the tables of data together.

​I am using a school database as an example as we are all familiar with the topic. A school has students, classes, teachers, classrooms etc and these are the tables.


Introduction to Databases (and MS Access)
  • ​Video - Intro to MS Access Part 2 - Access Database Relationship Advantages​
    ​From Scott R. Miles

This video describes the advantages of a relational database program such as Microsoft Access:

  1. Each piece of information is only held once so, for example, if a student gets married and changes her name then we just change the last name field in the student table and all report and queries will show the new name automatically.
  2. Queries and Reports automatically show any new data as the report and query design is seperate to the data.
  3. To insert data in a table we can look it up in another table. This stops spelling errors.
  4. Using a primary key index stops us entering duplicate data by mistake.
  5. We can design the database to suit our needs and change it or add to it. We cannot do that if we buy “off the shelf” programs.
​

Introduction to Databases (and MS Access)
  • ​Video - Intro to MS Access Part 3 - Database Table Examples

Here I explain that a database can keep on expanding such as adding a bookshop to the school database.

I also show some other examples of database:

1. A DJ database which shows which songs are good for each type of party and which CD the track is on.

2. An expenses database for entering and reporting on money spent.

3. A tasks database or ‘to do’ list with categories, priorities and due dates.
​

Introduction to Databases (and MS Access)
  • Video - Intro to MS Access Part 4 - Access 2002 Intro

I’m using Access 2007 for my videos but Access 2002 is very similar. It is mostly just the layout of the buttons that is different – With Access 2002 you don’t get tabs.

When you open a table, query or form in 2002 it is opened in a new window and you don’t see the window where you can open new queries etc. With Access 2007 this is still available on the left hand side.

In this video we see how to create a new database, you see where the most common tools are and we see how to open tables queries forms and reports.
​

Introduction to Databases (and MS Access)
  • Video - Intro to MS Access Part 5 - Access 2007 Intro​

This introduction to Microsoft Access 2007 shows us how to create a new database. It then takes us on a tour around the functions and tools available in Access 2007 such as creating tables, queries, forms and reports and looking at the relationships window which shows us the relationship between tables in a database.
​


Copyright © Graham Rich 2010-2020.   Site made using Weebly.com.