From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
✓ Solution: Build tables
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
✓ Solution: Build tables
- [Narrator] Welcome to the solution video for the Chapter three challenge. For this challenge, we use the 03_05 challenge data base, and I challenged you to complete all the tasks in under seven minutes. Let's go ahead and get started. Our first task is to save the 03_05 Challenge file as My 03_05 Challenge. Right back in the Chapter three folder, we'll go to File, Save As, and Save As. Make sure you're in the Chapter three folder. We'll type My in front of the document name with a space, get rid of the one after the word Challenge and click Save. We'll enable our content so we can continue working, and mark number one as done. Number two, create a new table by importing the products worksheet from the products Excel workbook, and create a link to the data source. Accept all defaults. Let's go to External Data in Excel. We do want a link to the data source, so make sure you choose that third radial button. Let's click Browse in the Chapter three folder. Here is our Products Workbook.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.