From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
✓ Solution: Create and modify tables
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
✓ Solution: Create and modify tables
(upbeat music) - [Instructor] Welcome to the solution video for the chapter three challenge. For this challenge we used the 03 06 Challenge exercise file and I challenged you to complete all the tasks in seven minutes or less, let's get started. Task number one save the file as My Challenge in the chapter three folder. File, save as. My Challenge, and save. I'll enable content so we can keep on going. Number two import the 2019 Internet Orders table from the 03 06 Internet Orders database, accept all defaults. External data, new data source, from database, access. Let's browse to the chapter three folder, here's our database, click okay, here's our table, click okay, and close. Add the following description to the 2019 Internet Orders table, last import was two, one 2019. Here's a tip for you, on the exam you're allowed to copy paste in the task. You can then right click on Internet Orders go down to table…
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.