Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking
Resolved · Medium Priority · Version 2003
Reply Thu 17 Jul 2008, 16:49Delegate Christine said...
Christine has attended:
Word Introduction course
Access Introduction course
Word Intermediate course
Linking
will probably need help with linking the databases to enable being able to pull off in excel spreadsheet, and entering new information as I would like to set up as a database anyone can use or update when necessary
For upcoming training course dates see: Pricing & availability
RE: linking Excel workbook in Access
Dear Christine
Thank you for attending Access and Word Courses. I hope you enjoyed the courses and are finding the topics covered during the training useful.
I believe in the training course we learnt how to link tables from one database to another. But you can easily link Excel workbook instead of a access table.
It would be a good way to get information from people who might not be confident in using Access. The good thing is that once you link the Excel file to Access you can make changes in Excel or Access and the data will always ib up-to-date in both applications.
All you have to do is following:
Step 1: On tables object choose New Button.
Step 2: Choose Link table and then press OK
Step 3: Choose the MS Excel from the File of types drop down list and also select the location of the file.
Step 4: when the wizard appears select the appropriate options and press finish.
Step 5: You
|