Providing you need to add data from an Access database to an existing Excel solution and pull it in to a PivotTable, how would you start the process?

Answer 1

Open the Access database and export the table or query into an Excel file.

Answer 2

Go to the Data tab > Existing Connections > Select your database > Select the table or query you’d like to use

Answer 3

Go to the Data tab > From Access > Browse to your database > Select the table or query you’d like to use

Answer 4

Don’t know

Answer 5

It must be landed to a table in order to refresh the data since you have to right click the source data table to refresh it.

Answer 6

You can see the data first, and create new columns using formulas.

Answer 7

Your data set is less than 1,048,575 rows.

Answer 8

Don’t know

Answer 9

Your data set is greater than 1,048,575 rows.

Answer 10

All the fields you could ever need are pre-calculated in the database already, so no manipulation will ever be needed in the worksheet.

Answer 11

The IT department has implemented a limit on your file size, forcing you to keep it under 5 MB.

Answer 12

Don’t know

When connecting to a database, we have the option to “land” our data in either a table or directly into a PivotTable. What reason would you want to land your data into a table first?