microsoft access training - Joining two databases

The UK's most regular instructor-led training courses.
Training information: microsoft access training · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Joining two databases

Junaid has attended:
Access Intermediate course
Access Advanced course

by - delegate Junaid [1 post] (2007 Jul 19 Thu, 09:50) Reply

How to join two different databases of MS Access?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	7	book now	£345	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Joining two databases

by - trainer Richard platinum contributer [785 posts] (2007 Jul 20 Fri, 10:19) Reply

Hi

When you say join, what do you want to achieve by doing this.

Do you want all the data to be in one database.
ie: same structures, different data

Or

do you want to take different objects from two databases and put them into one database?
ie: different structure, different data

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Tips for designing databases in Microsoft Access
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Innovation with Microsoft Access

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips