Intro to Databases - Microsoft Access

The purpose of this video is to introduce Microsoft Access. Access is a database program and this slide here demonstrates how information is stored in a database. We've got separate fields-employer I.D., employer name, employer address and phone number and each line here is referred to as a record. Now you'll hear the term "relational database". In a relational database you've got multiple tables that share similar fields. For example, here's our employer table, which is also sharing a field with the position table.

So the same information that's being displayed here, employer I.D., is also being displayed down here in the position table. Now, this is a database that we'll be working with quite frequently and it's called seasonal.mdb. Let me go ahead and open the seasonal.mdb database here. So you can see this database has two tables, the employer table and then we've got a table of codes here in the back. All right, so we'll be working with, this employer table will be working with the seasonal database to sort of understand and get a feel for the foundational concepts that go into creating a database.