Search for courses or lessons
Redeem a coupon
Start free trial
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
Go to the Data tab > Get Data > From Database > From Access Database > Browse to 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
What does the highlighted icon indicate in the following image?
That you can expand the column and automatically bring related records from other tables within the database into a new column
That you can merge that data your current table with the data in the other tables within the database
That you can link the column to related data found in other tables within the database and add the records using a VLOOKUP
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
Your data set is greater than 1,048,575 rows
The IT department has implemented a limit on your file size, forcing you to keep it under 5 MB
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement