How to Create PivotTables in Microsoft Access on Windows 11

PivotTables are a great way to summarize, analyze, explore, and present data. Microsoft Access has a built-in tool to create PivotTables from your data. In this article, we’ll show you how to create PivotTables in Microsoft Access on Windows 11.

Creating a PivotTable

To create a PivotTable, follow these steps:

1. Open Microsoft Access and connect to your data.
2. Click the Create tab on the ribbon.
3. In the Reports group, click PivotTable.
4. In the Choose the data you want to analyze section, click Select a table or range.
5. Click the range of cells that contains your data, then click OK.
6. In the Choose where you want the PivotTable report to be placed section, click New Worksheet.
7. Click OK.

Your PivotTable will now be created in a new worksheet.

Adding Fields to the PivotTable

Once you’ve created your PivotTable, you’ll need to add fields to it in order to start analyzing your data. To add fields, follow these steps:

1. Click anywhere inside the PivotTable.
2. Click the Analyze tab on the ribbon.
3. Click Fields, Items, & Sets.
4. Click Add Fields.
5. In the Choose fields to add to report section, select the checkbox next to the field you want to add.
6. Click Add to Report.
7. Repeat steps 5-7 for each field you want to add.
8. When you’re finished adding fields, click Close.

Filtering Your Data

You can also filter your data in a PivotTable to only show the information you want to see. To filter your data, follow these steps:

1. Click anywhere inside the PivotTable.
2. Click the Analyze tab on the ribbon.
3. Click Fields, Items, & Sets.
4. Click Add Fields.
5. In the Choose fields to add to report section, select the checkbox next to the field you want to filter.
6. Click Add to Report.
7. Click the Filter icon next to the field you want to filter.
8. In the Filter dialog box, select the criteria you want to use to filter the field.
9. Click OK.

Sorting Your Data

You can also sort your data in a PivotTable. To sort your data, follow these steps:

1. Click anywhere inside the PivotTable.
2. Click the Analyze tab on the ribbon.
3. Click Sort.
4. In the Sort by drop-down, select the field you want to sort by.
5. In the Sort order drop-down, select Ascending or Descending.
6. Click OK.

Formatting Your PivotTable

You can also format your PivotTable to change the appearance of the data. To format your PivotTable, follow these steps:

1. Click anywhere inside the PivotTable.
2. Click the Design tab on the ribbon.
3. In the Style group, click PivotStyle.
4. Hover over the different styles to preview them.
5. Click the style you want to use.

You can also format individual cells or ranges of cells in your PivotTable. To format cells, follow these steps:

1. Select the cells you want to format.
2. Click the Home tab on the ribbon.
3. In the Font group, use the Font, Font Size, Font Color, and Bold, Italic, and Underline buttons to format the selected cells.
4. In the Alignment group, use the Align Left, Center, Align Right, Justify, and Orientation buttons to format the selected cells.
5. In the Number group, use the Number Format drop-down to format the selected cells as numbers, currency, percentages, etc.

Printing Your PivotTable

When you’re ready to print your PivotTable, follow these steps:

1. Click anywhere inside the PivotTable.
2. Click the File tab on the ribbon.
3. Click Print.
4. In the Settings section, select the Print checkbox.
5. In the Number of copies field, enter the number of copies you want to print.
6. Click Print.

In order to create a PivotTable in Microsoft Access on Windows 11, first open the program and select the “External Data” tab. Next, click on the “New Data Source” button and select the “SQL Server” option.

Enter the server name and choose the “Use Windows Authentication” option. Click on the “Next” button and select the database that you want to use. Click on the “Finish” button and then double-click on the table that you want to use for your PivotTable.

Click on the “PivotTable” button in the “External Data” tab and select the “PivotChart” option. Enter a name for your PivotChart and select the data that you want to use. Click on the “Finish” button.

Your PivotChart will now be created and you can begin to analyze your data.

To use the PivotTable feature in Microsoft Access:

1. Open the Microsoft Access database that contains the data you want to analyze.

2. Click the “Create” tab on the ribbon.

3. Click the “PivotTable” button in the “Tables” group.

4. Select the table or query containing the data you want to use in the PivotTable.

5. Click the “Add” button.

6. Click the “Finish” button.

Your PivotTable is now ready to use. To add fields to the PivotTable, drag and drop them from the “Field List” pane onto the appropriate area of the PivotTable.