Snick's Board Shop is interested in more effectively managing their inventory. Casey and Caitlin would like you to put together a database of their current inventory. Create a new database file using the information below. Name the file ch9-05_student_name (replacing student name with your name).

a. Use the information below to create and print a products table, a manufacturer table, and a category table as you did earlier in this chapter.

Category IDCategory Name
1 ........................... Complete
2 ................................ Ramp
3 ....................... Long boards
4 ................... Protective Gear
5 ................................ Rails
Manufacturer IDManufacturer Name
ALM ........................... Almost
EMT .......................... Element
GC ......................... Gold coast
MOJ .............................. Mojo
KRO .......................... Krooked
SC ......................... Santa Cruz
S9 ............................. Sector 9
888 ............................ Triple 8
0 ................................. Zero

b. Establish the appropriate relationship between each table and then print the relationships report.
c. Create and print a query using the Simple Query Wizard that lists Product Name, Category Name, and Manufacturer Name for all products sorted by Category Name from A to Z. (Save Query 1.)
d. Create and print a form using the Form Wizard for entering new products that lists all the available fields in the product table; use whatever style you'd like. (Save the form as Form 1, and print the first record only.)
e. Create and print a report using the Report Wizard with the fields Product ID, Style, Quantity, and Manufacturer Name for all products. The report should be viewed by Manufacturer sorted by Product ID in ascending order and be formatted in a Tabular layout with Portrait orientation and no grouping. (Save the report as Report 1.) All field information should be visible.

Table Category Manufacturer ManufacturerlD Field Name Data T CategorylD CategoryName ManufacturerName Productld ProductName CategorylD ManufacturerID Price Style Quantity Number Text Text Text Text Text Number Text Currency Text Number Product ProductID ProductName CategorylD ManufacturerID Price Style Quantit 109.99 Black 119.99 Silver 61-16758 61-23116 61-36447 65-00011 65-00335 65-00358 65-00981 65-01135 65-01400 65-01783 65-01786 65-01837 65-01967 65-01970 65-23174 Element Flat Bar Grind Rail Zero Switchblade Rail Zero 6 Foot Flat Bar Grind Rail Mojo Wedge Ramp Almost Mullen OC Impact V4 Element Section Almost Mullen Day Glow Macon Helmet Krooked Eyes Santa Cruz Landshark Santa Cruz Tiger Shark Element Launch Ramp Sector 9 Sand Wedge Goldcoast Venice Little Tricky Helmet EMT 10 99.99 Red 179.99 Black/Blue 119.99 Orange/Teal 89.99 Black/Red 119.99 Black/Yellow 2 MO ALM EMT ALM 10 10 10 10 4 59.99 White KRO SC SC EMT 89.99 Pink/Blue 99.99 Blue/White 129.99 Orange/Black 179,99 Black/Red 189.99 Black/White 149.99 Green/Yellow 10 10 10 3 GC 4 34.99 Black