Microsoft Access 201
Intermediate Access 1
Creating relational databases,
relating customer and contacts table, relational combo boxes, much more.
AC201 Major Topics
- Relational Database
- Queries with Multiple
- Customer Combo Box
- Global Relationships
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