The database is created for the purpose of storing the details of mobile and mobile accessories sales of a mobile store. The database contains three tables. The Customer table stores the details of the customers who have purchased products from the store. The Products table stores the details of the products sold by the store including product name, description, cost, inventory level etc. The Sales table stores details of the sale including the date on which the sale was made, quantity, price, total sale amount, etc. The database contains forms for adding additional records to all the tables. Also, there are several queries which provide various views of the data stored in the database, thus aiding the user to analyze the data and make future business decision and projections. Also, included in the database is a report which is based on one of the queries.
The following are the table names and their descriptions.
Customer Table – Contains customer details including CustID, FirstName, LastName, Address, City, Zip, and Phone.
Products Table – Contains product details including ProdID, Name, Description, Stock, and Price.
Sales Table - Contains sale details including OrderID, CustID, ProdID, OrderDate, Quantity, Price, and Amount.
The following are the forms used to insert data in the tables.
Customer Details Entry Form – Form to insert new records in the Customer Table.
New Product Entry Form – Form to insert new records in the Products Table.
Sales Entry Form – Form to insert new records in the Sales Table.
The following are the queries used to retrieve data used in decision making for the business.
Prod_Sales_April_Query – This query is used to display products that were sold in the month of April, and whose sale amount exceeded $200. It also gives the count of the products sold for that month.
Prod_Stock_Query - This query is used to display products whose stock is less than 5 and whose price is greater than $200.
Total_Average_Sales_Query - This query is used to display products and their sale count, total sale amount, and average sale amount.
Total_Sales_Monthwise_Query - This query is used to display month-wise sale of products. It displays the units sold and the total sale amount for each month.
The following report is based on Total_Average_Sales_Query query.
1.) Total_Average_Sales_Report – This report displays the data retrieved from the Total_Average_Sales_Query query and presents it in a report format.
