Snick's Board Shop is interested in more effectively managing their inventory. Casey and Caitlin would like you

Question:

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.