How do you create joins in Microsoft Access?

Answer 1

In the Access menu at the top, click on CREATE, then QUERY DESIGN. The SHOW TABLE box will appear and you can select 2 tables. For example, let's say you have a ORDERS table and a SALES REP table. Add both tables to the query design and click on CLOSE. Let's say the ORDERS table contains all the invoicing details such as product, product price, quantity, order number, order date, sales rep ID, etc. You need to create a report that summarizes sales by sales rep. In the query, we are going to choose TOTALS to indicate that this will be summary data and will add a calculated field (product price * quantity) that we summarize by selecting SUM in the TOTAL row. To get the Sales Rep name in the resulting query, we link the "sales rep ID" field in the ORDERS table to the "ID" field in the SALES REP table by drawing a link between the 2 linked fields. This now makes the sales rep name available to us in the query. We run the query and have our results. This summary query can now be used in a macro to export to Excel, as a basis for a inquiry, or as a basis for an Access report that can be displayed, exported to PDF, emailed to other users, etc.