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 1: Overview
Tables
Once you expand the ‘Tables’ object under the “All Access Objects”
group, the list of tables will appear provided you already have created,
if not then you will see nothing.
1. As depicted in Figure 1-3 and Figure 1-4, point 1 shows the
icon/picture of MS Access Local Table.
2. Whereas point 2 shows the icon/picture of MS Access Linked table.
This is how we can easily differentiate between local and linked tables
in MS Access.
Figure 1-3: Link to another MS Access database table
is shown with table icon (point 2).
________________________________________
Figure 1-4: Links to Oracle tables are shown with the
globe icon.
________________________________________
In MS Access you can have pointers to the external
tables or in other words tables residing outside of MS Access database.
Such tables are called Linked Tables. You can use MS Access to create
tables too. Such tables are called MS Access Local Tables. Let’s make
this clear by rephrasing our words. There are two types of tables in MS
Access as mentioned below.
Linked Tables:
Pointers to tables outside of MS Access environment and their visibility
do require an ODBC link. The data in linked tables resides outside of MS
Access database.
Local Tables:
In MS Access local tables, data pertaining to the table and its
structure, both resides in MS Access database.
Chapter 1: Overview
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: