We'll stay in "Design View" for now. I'll tell you when you can switch views. ;-^) So that you will see how a relational database works, we're going to create two simple tables and then create a ...

How to create Tables with Table Designer in Access You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns.

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...