Shelly Cashman Access 365 | Module 2: End of Module Project 2 скачать в хорошем качестве

Shelly Cashman Access 365 | Module 2: End of Module Project 2

Please contact us if you need this project or any other projects in any subject to be completed. WhatsApp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 Shelly Cashman Access 365 | Module 2: End of Module Project 2 PROJECT STEPS 1. You are an information specialist at the alumni association for Dairy State Community College, which has its main office in Middleton, Wisconsin. You are using Access to answer questions about alumni, families, campuses, and staff for members of the association. Create a query for the Families table that includes the FamilyID, LastName, and State fields for all families. Apply criteria to select only records where LastName starts with the letter G and then save the query using GFamilies as the query name. 2. Open the WIAlumni query and find all alumni who have a DateOfBirth after 1/1/1995 and live in Wisconsin (WI) to list Wisconsin alumni born after January 1, 1995. Display the query results in the DateOfBirth field with the Medium Date format to spell out an abbreviated month name. 3. Create a crosstab query based on the Families table to group the average of income by county and level ID. Use the County field values for the row headings and the LevelID field values for the column headings. Calculate the average income and display row totals. Use Families_Crosstab (the default name) as the name of the query. Resize the columns in the query results to their best fit to display the entire field names and values. 4. Export the StaffListing query as an Excel file without formatting or layout to the same folder in which your database is stored. Use the default name for the exported file. Save the export steps, using Export-StaffListing (the default name) as the name. 5. Create a query based on the Families table that includes the FamilyID, LastName, County, and Income fields for all families in Dane county with an income greater than $100,000. Do not show the County field values in the query results. Save the query using DaneIncome as the name of the query. 6. Open the IncomeByLevel query. Add a total row to the query grid and calculate the average income grouped by level ID. Save the query. 7. Open the TopIncome query. Add the County field to the query grid immediately following the City field. Sort the records in descending order by Income. Display only the top 25% of the records in the query results to list only the families with the top 25% income. Save the query. 8. Create a query that joins the Campuses and Staff tables to list staff information by campus. Include the CampusName, FirstName, LastName, and Position fields in the query results. Sort the records in ascending order by CampusName and then by Position. Save the query using CampusStaff as the query name. 9. Create a report based on the StaffListing query. Select all the query fields for the report. Do not add any grouping levels and sort the records in ascending order based on the LastName field. Use a Tabular layout and a Landscape orientation. Save the report using StaffListing (the default name) as the name. Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.