MS Access 2003 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 2: MS Access Local & Linked Tables
Example: Creating computer_schools Table
The screenshot shows the Design View of table. This
GUI you will see after performing 4 steps mentioned under the article
‘Creating Local Tables’ earlier in this chapter.
1. The label 1 in the screenshot above shows the Field Name
column. Under this column write down all the fields or column names you
want for your table. Lets create a table with 5 columns or fields i.e.
id
name
address
state
done
2. Data Type column is the place where you select the Data Type
for each of your fields inside the table. In our case we have selected
AutoNumber data type for id field.
id as AutoNumber
name as Text
address as Memo
state as Text
done as Text
3. Each field in the table has ‘Field Properties’. The items
under Field Properties will change based on the Data Type you select for
your field.
4. The next you would like to do is to make the id field as
‘primary key’. This can be done by right clicking the id field and
selecting the ‘primary key’ option.
5. Save the table and assign the table a name e.g. computer_schools.
Chapter 2: MS Access Local & Linked Tables
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: