Create a query based on multiple tables. Open the Northwind database. Close the login form. On the Create tab, in the Queries group, click Query Design. Note, if youre using Access 2. Create tab, in the Other group, click Query Design. The Show Table dialog box opens. In the Show Table dialog box, double click Customers, Orders, and Order Details, and then click Close. All three tables appear in the query design workspace. In the Customers table, double click the City field to add it to the query design grid. In the query design grid, in the City column, in the Criteria row, type In Rio de Janeiro,So Paulo. This causes only those records where the customer is in one of these two cities to be included in the query. In the Order Details table, double click the Shipped. Date and the Unit. Price fields. The fields are added to the query design grid. In the Shipped. Date column in the query design grid, select the Field row. Replace Shipped. Date with Year FormatShipped. Date,yyyy. This creates a field alias, Year, that allows you to use just the year portion of the value in the Shipped. Date field. In the Unit. Price column in the query design grid, select the Field row. Replace Unit. Price with Sales Order Details. Unit. PriceQuantity Order Details. Jquery Video Popup Lightbox Free Download. Unit. PriceQuantityDiscount. This creates a field alias, Sales, that calculates the sales for each record. On the Design tab, in the Query Type group, click Crosstab. Northwind Sample Database Access 2007' title='Northwind Sample Database Access 2007' />Once a list of the sample templates is shown in the Access Backstage, click on the Northwind template to select it, optionally choose a path for the new. I use Access 2007 I have created an OLE field to store JPEG, so I can easily drag them into DATABASE. That works. Trouble is This field does not dispaly the JPEG but. I am now using windows 7 and Access 2007. But I would like to download the sample database Northwind for 2003. Can someone please advise where I can down. Learn how to use Microsoft Access 2010 relational database design and construction with samples and demos. Access Utilities Simil Fuzzy String Matching by Tom van Stiphout, VBA cc English, Dutch, French. Learn how to create a query in Access that uses multiple tables as its data source. Two new rows, Total and Crosstab, appear in the query design grid. In the City column in the query design grid, click the Crosstab row, and then click Row Heading. This makes city values appear as the row headings that is, the query returns one row for each city. In the Year column, click the Crosstab row, and then click Column Heading. This makes year values appear as the column headings that is, the query returns one column for each year. In the Sales column, click the Crosstab row, and then click Value. This makes sales values appear at the intersection of rows and column that is, the query returns one sales value for each combination of city and year. In the Sales column, click the Totals row, and then click Sum. This causes the query to sum the values in this column. You can leave the Totals row for the other two columns at the default value of Group By, because you want to see each value for these columns, not aggregate values. On the Design tab, in the Results group, click Run. You now have a query that returns the total sales by year in Rio de Janeiro and So Paulo.