Assignment Six

Assignment Six

Use Microsoft Access in the lab to do the following. Create a database containing four tables, three queries and one form. These objects are used to store and retrieve information for a video store. See Details Below:

Table Name Column Name Column Description Column Size Data Type

Customer custnbr unique id for each customer 2 character

lname customer's last name 12 character

fname customer's first name 6 character

city city in which customer lives 15 character

st state in which customer lives 2 character

Invoice invoicenbr unique id for each invoice integer

custnbr unique id for each customer 2 character

totalamount total amount for all movies rented currency

rentdate date of movie rental (julian format) integer

returndate date of movie return (julian format) integer

Movie movienumber unique id for each movie integer

title movie's title 20 character

type general category of film type 6 character

rating rating established for the movie 4 character

star name of film's main star 10 character

quantity number of copies of film owned by store integer

price original buying price of the movie currency

Invoicemovie invoicenbr unique id for each invoice integer

movienumber unique id for each movie integer

I will check your assignment in class

Table Name	Column Name	Column Description	Column Size	Data Type
Customer	custnbr	unique id for each customer	2	character
	lname	customer's last name	12	character
	fname	customer's first name	6	character
	city	city in which customer lives	15	character
	st	state in which customer lives	2	character

Invoice	invoicenbr	unique id for each invoice		integer
	custnbr	unique id for each customer	2	character
	totalamount	total amount for all movies rented		currency
	rentdate	date of movie rental (julian format)		integer
	returndate	date of movie return (julian format)		integer

Movie	movienumber	unique id for each movie		integer
	title	movie's title	20	character
	type	general category of film type	6	character
	rating	rating established for the movie	4	character
	star	name of film's main star	10	character
	quantity	number of copies of film owned by store		integer
	price	original buying price of the movie		currency

Invoicemovie	invoicenbr	unique id for each invoice		integer
	movienumber	unique id for each movie		integer