Access Project

SELECT [Industries].[Industry] FROM Industries ORDER BY [Industry];

PARAMETERS __JobSeekerID Value; SELECT DISTINCTROW * FROM Applications AS JobSeekerEntry WHERE ([__JobSeekerID] = JobSeekerID);

SELECT [Industries].[Industry] FROM Industries ORDER BY [Industry];

SELECT [Industries].[Industry] FROM Industries ORDER BY [Industry];

SELECT DISTINCTROW * FROM Companies;

SELECT DISTINCTROW * FROM Jobs;

SELECT DISTINCTROW * FROM Companies;

SELECT [Companies].[CompanyName], [Companies].[Industry], [Jobs].[JobID], [Jobs].[JobTitle], [Jobs].[StartingSalary], [Jobs].[Company], [Jobs].[PostingDate], [Companies].[CompanyID] FROM Companies INNER JOIN Jobs ON [Companies].[CompanyID] =[Jobs].[Company];

SELECT [Companies].[CompanyName], [Companies].[Industry], [Jobs].[JobID], [Jobs].[JobTitle], [Jobs].[StartingSalary], [Jobs].[Company], [Jobs].[PostingDate], [Companies].[CompanyID] FROM Companies INNER JOIN Jobs ON [Companies].[CompanyID] =[Jobs].[Company];

SELECT DISTINCTROW * FROM JobSeekers;

SELECT JobSeekers.JobSeekerID, JobSeekers.FirstName, JobSeekers.LastName, JobSeekers.Phone, Applications.ApplicationDate, Applications.JobID FROM JobSeekers INNER JOIN Applications ON JobSeekers.[JobSeekerID] = Applications.[JobSeekerID];

SELECT JobSeekers.LastName, JobSeekers.FirstName, Jobs.JobTitle, Jobs.StartingSalary, Jobs.Company, Jobs.PostingDate, Applications.ApplicationDate FROM JobSeekers INNER JOIN (Jobs INNER JOIN Applications ON Jobs.JobID = Applications.JobID) ON JobSeekers.JobSeekerID = Applications.JobSeekerID ORDER BY JobSeekers.LastName, JobSeekers.FirstName;

SELECT Companies.CompanyID, Companies.CompanyName, Companies.Industry, Companies.HRContactFirstName, Companies.HRContactLastName, Companies.HRContactPhone FROM Companies ORDER BY Companies.CompanyName;

SELECT JobSeekers.LastName, JobSeekers.FirstName, Jobs.JobTitle, Jobs.StartingSalary, Companies.CompanyName, Applications.ApplicationDate FROM JobSeekers INNER JOIN ((Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company) INNER JOIN Applications ON Jobs.JobID = Applications.JobID) ON JobSeekers.JobSeekerID = Applications.JobSeekerID WHERE (((Jobs.JobTitle) Like "*Director*") AND ((Applications.ApplicationDate)>=#9/1/2018#));

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 Companies.CompanyName, Companies.Industry, Jobs.JobTitle, Jobs.StartingSalary FROM Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company WHERE (((Jobs.StartingSalary)>=50000));

SELECT Companies.Industry, Companies.CompanyName, Jobs.StartingSalary FROM Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company;

SELECT Companies.CompanyName, Companies.Industry, Jobs.JobTitle, Jobs.StartingSalary FROM Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company WHERE (((Jobs.StartingSalary)>=50000));

SELECT JobSeekers.JobSeekerID, JobSeekers.FirstName, JobSeekers.LastName, JobSeekers.Phone FROM JobSeekers ORDER BY JobSeekers.LastName;