join several database one

TrustPilot

starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Access Training and help » Join several database in one

Join several database in one

resolvedResolved · Urgent Priority · Version 2013

Sun 18 Aug 2019, 23:50 replyReply Delegate Moustafa said...

Moustafa has attended:
No courses

Join several database in one

hi
sorry for the inconvenience

I was wondering if you could help me to find out how I join and collect several database which are in same design and format but with different data in a new one to be able to make reports that contains all data for all the store's

thank you

For upcoming training course dates see: Pricing & availability

Mon 19 Aug 2019, 07:49 replyReply Trainer Jens said...

RE: join several database in one

Hi Moustafa,


You can merge two or more separate Microsoft Access database. By combining databases, you can build relationships, share information and access them together in one unified database. For example, if you have two copies of a database on separate machines, you can merge them and place them on a shared drive. This allows all users access to the most current information on the database. Alternatively, you can combine objects from two smaller databases to build a more complete database.

Step 1
Create a new database. Select the "External Data" tab of the ribbon to access the import options.

Step 2
Click "Access" under the "Import & Link" area of the ribbon to open the "Import Wizard." Locate the first Access database and import the tables, queries, forms, reports.

Step 3
Complete the "Import Wizard" again for the second database to import all of its objects into the current database. If you import objects with the same name, Access will add the number one onto the end of the title. If you have duplicate tables with different information, you will need to create an append query to copy records from one table to the other.

Step 4
Select the "Create" tab of the ribbon and click "Query Design" to create an append query. Select the source table from the "Show Table" window and drag each field to the field listing. Right-click the query and select "Query Type," then "Append Query," and select the destination table to complete the append query.

Tips & Warnings
Back up your databases in case an error occurs during the import process.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0845 5194 797
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector


 

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips


TrustPilot
TrustScore 4.9 / 5       1106 reviews