BIS 245 Week 5 Discussion

BIS 245 Week 5 Discussion | Devry University

Week 5: 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 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.