|
||||||||||||||||||||||
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.
|
||||||||||||||||||||||
| Access 201 Outline |
||||||||||||||||||||||
| 1. Introduction 2. Relational Database (RDB) Concepts Why are RDBs important One-to-one relationships One-to-many relationships Many-to-one relationships Many-to-many relationships Normalization 3. Relational Contacts Table Making our contact management relational Inserting a CustomerID in ContactT Removing duplicated fields What is a Foreign Key? 4. Contact Query Manually creating query relationships Deleting relationships String concatenation Dealing with duplicated fields Correcting our contact report Manual formatting of the phone field 5. Contact Form Constructing a contact form Using a combo box to pick the customer Manually editing combo box properties 6. Miscellaneous Add contact form button to main menu Global relationships between tables Creating and deleting links between fields 7. Review |
||||||||||||||||||||||
|
|
||||||||||||||||||||||
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
||||||||||||||||||||||
