How to Combine Columns in Access

1. Open the database you want to update in Access.
2. Go to the Database window and choose 'Query' from 'Objects.' Then select 'Create query in using wizard.'
3. Click the 'Tables/Queries' drop-down in the wizard and select the first table containing the columns you need.
4. Select the fields (columns) you want to add. To add a single field, click the '>' button. To add all the fields, click the '>>' button.
5. Click the 'Tables/Queries' drop-down and choose the next table containing the columns you want to combine. Then follow step four to add the fields. To add additional columns from other tables, repeat this step and click 'Next.'
6. Type in a title for your query.
7. Choose the 'Open the query to view information' option and click on 'Finish.'