microsoft access course

microsoft access course - Merge

Resolved · Low Priority · Version Standard

Merge

Paola has attended:
Access Introduction course

by - delegate Paola [1 post] (2007 May 2 Wed, 09:33) Reply

How is possible to merge databases?

Hi Best Training Support Forum Team,

I need to import data from Excel creating more tables and then I need to merge all of them. As a result I need to obtain one table with all the records (common or not) present in all the other tables. In all the table one field is common. In Excel I cannot do this.

Thanks a lot!

Paola

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Merge

by - trainer Richard platinum contributer [818 posts] (2007 May 3 Thu, 12:51) Reply

Hi Paola

It is possible to merge tables together through using action queries. You need to know how basic queries work, understand the structure of tables and also be familiar with ACTION QUERIES. This allows you to merge data together in a way that makes sense. You need to make sure that the fields you are mergeing together have the same properties, otherwise it will not work properly.

Access is far more complex than Excel, and it can be more powerful in some situations. Not always though, as your ability to determined by your experience and knowledge of Access.

Richard