microsoft access 2002 training

microsoft access 2002 training - Linked Databases

Resolved · Low Priority · Version Standard

Linked Databases

Samantha has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Samantha [8 posts] (2007 Dec 10 Mon, 14:59) Reply

I have linked a table from a (seperate) database (using a link). i want to run a query so i can get both tables to link up (using ID number). It is an 'Employee' table and i want to add the 'auditor status' from another database i thought i could get the two to work together. I have the two tables in one database but can't seem to join (link) them please can you help? Both tables can be opened from the same database but i can't connect them together

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Linked Databases

by - trainer Andrew platinum contributer [549 posts] (2007 Dec 14 Fri, 16:24) Reply

Hi Samantha

thank you for your question. Can I check regarding your data - from the table names it looks like the relationship between your fields would be that an employee would have one auditor status and that this status would be a form of category (that could be set to describe the audit status of that employee). Would that be correct?

Kind regards,

Andrew

RE: Linked Databases

by - delegate Samantha [8 posts] (2007 Dec 19 Wed, 10:16) Reply

Yes the auditor status whether 'active/ inactive etc' will only have one form of response,

· Get More Out of MS Access Courses
· When Is Microsoft Access Not The Best Choice For Your Business?
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Innovation with Microsoft Access
· Access VBA Handling Errors and Debugging Code

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Rate this page: