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

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

Answer 2

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

Answer 3

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

Answer 4

Don’t know

Answer 5

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

Answer 6

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 7

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

Answer 8

Don’t know

Answer 9

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 10

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

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?