Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems For Advanced Applications 18th International Conference Dasfaa 2013 Wuhan China April 22 25 2013 Proceedings Part 2 Lncs 7826

Authors: Weiyi Meng ,Ling Feng ,Stephane Bressan ,Werner Winiwarter ,Wei Song

2013th Edition

3642374492, 978-3642374494

More Books

Students also viewed these Databases questions

Question

c. What were the reasons for their move? Did they come voluntarily?

Answered: 1 week ago

Question

5. How do economic situations affect intergroup relations?

Answered: 1 week ago