Microsoft Access and MySQL Lab Lab 3 A. Part 1: (60 Points) Yourasiganet B to aere an Access drabasefom!the FlanNowReal Estate lab from lab 2) Before you do this you will beed to put the ERD into relational form (actual boxes with field names, keys, and relations including Primary and Fareign Eeys) You will subenit your Access database file file-name accdb), and your document with screen shot! YoU MUST SUBMIT BOTH TO GET FULL 141 1 Create tables in Access for each of the tables from your relational diagram and then show the relations betneen the tables (you wil need to save a cogy froen the Access relation indov) Sare a screen shot of each table in Design View and paste in a Word or RTF ar compatible document Make sure to create the relationships batween the tables under the Database Tools tab, Relationskips You reed to bave a PK to FK relationship between the tables (see esample below. 2. Make sure to create a forma for at least 2 of the tables gou zy ase the wizad to accomplah this task. You mil need to sate a srear shor for eaca fonl to suit 3. Create the Sollowing queries from Access (once again the uizar makes this gremy simple: a. A query tor lats all real estace agents dhat hate sold orer Si AS hiyear (2010) so far > 10000 uthe Criteria rown the Query Deim Tier. b A ary hat sts curent clients and the curect ing pace for their propety-inchude client cames, address, phone mumber and zsiorg price 4. Froes these queries cresce the folloning ceporta i will nn them nter you apload the datubuse A epo" tutu om te genti nnce.canie mm ber me itocal to date s2las) sold iated by ptii ida