To be completed using Access 2016.
Need help with query and report form part
Class Project-Teddy Bears You are the owner of Veronica's Teddy Bear store. Create a new database called Teddy Bear Create a Products table and add at least 6 products into the table. Include such fields as Item description, cost, and Product ID. Set a validation rule on the cost field so that any value entered must be at least $15.00. The cost field should be formatted as Currency Create a Customers database and add at least 10 customers into the table. Include such fields as Customer ID, Name, Address, Phone. Make First Name and Last Name required fields Create an orders table. Include such fields as Order date, Date Shipped, Quantity, Customer ID, and ProductID. Set the data type of both the Customer and Product fields to number Establish the appropriate relationships between your tables. (Customer ID> Customer, Product ID > Product, etc.) Create a lookup-sield in your Orders table that looks up the Customer ID number from the Customer Table. Set the field to display the customer first and last name and to store the Customer ID field in the Customer field in the Orders table. Create another lookup field that looks up the Product ID field from the Products table. Set the field to display the Product name and store the Product ID field in the Product field in the Orders table. Enter at least 5 orders into your Orders table using a different customer for each order Create a multi-table query that displays a list of Customers and the Products they have ordered. Save the fields: Last Name, First Name, Product description, Quantity and Price. Make sure that even if a customer has not placed an order that they will display when you run the query query with the name "gryOrders". Include the following Create a Form and a Report based upon the gryOrders query. Include a calculated field both on the form and report that adds together the cost and the quantity Name the new field Total". Format the form and report so that they ate as eye appealing as possible. Save the form as "fimProducts" and the report as rptProducts" Class Project-Teddy Bears You are the owner of Veronica's Teddy Bear store. Create a new database called Teddy Bear Create a Products table and add at least 6 products into the table. Include such fields as Item description, cost, and Product ID. Set a validation rule on the cost field so that any value entered must be at least $15.00. The cost field should be formatted as Currency Create a Customers database and add at least 10 customers into the table. Include such fields as Customer ID, Name, Address, Phone. Make First Name and Last Name required fields Create an orders table. Include such fields as Order date, Date Shipped, Quantity, Customer ID, and ProductID. Set the data type of both the Customer and Product fields to number Establish the appropriate relationships between your tables. (Customer ID> Customer, Product ID > Product, etc.) Create a lookup-sield in your Orders table that looks up the Customer ID number from the Customer Table. Set the field to display the customer first and last name and to store the Customer ID field in the Customer field in the Orders table. Create another lookup field that looks up the Product ID field from the Products table. Set the field to display the Product name and store the Product ID field in the Product field in the Orders table. Enter at least 5 orders into your Orders table using a different customer for each order Create a multi-table query that displays a list of Customers and the Products they have ordered. Save the fields: Last Name, First Name, Product description, Quantity and Price. Make sure that even if a customer has not placed an order that they will display when you run the query query with the name "gryOrders". Include the following Create a Form and a Report based upon the gryOrders query. Include a calculated field both on the form and report that adds together the cost and the quantity Name the new field Total". Format the form and report so that they ate as eye appealing as possible. Save the form as "fimProducts" and the report as rptProducts
