Devry BIS245 Week 5 Discussion Latest 2021 July

BIS245 Database Essentials for Business With Labs

Week 5 Discussion

Creating Advanced Queries and Reports (graded)

Building from week 4 discussion, use Woodcraft Database for this discussion too and assume that Woodcraft is an online store that sells wooden craft kits to churches, scouting organizations, and other groups that need crafts for children. Download the Week 4 Woodcraft Database (Links to an external site.) and save Woodcraft's database to your computer or space in our Lab environment. View the content and structure of the database, and then answer the questions.

Using the Woodcraft database file, create some queries that use concepts found in the textbook, as well as this week's lab. Post a screenshot of your query design and result set in a Word document.

Create a sub query as learned in Chapter 6 and describe why you chose these attributes to query and post a screenshot of your query design.