MS Access 2007 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_schools1 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.
Figure 2-5: Table Design View.
________________________________________
1. The label 1 in Figure 2-5 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 as shown in Figure 2-6.
Figure 2-6: Right-click on the field name in the table Design View to
exposes Primary Key command.
________________________________________
5. Save the table and assign the table any name e.g. computer_schools1.
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: