Saving our tables I:
Now that we've created the structure, we will learn how to Save our table properly.
We can do this from the Office button, with the option "Save" or by simply clicking on the "Save"icon you see in the image below.
After clicking on Save, we will be asked to add a name to the table. By default, we will get the name "Table1", but we can choose any name we want. .
Most likely, we will get this pop-up window asking if we want to add a "primary key". A primary key is a field created automatically and it functions as an "index". It is quite useful when managing several Tables.
In this basic Access course were not going to get into multiple Tables and their characteristics. These topics will be dealt with in more advanced courses.
Anyway, we will click on "Yes" in order to familiarize ourselves with the term.
This is the way our Table will look like with the primary key
We will learn more about Key in the following lesson.