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?
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 > Get Data > From Database > From Access Database > Browse to your database > Select the table or query you’d like to use
Don’t know
2
Beginner
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 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
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?
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
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement