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 1: Overview
7 Areas of Action
Once you run the MS Access 2003 software residing under
<Start> and <Programs> menu after installation, you will notice that the
software has seven objects or seven areas of operation. In other words
you can say that MS Access has the ability to do seven types of jobs.
Out of seven we would be discussing following six objects one by one.
These six important areas of action are as follows.
Tables
Queries
Reports
Macros
Modules
Forms
Once you click ‘Tables’ object under the Objects group as shown, the right pane of MS Access GUI will show you the list of tables in your database, both local and linked tables. The word GUI stands for Graphical User Interface. GUI is the software interface using which users can interact. It includes everything you see once the software is in front of you after running it though the <Start>, <Programs> menu. All the buttons, menu bar (File, Edit, View, Insert etc.), tool bar (all the icon/pictures under the menu bar) etc. you see on the software application and as shown in the screenshot above, are parts of MS Access GUI.
Tables
1. As depicted in the screenshot above, point 1 shows
the icon/picture of MS Access Local Table.
2. Whereas point 2 shows the icon/picture of MS Access Linked table.
Once you click the ‘Tables’ object under the Objects group then these
two types of tables would be visible, provided you have created before.
This is how we can easily differentiate between local and linked tables
in MS Access.
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.
Local Tables:
MS Access native tables where 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: