You will required use the data files for students
Part 1: You attend a college that is renowned for its school of arts and crafts. Students who major in arts and crafts can sell their designs online through the college bookstore. The bookstore has used an Excel workbook to store data on wood-crafted items as well as the students who created the items. Because you are a major in computer science and also are studying woodworking, your senior project is to create a database of these wood-crafted items. The database must keep track of the wood-crafted items for sale and maintain data on the students who created the items. Each item is created by a single student, but each student may have created several items.
Based on the information in the Craft Excel Workbook, use the concepts and techniques presented in Chapter 1 to design and create a database to store the craft data. Create a Wood Crafts for Sale report that lists the item number, description, price and student code. Submit your assignment online using the LMS platform. Note that it will be necessary to have separate tables in the database for students and craft items.
Part 3: Use the concepts and techniques presented in Chapter 2 to create queries for the following. Save each query.
a)Find the item number and description of all items that contain the word, Rack.
f)Create a form based on the query you created in Step e.
g)Determine the average price of items grouped by student code.