Open the NewYorkDMV-03.accdb database start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor. Enable content in the database. Create a new summary query in Design view. The query counts the number of tickets issued by city and violation. Add the Tickets table into the Query Design window. Increase the size of the table object to display all of the fields. Add the following fields into the query: City, PrimaryFactor, and TicketNumber. Add the Total row to the query. Group By the City and PrimaryFactor fields and Count the TicketNumber field. Save the query as TicketCountByCityAndFactor. Run the query. The datasheet should display 22 records. Adjust the field column widths using AutoFit or Best Fit. The datasheet should be similar to Figure 3-104.Figure 3-104 Summary query results counting tickets by city and factor Save the changes to the query. Save a copy of the query as TicketCountByFactor. Edit the TicketCountByFactor query in Design view. The query should show the total tickets issued for each violation factor, sorted in descending order by count. Delete the City field. Sort the TicketNumber field in descending order. Save and run the query. The datasheet should match Figure 3-105.Figure 3-105 Summary query results counting tickets by factor Close the query. Create a new summary query in Design view. The query provides summary data on the total fines assessed against each driver. Add both tables into the Query Design window. Increase the size of the table objects to display all of the fields. Add the following fields into the query: LicenseNumber, FirstName, LastName, Fine, and TicketNumber. Add the Total row to the query. Group By the LicenseNumber, FirstName, and LastName fields, Sum the Fine field and Count the TicketNumber field. Sort the Fine field in descending order. Save the query as TicketsByDriver. Run the query. The datasheet should display 24 drivers who have received tickets, sorted in descending order by the total dollar amount of their fines (Figure 3-106).Figure 3-106 Summary query results of tickets by driver Close the query. Close the database https://www.mediafire.com/file/kaofoajjdm39efb/Mat...

Managers at each level of the organization use a type of SWOT analysis to identify strategies that will best position the company to achieve its mission and goals. The first step in a SWOT analysis is to identify an organization’s strengths and weaknesses that characterize the present state of the company. The next step requires managers to identify potential opportunities and threats in the environment that affect the organization in the present or possibly in the future. When the SWOT analysis is complete, managers begin developing strategies. These strategies should allow the company to attain its goals by taking advantage of opportunities, countering threats, building strengths, and correcting organizational weaknesses.Use the company and SWOT analysis you selected in Week 1 for this assignment.Congratulations! You’ve been hired as a manager and have been asked to analyze the current status of your new company.Review your company’s SWOT analysis and other available sources to evaluate the strategic needs of the organization within a changing global environment. Use the Wk 2 Apply Worksheet for your evaluation.Note: This type of information is often found in the company’s annual report.