98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course - Merge
microsoft access course - Merge
Resolved · Low Priority · Version Standard
Wed 2 May 2007, 09:33Delegate Paola said...
Paola has attended:
Access Introduction course
Merge
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
Thu 3 May 2007, 12:51Trainer Richard said...
RE: Merge
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
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. |
Access tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
