Build a simple TPS (Transaction Process System) using Access for a movie rental store.

1) To create a TPS in Access, you'll need at least the following tables:

-- Movies table: contains information for each movie in stock.

-- Customers table: contains information for each customer.

-- Orders table: contains one record for each sale (rental). Such record has only video ID, customer ID, and date of sale. A great example is the Order Details table in Northwind nwind2003.mdb, but your database for this assignment will be much simpler.

2) Create three data entry forms to efficiently capture customer information, capture movie information, and capture order information.

Enter at least 5 movies, 3 customers and 5 orders.