Small Business Jewelry Store Access Database with Form and Reports

Create a database using Microsoft Access.

The database should contain three tables: Customers, Products, and Transactions; three queries: list of customers, transactions by customer, and transactions by product; and be something that a small business, such as a jewelry store or used car lot, can use for its daily needs.

The database must contain an input form for the transactions and one report that is based on any of the queries; the tables must each contain 10 records; and the records in the transactions table must be created by way of the input form.

In this assignment, use Microsoft Access to create the following: Forms Tables Queries Reports