Question: Using Microsoft Access please do the following ( Please show images) 1.Create a query that prompts you (the user) for your first/last name and produces

Using Microsoft Access please do the following ( Please show images)

1.Create a query that prompts you (the user) for your first/last name and produces your client number, your first and last names, the salary deduction along with the total premium. Also include a calculated field named Excess to subtract the total premium from your salary deduction. ( PLEASE SHOW STEPS)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Like many married couples, Morgan and Thomas Jensen are trying their best to save for two important investment objectives: (1) an education fund to put their two children through college; and (2) a...

Using Microsoft Excel, please do the following: Implementation Concerns Although you are free to work with the design of your worksheet, the worksheet should have a consistent, professional...

I am using Microsoft Access to solve the following queries. Please help me with step by step for Access Application: Please ensure that all your fields are formatted as needed and that columns are...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

QUESTIDN 1 (3n MAKES.) A. The following diagram shows a table structure for a Project Management data. _u _u _u Iaa- Iaa- m m - - REQUIRED: (a) Discuss TWO [2) types of anomalies exhibited in the...

Database Management System - Require use of Word, Powerpoint and Access C. After the presentation about the functionalities and advantages of using DBMS to manage customer information data in the...

12:15 AQ Case Study: City Jail Your company receives the following memo. First, based on the meme, create anitial database design (E-R model for the Cty Jail that indicates entities, attributes took...

Achieving Operational Excellence: Building a Relational Database for Operation. This database exercise assumes that before taking this course, you have learned how to develop a database using...

Achieving Operational Excellence: Building a Relational Database for Operation. This exercise requires that you know how to develop a database using Microsoft Access, and know how to create forms,...

Draw the shear and bending-moment diagrams for the beam AB, and determine the shear and bending moment (a) Just to the left of C, (b) Just to the right of C. B 400 mm 400 mm' 400 mm 1.2 kN

Repeat Problem 75 if the diet is to include exactly 400 units of calcium, 160 units of iron, and 240 units of vitamin A. Problem 75 A dietitian in a hospital is to arrange a special diet composed of...

Normal income is calculated as: Select one: a. Average professional income less current year professional income b. Taxable income less current year professional income c. None of the answers are...

Antelope Manufacturing makes a component called P30. This component is manufactured only when ordered by a customer, so Antelope keeps no inventory of P30. The list price is $115 per unit, but...