Question
Write query design in access. Please show the table design format. I want to see the details solution, how to write the formula. thank you
Write query design in access. Please show the table design format. I want to see the details solution, how to write the formula. thank you
QueryExp1: Create a new field in the query that shows the teacher's new salary, after a budget decrease. of 3% across the entire staff. To do this: Create a new field that reduces each teachers salary by 3%, and shows their new salary. Accomplish in 1 or 2 newly created fields, but name them appropriately. Display teacher's [last] name in alphabetical order. Apply appropriate formatting to all created fields. Only need to do one but I show two methods of getting there! In One Step: In Two Steps: QueryExp2: Create a new field called FTESal. Write an expression that takes the FTE % and multiplies it by the Salary. Display new values as Currency. Save your query. Show the [teaching route] and group by it. (2 groups) Count the number of records in each group, and average the new field. QueryExp3: Calculate the WORK age of each teacher (use hiredate, like birthdate). Display the teachers work age with no decimal places ( so round up) List the teachers [first] and [last] names, and oldest teacher, descending.1932 rows QueryExp4: Save the above query with a new name. (p 4 of Guide). Remove the teacher names fields and add their [school]. Also remove the sort from the Age field. Display the average age by school. Add [Salary] and display average salary as well. Show only the schools where the average workage of teachers is under 15. (remember you must save query before doing this.)Sort alphabetically by school name. 11 rows (Remember workage value is being rounded up) QueryExp5: Create the workage field, again, in a new query. Create a new field that displays only the YEAR that the teacher was hired (do not display Hiredate). Display only the teachers who were hired anytime in the 1980s or 1990s, by using criteria on this new field. Sort by Workage, Asc. 868 rows
ueryExp6: Write a query that displays how many teachers were hired [hire date] on which days of the week. Sort Descending by the full day of the week that had the most hires. QueryExp7: Write a query that Uses the DAY function to calculate the number of the day each teacher was hired[hiredate]. Now use criteria to display those who were hired between the 16th and 31st days of any month, any year. 973 rows. to accomplish this. Display as one field by grouping and counting. QueryExp8: Write a query that averages the salary for teachers that were hired [hiredate] during the Winter months (647 rows) (December, January, February, March). List the months as the full word, as mine displays. Count the teachers, and average the [salary] by each month. QueryExp9: Create a query that displays each month from the [hiredate] as a number. Use this new field to write criteria that excludes the months of 4 or 6 or 8.(1439 records)Create a Second field that displays the month as a 3 letter abbreviation. Create groups for each remaining month and count the number of records in each group.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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