Lesson 11

 

·        Create a database on your disk called "Law Offices of  [Your Name]

·        Create a table called "Clients" and enter the following records:

 

John	Smith	123 Main Street	Orlando	FL
Mickey	Mouse	1 Disney Plaza	Kissimmee	FL
Joe	Pluto	3200 Canine Way	Smyrna	GA
Minnie	Duck	200 N. Central	Compton	CA
Frank	Gifford	20 Rockefeller St	Newark	NJ

 

·        Create a table called "Billing" and enter the following records:

 

Smith	10.5	300	$ 3150.00	Pending
Mouse	8.0	300	2400.00	Pending
Pluto	12.0	300	3600.00	Granted
Duck	10	200	2000.00	Pending
Gifford	24	300	7200.00	Granted

 

REMEMBER TO CREATE APPROPRIATE FIELD NAMES FOR THE ABOVE FIELDS

 

·        Create a relationship between the Clients table and the Billing table based on a common field; do not enforce referential integrity.

·        Create a Query based on the Clients table that shows the Florida residents only.

·        Create a Query based on the Billing table that show which motions are pending.

·        Create a Report based on the “Pending Motions” Query; title your report appropriately.

·        Print all Queries above.

·        Print your Report; make sure your initials are by the title.