From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

✓ Solution: Create and manage a database

✓ Solution: Create and manage a database

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

✓ Solution: Create and manage a database

“

- [Instructor] Welcome to the solution video for the chapter two challenge. For this challenge, we use the 02 06 challenge database. I challenged you to complete all the tasks in five minutes or less. We have a lot to do so let's get started. Test number one in our challenge is to save the database as my 02 06 challenge in the chapter two folder. We'll go to file, save-as. It's always going to prompt you to save and close your objects. Make sure you're in the chapter two folder, type my in front of the document title, remove the one after the word challenge. On the mos exam, if you forget to name the file exactly as you're told, then you will have points taken off. So, pay close attention to the instructions. That's enable our content and we can mark number one as done. Test number two, create new tables from the 2016 commission worksheet in the sales commission Excel document, and the sales payroll worksheet, and the sales payroll Excel document. Accept all defaults. We're going to…

Contents