From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
✓ Solution: Create and manage a database
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
✓ Solution: Create and manage a database
(upbeat music) - [Instructor] Welcome to the solution video for the Chapter 2 Challenge. For this challenge, we use the 02_05 challenge database and I challenged you to complete all the tasks in under seven minutes. Let's get started. First we'll save the database as my challenge in the Chapter 2 folder. We'll go to File and Save As, you'll get this message that you need to close all your objects before you can save it, and we'll say yes, Chapter 2 folder. You can call this whatever you'd like. I'm calling this My Challenge, and we do this just so you won't overwrite your original 02_05 Challenge file, just in case you want to try this again. Let's enable the content and move on to task number two. Create a One-to-Many relationship between the Sales Team table and the Commission table. We're going to enforce referential integrity so that if a record on the primary key side of the relationship is deleted Access will…
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.