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
|
|
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)
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.
- 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)
This video describes the advantages of a relational database program such as Microsoft 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:
- 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.
- Queries and Reports automatically show any new data as the report and query design is seperate to the data.
- To insert data in a table we can look it up in another table. This stops spelling errors.
- Using a primary key index stops us entering duplicate data by mistake.
- 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)
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.
- 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)
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.
- 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)
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.
- 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.