Microsoft Access 201 Intermediate Access 1 Creating relational databases, relating customer and contacts table, relational combo boxes, much more. 68 Minutes.

This is the first of the Intermediate series of Access courses. We will begin by learning about relational database concepts - and why relational databases are more powerful than traditional "flat file" databases.

Next, we'll revisit the contacts table we constructed in the last class - this time, we'll build it properly and make it relational.

We'll then construct a query to relate the two tables together (customers and contacts).

We'll update our contact report to deal with the new changes in our database.

Next we'll build a contact form to display and edit this data. On this contact form, we'll create a combo box to allow us to select the customer from our list of customers. This way we don't have to know the customer's ID - we just pick them from the list.

We'll add the button for the new contact form onto our Main Menu.

Next, we'll take a look at Global Relationships between tables, why they're important, and why we're not going to use them... yet.

This is the big one! Don't miss this course. We cover a lot of very key concepts in this course - especially our discussion on relational database concepts, and learning how to create a combo box to look up a value from a different table. These are very important concepts, and we will build in them on most of our future Access courses.

Try a FREE Demo Lesson