Back to lesson
1. 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?
Go to the Data tab > Existing Connections > Select your database > Select the table or query you’d like to use
Open the Access database and export the table or query into an Excel file.
Go to the Data tab > From Access > Browse to your database > Select the table or query you’d like to use
2. 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?
Your data set is less than 1,048,575 rows.
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.
You can see the data first, and create new columns using formulas.
3. When connecting to a database, we have the option to “land” our data in either a table or directly into a PivotTable. What would force you to avoid landing your data in a table first?
The IT department has implemented a limit on your file size, forcing you to keep it under 5 MB.
All the fields you could ever need are pre-calculated in the database already, so no manipulation will ever be needed in the worksheet.
Your data set is greater than 1,048,575 rows.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement