This is Database Management's project.

profileShelby4
Beauty_Exampleformreport.accdb
Home>Computer Science homework help>This is Database Management's project.
MemberID OptionID FirstName LastName Street City State Zip Phone OptionBegin OptionEnd
2100 101 Elaine Diza 192 23rd St Orlando FL 32801 407-912-2234 11/5/17 12/5/17
2103 123 Student First Student Last 22 Oak St Orlando FL 32801 407-832-3944 2/1/17 3/1/17
2105 103 Sandra Garcia 217 Acorn Ridge Dr Orlando FL 32803 407-811-2134 1/15/17 7/15/17
2110 106 Amara Moreno 41 Balboa Dr Orlando FL 32801 786-733-7301 11/6/16 2/6/17
2115 123 Jackie Smith 412 Ashton Cir Orlando FL 32805 813-231-3001 2/4/17 3/4/17
2118 120 Susan Reyes 3 Balboa St Orlando FL 32804 407-216-0091 11/2/16 2/2/17
2120 135 Barbara Jackson 31 Terhune Ave Orlando FL 32830 321-417-9980 12/6/16 3/6/17
2123 142 Angella Delgado 2 Sangunta St Orlando FL 32829 407-333-3249 1/6/17 7/6/17
2126 111 Ariesa Romero 33 Baldwin Dr Celebration FL 34747 407-912-9230 12/20/16 12/20/17
2129 128 Angel Fernandez 19 Midori St Orlando FL 32809 954-840-9391 2/1/17 5/1/17
2132 131 Maita Rios 123 Baja Rd Orlando FL 32812 407-801-1240 3/3/17 9/3/17
2135 134 Oleda Valdez 12 Salerno Ct Orlando FL 32819 407-422-3901 1/12/17 2/12/17
2138 110 Lola Sanchez 82 Hockley Ct Orlando FL 32818 407-940-9401 1/15/17 7/15/17
2142 105 Nancy Smith 44 Hinson St Orlando FL 32808 954-844-4801 11/10/17 12/10/17
2145 120 Mirana Alvarado 32 Pack Cir Orlando FL 32801 407-543-9401 1/15/17 4/15/17
2148 143 Gilda Washington 111 Sailfish St Orlando FL 32804 407-921-2039 12/1/16 12/1/17
2151 141 Retha Ramirez 2 Bostic Cir Orlando FL 32805 786-349-0491 2/10/17 5/10/17
2154 131 Regia Vargas 65 Acadian Dr Orlando FL 32803 407-345-8501 4/1/17 7/1/17
2157 127 Priscilla Salazar 101 Rio Ln Orlando FL 32835 407-422-3049 3/1/17 4/1/17
2160 141 Gabriel Martinez 16 Ripley Ct Celebration FL 34747 407-917-4301 2/1/17 5/1/17
2163 128 Sandra Medina 844 Sanford Ln Orlando FL 32804 407-934-9021 1/15/17 4/15/17
2166 109 Linda Salinas 122 Bolcher Ave Orlando FL 32805 407-812-3048 1/12/17 4/12/17
2172 112 Allison Torres 42 Baker Rd Orlando FL 32803 407-436-9406 2/1/17 3/1/17
2175 136 Taylor Rivera 32 Sago Cir Orlando FL 32801 407-345-9604 11/2/16 5/2/17
2180 135 Risa Kaplan 122 Bolcher Ave Orlando FL 32805 212-858-4007 11/11/17 5/11/18
OptionID OptionDescription OptionCost FeeWaived
101 Manicure weekly for 1 month ¤ 125.00 false
102 Manicure weekly for 3 months ¤ 350.00 true
103 Manicure weekly for 6 months ¤ 650.00 true
104 Manicure weekly for 12 months ¤ 1,200.00 true
105 Manicure bi-weekly for 1 month ¤ 70.00 false
106 Manicure bi-weekly for 3 months ¤ 190.00 false
107 Manicure bi-weekly for 6 months ¤ 350.00 true
108 Manicure bi-weekly for 12 months ¤ 650.00 true
109 Manicure monthly for 3 months ¤ 140.00 false
110 Manicure monthly for 6 months ¤ 250.00 true
111 Manicure monthly for 12 months ¤ 450.00 true
112 Pedicure weekly for 1 month ¤ 125.00 false
113 Pedicure weekly for 3 months ¤ 350.00 true
114 Pedicure weekly for 6 months ¤ 650.00 true
115 Pedicure weekly for 12 months ¤ 1,200.00 true
116 Pedicure bi-weekly for 1 month ¤ 70.00 false
117 Pedicure bi-weekly for 3 months ¤ 190.00 false
118 Pedicure bi-weekly for 6 months ¤ 350.00 true
119 Pedicure bi-weekly for 12 months ¤ 650.00 true
120 Pedicure monthly for 3 months ¤ 140.00 false
121 Pedicure monthly for 6 months ¤ 250.00 true
122 Pedicure monthly for 12 months ¤ 450.00 true
123 Manicure/pedicure weekly for 1 month ¤ 250.00 false
124 Manicure/pedicure weekly for 3 months ¤ 700.00 true
125 Manicure/pedicure weekly for 6 months ¤ 1,300.00 true
126 Manicure/pedicure weekly for 12 months ¤ 2,300.00 true
127 Manicure/pedicure bi-weekly for 1 month ¤ 140.00 false
128 Manicure/pedicure bi-weekly for 3 months ¤ 380.00 false
129 Manicure/pedicure bi-weekly for 6 months ¤ 700.00 true
130 Manicure/pedicure bi-weekly for 12 months ¤ 1,200.00 true
131 Manicure/pedicure monthly for 3 months ¤ 250.00 false
132 Manicure/pedicure monthly for 6 months ¤ 500.00 true
133 Manicure/pedicure monthly for 12 months ¤ 800.00 true
134 Wash/cut bi-weekly for 1 month ¤ 100.00 false
135 Wash/cut bi-weekly for 3 months ¤ 275.00 false
136 Wash/cut bi-weekly for 6 months ¤ 500.00 true
137 Wash/cut bi-weekly for 12 months ¤ 900.00 true
138 Wash/cut monthly for 3 months ¤ 150.00 false
139 Wash/cut monthly for 6 months ¤ 300.00 true
140 Wash/cut monthly for 12 months ¤ 500.00 true
141 Wash/cut/color monthly for 3 months ¤ 300.00 false
142 Wash/cut/color monthly for 6 months ¤ 600.00 true
143 Wash/cut/color monthly for 12 months ¤ 1,100.00 true
PARAMETERS __OptionID Value; SELECT DISTINCTROW * FROM Member AS MembersByOption WHERE ([__OptionID] = OptionID);
SELECT DISTINCTROW * FROM Member;
SELECT DISTINCTROW * FROM Option;
SELECT DISTINCTROW * FROM Option;
SELECT [Option].[OptionID], [Option].[OptionDescription], [Option].[OptionCost], [Option].[FeeWaived], [Member].[MemberID], [Member].[FirstName], [Member].[LastName], [Member].[City], [Member].[Phone], [Member].[OptionBegin], [Member].[OptionEnd] FROM Option INNER JOIN Member ON [Option].[OptionID] =[Member].[OptionID];
SELECT DISTINCTROW * FROM Option;
SELECT Member.MemberID, Member.FirstName, Member.LastName, Member.Phone, Member.OptionEnd FROM Member WHERE (((Member.OptionEnd)>=#4/1/2017#) AND ((Member.City)="Celebration")) ORDER BY Member.LastName;
SELECT Member.MemberID, Member.FirstName, Member.LastName, Member.Phone, Member.City, Member.OptionEnd FROM Member WHERE (((Member.City)="Celebration")) OR (((Member.OptionEnd)>=#4/1/2017#)) ORDER BY Member.City;
SELECT Min(Option.OptionCost) AS LowestCost, Max(Option.OptionCost) AS HighestCost, Avg(Option.OptionCost) AS AverageCost FROM Option;
SELECT Member.Zip, Min(Option.OptionCost) AS LowestCost, Max(Option.OptionCost) AS HighestCost, Avg(Option.OptionCost) AS AverageCost FROM Option INNER JOIN Member ON Option.OptionID = Member.OptionID GROUP BY Member.Zip;
SELECT Member.MemberID, Member.FirstName, Member.LastName, Member.OptionBegin, Option.OptionDescription, Option.OptionCost FROM Option INNER JOIN Member ON Option.OptionID = Member.OptionID WHERE (((Member.OptionBegin) Between #1/1/2017# And #1/31/2017#));
SELECT Member.FirstName, Member.LastName, Member.OptionBegin, Option.OptionCost FROM Option INNER JOIN Member ON Option.OptionID = Member.OptionID WHERE (((Option.FeeWaived)=Yes)) ORDER BY Member.OptionBegin;
SELECT Option.[OptionID], Option.[OptionDescription], Option.[OptionCost] FROM Option;