Build a simple TPS (Transaction Process System) using Access for a movie rental store. 1) To create a TPS in Access, you
Posted: Mon Jun 06, 2022 6:51 am
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.
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.