Access Analytics is a tool within Access Office Integration (AOI) that extracts data into Excel as a data table and pivot chart. It is in the Access tab in Excel where AOI is installed. To use it:
Click on the Access Analytics button in the Access tab of excel.
Select the required data connection and click Next to open the Output Selections screen.
Choose a Starting Cell by clicking the pop over button to the right of it and selecting a cell on the spreadsheet.
You can select cell A1, but normally it is preferable to choose one slightly in and down - for example B3.
Then Click on the pop over button once more and return to the Output Selections screen.
Use the boxes in the Selected column to choose the fields to return and click Next when ready (you can return to this screen if necessary).
Enter, amend or remove criteria using the Add, Update and Delete buttons. Using filters can drastically reduce the amount of data being returned, and speed the process up.
The Display button is typically used when revisiting a template having amended it so click Next to proceed.
Select the **Save Template** checkbox and add a **name** if required.
Show Data Sheets is a very useful option as it returns a sheet of the data in a separate tab to allow an overall review, and can be used to check for anomalies.
Click **Insert** to return the data.