I don't have any more information. Whatever information I have can you help me with this? all I know it's about Microsoft access. Kindly help me with this problem.

1. In the Member table, find the record for MemberID 1251, and then change the Street value to 75 Hemlock Ln and the Phone to 303-553-1847.

2. In the Member table, find the record for MemberID 1228, and then delete the record. Close the Member table.

3. Create a query that lists members who did not have to pay a fee when they joined. In the query results, display the FirstName, LastName, and DateJoined fields from the Member table, and the PlanCost field from the Plan table. Sort the records in descending order by the date joined. Select records only for members whose fees were waived. (Hint: The FeeWaived field is a Yes/No field that should not appear in the query results.) Save the query as NoFees, and then run the query.

4. Use the NoFees query datasheet to update the Member table by changing the Last Name value for Kara Murray to Seaburg .

5. Use the NoFees query datasheet to display the total Plan Cost for the selected members. Save and close the query.

6. Create a query that lists the MemberID, FirstName, LastName, DateJoined, PlanDescription, and PlanCost fields for members who joined GoGopher! between April 1, 2016 and April 30, 2016. Save the query as AprilMembers, run the query, and then close it.

7. Create a query that lists all members who live in Louisville and whose memberships expire on or after 1/1/2017. Display the following fields from the Member table in the query results: MemberID, FirstName, LastName, Phone, and Expiration. (Hint: The City field values should not appear in the query results.) Sort the query results in ascending order by last name. Save the query as LouisvilleAndExpiration , run the query, and then close it.

8. Copy and paste the LouisvilleAndExpiration query to create a new query named

LouisvilleOrExpiration . Modify the new query so that it lists all members who live in Louisville or whose memberships expire on or after 1/1/2017. Display the City field values in the query results following the Phone field values, and sort the query results in ascending order by city (this should be the only sort in the query). Save and run the query.

9. Change the size of the font in the LouisvilleOrExpiration query datasheet to 14 points. Resize columns, as necessary, so that all field values and column headings are visible.

10. Create a query that calculates the lowest, highest, and average cost for all plans using the field names LowestCost, HighestCost, and AverageCost, respectively. Set the Caption property for each field to include a space between the two words in the field name. Run the query, resize all columns in the datasheet to their best fit, save the query as CostStatistics, and then close it.

Member

Member ID	Plan ID	First Name	Last Name	Street	City	State	Zip	Phone	Date Joined	Expiration Date
1200	311	Student First	Student Last	45 Lakeview Dr	Boulder	CO	80301	303-559-1238	11/1/2015	2/1/2016
1201	304	Denis	Davidson	286 Cheyenne Ave	Louisville	CO	80027	303-550-6119	11/15/2016	11/15/2017
1202	312	Bess	Hanson	103 Hubbard St	Boulder	CO	80305	303-236-6717	12/1/2015	3/1/2016
1205	312	Ava	Poirier	462 Rambler Rd	Boulder	CO	80302	303-559-5060	12/3/2015	3/3/2016
1207	304	Rick	Reynolds	320 Great Rd	Westminster	CO	80030	720-559-4642	12/20/2015	12/20/2016
1208	304	Kara	Murray	302 Pond Ln	Boulder	CO	80301	303-559-1651	1/9/2016	1/9/2017
1209	312	Lucy	Xiong	56 Tuckerman St	Boulder	CO	80302	303-323-0291	1/17/2016	4/17/2016
1210	312	Todd	Grant	6 Rosebriar Rd	Erie	CO	80516	303-674-2140	1/20/2016	4/20/2016
1211	308	Marg	Hadley	128 Follins Rd	Lafayette	CO	80026	303-550-6103	2/1/2016	8/1/2016
1214	302	Elizabeth	Griswold	350 Elm St	Jamestown	CO	80455	303-751-8772	2/1/2016	2/1/2017
1215	301	Keely	Ward	1294 Monument Ave	Boulder	CO	80305	303-674-8462	2/22/2016	2/22/2017
1216	305	Abella	Montaz	2200 Douglas St	Arvada	CO	80003	720-236-1794	2/25/2016	8/25/2016
1218	307	Maria	Turner	78 Flint St	Boulder	CO	80301	303-674-6807	3/1/2016	9/1/2016
1220	301	Federico	Medina	100 Hill Tower Dr	Boulder	CO	80302	303-559-5885	3/1/2016	3/1/2017
1221	312	Joseph	Albert	52 Fairway Dr	Boulder	CO	80305	303-550-3051	3/12/2016	6/12/2016
1223	310	Kurt	Fletcher	2 Wilber Ln	Boulder	CO	80302	303-236-8961	3/20/2016	6/20/2016
1224	310	Louisa	Sanchez	551 Harrington Ave	Boulder	CO	80304	303-674-5991	4/1/2016	7/1/2016
1225	308	Jamela	Picard	8 Calico Ct	Boulder	CO	80304	720-559-0909	4/1/2016	10/1/2016
1226	303	Maria	Duarte	74 Winter St	Boulder	CO	80304	303-550-0107	4/13/2016	4/13/2017
1228	308	Eric	Larsen	852 Winslow Rd	Boulder	CO	80302	303-553-1275	4/22/2016	10/22/2016
1230	305	Lisbeth	Sorrento	921 Prospect St	Erie	CO	80516	720-751-1270	4/25/2016	10/25/2016
1231	306	Marco	Krukonis	514 Collins Dr	Arvada	CO	80002	720-674-4333	5/5/2016	11/5/2016
1232	305	Marlene	Parker	64 Alderman Rd	Boulder	CO	80305	303-323-0346	5/20/2016	11/20/2016
1235	306	Jamal	Asmal	81 Barton St	Louisville	CO	80027	303-236-2194	5/28/2016	11/28/2016
1236	303	Rita	Smith	94 Newtown Ct	Boulder	CO	80301	720-751-0466	6/1/2016	6/1/2017
1237	310	Mary	Cunningham	742 Southbridge St	Boulder	CO	80305	303-550-7732	6/1/2016	9/1/2016
1239	303	Michael	DeCosta	163 Jeremiah Ave	Arvada	CO	80002	303-236-4121	6/3/2016	6/3/2017
1240	304	Mike	Nguyen	972 Turnpike Rd	Boulder	CO	80303	303-236-0325	6/14/2016	6/14/2017
1242	302	Olivia	Pedicini	58 Santos Rd	Boulder	CO	80302	303-236-0642	6/27/2016	6/27/2017
1245	309	Marla	Gonzalez	33 Pleasant St	Lafayette	CO	80026	303-236-6337	7/1/2016	10/1/2016
1246	306	Peter	Horovitz	7 Fort Union St	Louisville	CO	80027	303-553-1642	7/9/2016	1/9/2017
1247	307	Ramone	Reyes	456 Harris Ave	Boulder	CO	80301	303-559-1750	7/19/2016	1/19/2017
1249	307	Vincent	Tumbiolo	55 Johnson Blvd	Arvada	CO	80002	303-674-1434	8/1/2016	2/1/2017
1250	312	Min	Kim	66 Carver Rd	Boulder	CO	80302	303-550-1164	8/1/2016	11/1/2016
1251	302	Steven	Curran	13 Lincoln Rd	Louisville	CO	80027	303-674-0227	8/15/2016	8/15/2017
1254	312	Tomas	Vargas	111 Rocky Mountain Ave	Boulder	CO	80301	720-751-1119	8/18/2016	11/18/2016
1255	310	Amartya	Krishna	88 Green Blvd	Boulder	CO	80304	303-751-1847	9/5/2016	12/5/2016
1256	312	Tina	Louis	25 Putnam Rd	Jamestown	CO	80455	303-751-9111	9/12/2016	12/12/2016
1258	303	Kristi	Culberson	98 Lark Ln	Boulder	CO	80303	303-553-7986	9/20/2016	9/20/2017
1260	307	Arietta	Cimino	71 Beechwood St	Erie	CO	80516	303-550-9870	9/25/2016	3/25/2017