Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
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
Don’t know
2
Beginner
What does the highlighted icon indicate in the following image?
That you can link the column to related data found in other tables within the database and add the records using a VLOOKUP
That you can merge that data your current table with the data in the other tables within the database
That you can expand the column and automatically bring related records from other tables within the database into a new column
Don’t know
3
Beginner
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?
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
All the fields you could ever need are pre-calculated in the database already, so no manipulation will ever be needed in the worksheet
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement