Linking SQL Express 2005 Tables to MS Access 2007 - Creating an Access Database
(Page 3 of 5 )
Click on the Microsoft Office Icon in the MS Access 2007 program to open the next window. Some of the features of this new version of MS Access were described in an earlier tutorial, one of the key feature being the ribbon. In this window you can open an existing database, create a new one or otherwise manage an existing database.
Click on New... to open the window to create a Blank Database. This should appear on the right hand bottom portion of the main window as shown. You give a file name and it will be saved to the default location, which continues to be My Documents.
When you click on the Create button you will create the blank database. Now click on the External Data tab on the ribbon, which reveals a drop-down as shown in the next picture. Choose the first option, namely ODBC Database. Make a note of the other options that you can use for future reference.
Clicking on the first option above opens the next window, Get External Data - ODBC Database. This is where you begin to link the tables.
Next: Linking Tables >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
