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