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.