LAB PROJECT-4
 
The database table definition is as follows:
First Name,
Last Name,
Position,
Salary.
 
 
The data is as follows:
Sam Adams, President, $500,000,
Larry Smith, Senior Vice President, $240,000,
Patty Johnson, Vice President, $220,000,
Linda Jacobs, Assistant Vice President, $130,000,
Walter Anderson, Assistant Vice President, $130,000,
Brad Jones, General Manager, $135,000,
Betty Stone, General Manager, $135,000,
Carol Green, Assistant General Manager, $100,000,
Sam Taylor, Assistant General Manager, $100,000,
Kelly Moore, Manager, $85,000,
Steven Rozier, Manager, $85,000,
Liz Moorehouse, Assistant Manager, $60,000,
Kathy Applebee, Assistant Manager, $60,000,
Bud Atkinson, Office Manager, $50,000,
Sally Wise, Assistant, $40,000.
 
 
You are to set up the database table and enter the data (by creating and using an input form).  Then create a query that will display anyone who makes greater than $50,000 but less than $200,000.  Run a report (based on the query) that displays these people’s first name, last name, and salary (sorted in alphabetical order by last name).  Submit your database in the folder provided in the lab folder. Your database will have a table, a form, a query and a report that looks like a professional is going to review it.
DO NOT USE CHECK BOXES IN THE QUERY.
Think of a formula >50000 and <200000