microsoft+access+training+course - how do you link
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training+course - How do you link tables

microsoft+access+training+course - How do you link tables

resolvedResolved · Low Priority · Version Standard

replyReply Tue 24 Apr 2007, 09:13Delegate Edmund said...

Edmund has attended:
Access Introduction course
Access Intermediate course

How do you link tables

see above

For upcoming training course dates see: Pricing & availability

replyReply Tue 24 Apr 2007, 13:22Trainer Tracy said...

RE: How do you link tables

Edmund,

You can link a table from another database or even an excel spreadsheet.

Use the following:

1. FILE > GET EXTERNAL DATA > LINK
2. Natigate to file
3. Specify table or query to link

Tracy

 

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard