Access Modules 5-8 SAM Capstone Project

IL_AC16_CS5-8a_LatriceReaves_1.accdb

Home >Information Systems homework help >Access Modules 5-8 SAM Capstone Project

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Latrice	Reaves	{459C93F4-2487-47E3-9DDB-2E43C7D06EBC}	{459C93F4-2487-47E3-9DDB-2E43C7D06EBC}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

AttendeeID	AttendeeFirstName	AttendeeLastName	Title	HomeAddress	HomeCity	HomeState	HomeZip	CellPhone	AttendeeEmail
1	Mindi	Pham	President	700 Wedd Street	Granger	IA	50011	5558889999
2	Mark	Pfeifer	VP	222 Oak Street	Des Moines	IA	50088	5558888888
3	Jordan	Pettus	Owner	333 Elm Avenue	Ames	IA	50010	5557777777
4	Jessica	O'Neill	Editor	444 Lincoln Way	Ft. Dodge	IA	50111	5558887777
5	Rachel	Oetting	Counselor	555 Perry Street	Osage	IA	50789	5558885555
6	Sherry	Saathoff	Owner	12345 100th Street	Fontanelle	IA	50846	5557778888
7	Arlo	Sanders	Accountant	12344 99th Street	Fontanelle	IA	50846	5557775555
8	Matthew	Skorija	Contractor	128 Main Street	Greenfield	IA	50847	5555557777
9	Jeffrey	Tung	Bookkeeper	789 Jackson Street	Greenfield	IA	50847	5555552222
10	Juan	Weinstein	President	600 Lenexa Road	Bridgewater	IA	50837	5554444444
11	Janet	Lightner	President	799 Millburn Road	Omaha	NE	59888	5552221111
12	Timothy	Tyler	Vice President	987 Simpson Avenue	Grant	NE	59777	5552221010
13	Forest	Roscoe	Editor	5757 Troost Ave	Arthur	NE	59666	5552223333
14	James	Abrams	President	8799 Wilberforce Road	Wayne	NE	59555	5552224444
15	Benjamin	Northey	Representative	100 Capitol Lane	Des Moines	IA	50033	5557767766
16	Matthew	Hardy	Business Analyst	12345 Pine Street	Niceville	IA	50505	5554447890	[email protected]#mailto:[email protected]#

CompanyID	CompanyName	Industry	WebSite
1	TRL Partners	Real Estate	www.trip2244.com#http://www.trip2244.com#
2	RM Construction	Construction	www.rmc2002.com#http://www.rmc2002.com#
3	Cold Fire	Safety	www.coldfire79.com#http://www.coldfire79.com#
4	McRoberts Law Firm	Legal	www.mcrob3000.com#http://www.mcrob3000.com#
5	Ridgedale Construction	Construction	www.ridgedalecon.com#http://www.ridgedalecon.com#
6	Aaron Construction	Construction	www.aaroncon82.com#http://www.aaroncon82.com#

EventID	EventName	Location	EventDate	AvailableSpaces
1	Estate Planning	Bismark Center	4/29/17	200
2	Planning a Simple Will	Community Center of Greenfield	4/30/17	50
3	Retirement Planning for the Self-Employed	Lang & Lang, Esq.	5/1/17	100
4	What Is a Roth IRA?	Bridgewater High School	5/2/17	150
5	Grow Rich Slowly	Mercy Auditorium	5/5/17	350
6	Planning for College	Greenfield High School	5/6/17	175
7	Live Debt Free	Wells Fargo Center	5/7/17	500
8	Living Off Grid	Destin Town Hall	6/1/17	200
9	Solar Power Solutions	Niceville Arena	6/2/17	250
10	Life Insurance 101	Omaha Community Hall	5/5/17	100

RegistrationID	AttendeeID	EventID	RegistrationDate	RegistrationFee
60	12	5	1/1/17	¤ 200.00
61	10	5	1/2/17	¤ 175.00
62	1	1	1/29/17	¤ 10.00
63	1	2	1/29/17	¤ 10.00
64	1	3	1/29/17	¤ 15.00
65	2	1	1/30/17	¤ 10.00
66	2	2	1/30/17	¤ 10.00
67	2	4	1/30/17	¤ 35.00
68	14	5	1/3/17	¤ 185.00
69	5	5	1/3/17	¤ 185.00
70	14	1	1/4/17	¤ 10.00
71	14	3	1/5/17	¤ 15.00
72	12	1	1/6/17	¤ 10.00
73	3	1	2/1/17	¤ 10.00
74	3	2	2/1/17	¤ 10.00
75	3	3	2/1/17	¤ 15.00
76	3	4	2/1/17	¤ 35.00
77	5	3	2/27/17	¤ 15.00
78	5	4	2/27/17	¤ 35.00
79	4	1	2/1/17	¤ 10.00
80	4	2	2/1/17	¤ 10.00
81	4	3	2/1/17	¤ 15.00
82	6	2	3/30/17	¤ 10.00
83	7	1	4/29/17	¤ 10.00
84	8	2	4/30/17	¤ 10.00
85	8	4	4/30/17	¤ 35.00
86	9	3	5/1/17	¤ 15.00
87	10	4	5/3/17	¤ 35.00
88	9	4	5/1/17	¤ 35.00

PARAMETERS __AttendeeID Value; SELECT DISTINCTROW * FROM [SELECT DISTINCTROW [Registration].[RegistrationID], [Registration].[RegistrationFee], [Events].[EventName], [Events].[StartDate], [Registration].[SalesTaxRate], [Sum Of Payments Query].[Total Payments], [Registration].[AttendeeID] FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON [Registration].[RegistrationID]=[Sum Of Payments Query].[RegistrationID]) ON [Events].[EventID]=[Registration].[EventID] ORDER BY [Registration].[RegistrationID]; ]. AS Attendees WHERE ([__AttendeeID] = AttendeeID);

SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];

PARAMETERS __EventID Value; SELECT DISTINCTROW * FROM [Fee Schedules] AS Events WHERE ([__EventID] = EventID);

PARAMETERS __EventID Value; SELECT DISTINCTROW * FROM [SELECT DISTINCTROW [Registration].[EventID], [Registration].[AttendeeID], [AttendeeLastName] & ", " & [AttendeeFirstName] AS [Attendee Name], [Attendees].[CompanyName], [Registration].[RegistrationFee], [Sum Of Payments Query].[Total Payments] FROM Attendees INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON [Registration].[RegistrationID]=[Sum Of Payments Query].[RegistrationID]) ON [Attendees].[AttendeeID]=[Registration].[AttendeeID] ORDER BY [AttendeeLastName] & ", " & [AttendeeFirstName]; ]. AS Events WHERE ([__EventID] = EventID);

SELECT DISTINCTROW Event Types.* FROM [Event Types] ORDER BY [Event Types].EventType;

SELECT DISTINCTROW Events.* FROM Events ORDER BY [Events].[EventName];

SELECT DISTINCTROW Payment Methods.* FROM [Payment Methods] ORDER BY [Payment Methods].[PaymentMethod];

SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];

SELECT DISTINCTROW [Events].[EventID], [Events].[EventName], [Events].[AvailableSpaces] FROM Events ORDER BY [Events].[EventName];

SELECT DISTINCTROW [Fee Schedules].[FeeScheduleID], [Fee Schedules].[FeeDescription], [Fee Schedules].[Fee] FROM [Fee Schedules] WHERE (([Fee Schedules].[EventID]=[forms]!Registration![EventID]));

SELECT DISTINCTROW * FROM Companies;

SELECT DISTINCTROW * FROM Events;

SELECT DISTINCTROW * FROM Attendees;

SELECT Attendees.AttendeeFirstName, Attendees.AttendeeLastName, Registration.RegistrationDate, Registration.RegistrationFee, Events.EventID, Events.EventName, Events.Location, Events.EventDate, Events.AvailableSpaces FROM Events INNER JOIN (Attendees INNER JOIN Registration ON Attendees.[AttendeeID] = Registration.[AttendeeID]) ON Events.[EventID] = Registration.[EventID];

SELECT [Events].[EventName], [Events].[EventDate], [Registration].[RegistrationFee], [Attendees].[AttendeeFirstName], [Attendees].[AttendeeLastName], [Events].[EventID] FROM Attendees INNER JOIN (Events INNER JOIN Registration ON [Events].[EventID] =[Registration].[EventID]) ON [Attendees].[AttendeeID] =[Registration].[AttendeeID];

SELECT DISTINCTROW * FROM Attendees;

SELECT Events.EventName, Registration.RegistrationFee FROM Events INNER JOIN Registration ON Events.EventID = Registration.EventID;

SELECT Events.EventID, Events.EventName, Events.Location, Events.EventDate, Events.AvailableSpaces FROM Events LEFT JOIN Registration ON Events.[EventID] = Registration.[EventID] WHERE (((Registration.EventID) Is Null));

SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;

SELECT Events.EventName, Attendees.AttendeeLastName, Attendees.AttendeeFirstName, Registration.RegistrationDate, Registration.RegistrationFee FROM Attendees INNER JOIN (Events INNER JOIN Registration ON Events.EventID = Registration.EventID) ON Attendees.AttendeeID = Registration.AttendeeID WHERE (((Registration.RegistrationDate)<#4/1/2017#) AND ((Registration.RegistrationFee)>100)) ORDER BY Events.EventName, Attendees.AttendeeLastName, Attendees.AttendeeFirstName;

SELECT Attendees.AttendeeFirstName, Attendees.AttendeeLastName, Registration.EventID, Registration.RegistrationFee FROM Attendees LEFT JOIN Registration ON Attendees.AttendeeID = Registration.AttendeeID WHERE (((Registration.EventID) Is Null));

SELECT Events.EventName, Registration.RegistrationDate, Registration.RegistrationFee, Attendees.AttendeeLastName FROM Attendees INNER JOIN (Events INNER JOIN Registration ON Events.EventID = Registration.EventID) ON Attendees.AttendeeID = Registration.AttendeeID WHERE (((Events.EventName)="Planning a Will")) OR (((Events.EventName)="Estate Planning")) ORDER BY Events.EventName, Registration.RegistrationDate DESC;

SELECT Attendees.AttendeeLastName, Registration.RegistrationDate, Events.EventName FROM Attendees INNER JOIN (Events INNER JOIN Registration ON Events.EventID = Registration.EventID) ON Attendees.AttendeeID = Registration.AttendeeID WHERE (((Registration.RegistrationDate) Between [Enter Start Date:] And [Enter End Date:])) ORDER BY Registration.RegistrationDate;

SELECT Events.EventName, Registration.RegistrationFee FROM Attendees INNER JOIN (Events INNER JOIN Registration ON Events.EventID = Registration.EventID) ON Attendees.AttendeeID = Registration.AttendeeID;

SELECT Attendees.HomeState, Events.EventName, Registration.RegistrationFee, Registration.RegistrationFee AS TotalFees FROM Attendees INNER JOIN (Events INNER JOIN Registration ON Events.EventID = Registration.EventID) ON Attendees.AttendeeID = Registration.AttendeeID;

SELECT TOP 3 Events.EventName, Sum(Registration.RegistrationFee) AS SumOfRegistrationFee, Count(Registration.RegistrationFee) AS CountOfRegistrationFee FROM Events INNER JOIN Registration ON Events.EventID = Registration.EventID GROUP BY Events.EventName ORDER BY Sum(Registration.RegistrationFee) DESC;