Access Project
1.Pull up the starter file RealEstate.mdb from the course web page. Open the table in the database called Friends.
2.Add to the table Friends the following fields:
Birthdatethe data type should be date/Time
Childrenthe data type should be number
ZipCodethe data type should be text.
You should create a form using the wizard and you will need to enter at least 15-20 people of your choosing, with the first record being yourself.You should make up information if you do not know it.
3.Open the table Houses and add the following records:
ADDRESS / CITY / ST / ZIP / LAST / FIRST / PHONE / Price / Baths / Bed / List / Realtor1234 Seminole Road / Perkinston / MS / 39573 / Tant / Debbie / 333-666-7771 / 200000 / 3 / 4 / 07/12/2016 / FS
1717 Main Street / Gulfport / MS / 39573 / Your last
name / Your first
name / 555-555-5555 / 150000 / 2 / 4 / 09/22/2015 / FS
54545 Carol Lane / Bug Tussle / WA / 34344 / Fant / Ellie / 344-434-3433 / 180000 / 3 / 5 / 08/30/2016 / FS
4.Delete the record on the person Sarah Nadine.
5.Create a report (in columns) using the table Houses which is sorted by last name, then first name and looks as follows:Name the report Phone List.
6.Create a report (in label format ) using the table Houses which is sorted by zip code and looks as follows:
Name the report Mailing Labels.
7.Create a query using the wizard.
•Use the table Houses.
•Select the fields address, city, state, bedrooms, baths and price.
•Sort on price in ascending order.
•Select only the houses which are in the state of Lee and run the query.
•Save and name the query Lee.
8.Create a query using the wizard.
•Use the table Houses.
•Select the fields address, city, bedrooms, baths and price.
•Sort on city in ascending order.
•Select only the houses which have at least three bedrooms and two baths and run the query.
•Save and name the query 3bedrooms2baths.
9.Create a query using the wizard.
•Use the table Houses.
•Select the fields address, city, bedrooms, baths and price.
•Sort on price in ascending order.
•Select on the houses which are in the cities of Moo York and Slap out and run the query.
•Save and name the query MooYorkSlapout.
10.Create a query using the wizard.
•Use your table Friends.
•Select the fields: last name, first name, address, phone and birthdate.
•Sort on birthdate in ascending order.
•Select only the people with birthdays in the same month as your birthday and run the query.
•Save and name the query Birthdays.
11.Create a query using the wizard.
•Use the table Houses.
•Select the fields last name, first name, address, city, state, and phone.
•Sort on city in ascending order.
•Select only the people with the phone exchange of 444 and run the query. For example 444 in the following phone number is the exchange while 404 is the area code (404-444-5599).
•Save and name the query 444exchange.