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
Before Creating Tables
Database is composed of tables besides other stuff and each table is
composed of horizontal rows called records and vertical columns called
fields. Each field has been assigned a data type.
Data
types are assigned at the time of creation of table. It’s just a mean of
letting the database software know what type of data it would be
expecting in the particular field e.g. if your table contains DOB (Date
of Birth) field/column then you have to assign ‘Date’ data type to the
field. During the data entry operation or in other words while entering
information in the table you would not be allowed to enter ‘text’ in
this field. Same applies to ‘Number’ data type fields; you would not be
allowed to enter Date (e.g. 12/12/2006) in such fields.
In
the table shown below, Name & Capital are field names of table whereas
Finland and Helsinki is considered as the first record of the table.
So you should not be having any hesitation in saying that the table has
2 fields and 4 records.
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: