Question
Using Access 1. Create a select query that lists all the Employees, who are DOB in March from any year, and then calculate their age
Using Access
1. Create a select query that lists all the Employees, who are DOB in March from any year, and then calculate their age in a new column. The set design must include only these fields EmployeeID, EmployeeFirstName, and EmployeeDOB.
2. Create a query to count the number of invoices whose quantity greater than $19. The set design must include only the field quantity from the table InvoiceLine.
3. Create a query that lists all customers ID whos CreditLimit between 48000 and 49800.
The set design must include only these fields: CustomerID, CreditLimit from the Customer table.
4. Create a select query that Calculates the Average EmployeeCommRate for females Employees. The set design must include only these fields: EmployeeCommRate, EmployeeGender.
5. Create a select query that Calculates in the new column the Amount for all Inventory after discount.
The set design must include only these fields: InventoryID, Quantity, UnitPrice, and Discount.
Step 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