Question
QBE Queries: Using Microsoft Access QBE, create and run new queries to answer the questions that follow. Save each query using the query name format
QBE Queries: Using Microsoft Access QBE, create and run new queries to answer the questions that follow. Save each query using the query name format QBEQuery-#, where the # sign is replaced by the letter of the question.
Who are the employees assigned to each project? Show ProjectID, ProjectName, Department (from the PROJECT table), EmployeeNumber, LastName, FirstName, and Phone. Create, run, and save this QBE query as QBEQuery-F.
Hint: QBE queries for questions G and H require more effort to produce the same results as the SQL queries.
Who are the employees assigned to each project? Show ProjectID, ProjectName, Department (from the PROJECT table), Department Phone, EmployeeNumber, LastName, FirstName, and Employee Phone. Sort by ProjectID, in ascending order. Create, run, and save this QBE query as QBEQuery-G. (continued on next page)
Who are the employees assigned to projects run by the marketing department? Show ProjectID, ProjectName, Department (from the PROJECT table), Department Phone, EmployeeNumber, LastName, FirstName, and Employee Phone. Sort by ProjectID, in ascending order. Create, run, and save this QBE query as QBEQuery-H.
PROJECT ProjectID Name Department MaxHours StartDate EndDate DEPARTMENT ASSIGNMENT DepartmentName BudgetCode OfficeNumber Phone ProjectID EmployeeNumber HoursWorked EMPLOYEE EmployeeNumber FirstName LastName Department Phone Email Edit Relationships Table/Query: Related Table/Query: OK PROJECT ASSIGNMENT Cancel ProjectID Project!D Join Type Create New Enforce Referential Integrity Cascade Update Related Fields Cascade Delete Related Records Relationship Type: One-To-ManyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started