Access 2003: Tables and Forms
Access 2003 uses relational databases, which allow you to link
information in multiple tables. This feature enables one specific
category of information to be stored in each table and avoids
repetitive data entry.
Importing Data into Tables
You can create databases from pre-existing spreadsheets and tables
by importing or linking existing data into Access. These methods
provide an efficient way to keep your data up to date.
Importing a table from an Excel spreadsheet
• From the File menu, select the Get External Data submenu.
• From the Get External Data submenu, select Import.
The Import window will appear.
Click on the down-facing arrow located next to the box labeled
Files of type.
From the drop down menu that appears, select Microsoft
From the list of files that appears, click on the Excel file that
contains the data you wish to import into Access.
Click on the button labeled Import.
Access will create a new table containing the data in the table
imported from Excel.
Inserting a linked table
A link is an action that establishes a connection to data from
another application so that you can view and edit the data in both
the original application and in Access. To link a table from a
separate Access file:
• Open up the Access file to which you wish to add a linked
table. If you are currently in the appropriate file, switch to the
• From the File menu, select Get External Data.
• From the Get External Data submenu, select Link Tables. . ..
The Link window will appear.
Confirm that Microsoft Office Access is selected in the box
labeled Files of type.
Click on the down-facing arrow located to the left of the box
labeled Look in.
o Select the drive and folder where the Access file you
wish to link is located.
o Double-click on the desired database’s icon.