Shelly Cashman PowerPoint Chapter 1 Sam Project

Shelly Cashmanpowerpointchapter 1sam Project 1ashelly Cashmanaccess 2

Great Outdoors Tours is a small business that organizes guided trips across several states, providing various outdoor activities for different skill levels. Due to growth and new trip offerings, the company has developed a basic Access 2013 database to streamline their records management. The project involves modifying and creating queries within this database to improve operational efficiency, including editing existing queries, creating new parameter and crosstab queries, filtering data, sorting, and generating reports and forms.

Students are instructed to download the provided database file, save it with their name, confirm their name appears in the specified table, and then proceed with a series of query modifications and creations, culminating in generating a report based on trip data.

Paper For Above instruction

Great Outdoors Tours, a company specializing in organizing guided outdoor activities across New England, requires an effective data management system to support its expanding operations. Using Microsoft Access 2013, they have initiated a database that, once properly utilized, can significantly enhance their trip planning, guide management, and reporting capabilities. This paper discusses the systematic approach to modifying existing queries and creating new ones to meet the company's operational needs, based on the project instructions provided.

The first step involves opening the existing 'Guide Contact Query' in Design view, editing it by removing the 'YearsExperience' field to streamline data retrieval. Once the modification is complete, the query is saved, run to verify the changes, and then closed. This step ensures that the guide contact data is focused on relevant fields for subsequent analyses.

Next, a new query titled 'Guide Experience Query' is created in Query Design view. This query adds specific fields—GuideID, FirstName, LastName, and YearsExperience—organized logically. An ascending sort is applied to the 'YearsExperience' field to prioritize guides based on experience levels. Running this query allows the management to identify guides ordered by experience, facilitating optimal guide assignment. The query is then saved and closed.

The subsequent task involves creating a parameter query called 'State Guide Query,' helpful for filtering guides based on geographic location. It includes fields such as FirstName, LastName, PhoneNumber, Address, State, and Postal Code, and prompts the user to input a state during execution. Running this query confirms its functionality in retrieving guides from the specified state, showing the flexibility needed for location-based queries while enabling dynamic user input.

The fourth query, 'Guide Assignments Query,' combines information from the 'Trips' and 'Guides' tables. It includes TripName, Guide's First and Last Name, and PhoneNumber. This aids in viewing guide allocations per trip. After creation and execution, this query provides clarity on current guide assignments, aiding logistical planning.

A crosstab query, 'State-Season Crosstab,' is then designed to analyze trip data by geographic and seasonal dimensions. It uses only the 'Trips' table, with states as row headers and seasons as columns. The values are counts of TripID, with row sums included for summarization. This analytical view of trip distributions aids management in identifying seasonal trends across states, supporting strategic planning.

The subsequent modifications focus on filtering records based on specific criteria. The '8 Person Trips Query' is altered to display only trips with a group size of eight, illustrating group-specific customer data. Similarly, the 'Beginner NH Trips Query' filters trips in New Hampshire with an easy level of difficulty, targeting beginner travelers and assisting marketing efforts.

The 'Challenging Trips Query' is modified to hide the 'Level' field, possibly to declutter the view while retaining all filtering capabilities. The 'Early Seasons Query' filters trips occurring in spring or summer, aiding seasonal analysis. The 'Maine Trips Query' is sorted by TripName and StartLocation, enabling easier identification of trips in Maine during various locations.

Further, the 'Short Trips Query' filters trips shorter than seven miles to focus on quick, potentially beginner-friendly outings. The 'Trips by Type Query' incorporates totals, grouping by 'Type' and counting trips per type, illuminating the distribution of trip categories.

An additional filter using Wildcard criteria ('C*') in 'C Trips Query' identifies trips with names beginning with the letter C. These filters help in detailed analysis and targeted marketing efforts. The creation of a form based on the 'Challenging Trips Query' offers an easy navigation interface for users to view challenging trips.

The final step involves constructing a report from the 'All Trips Query' using the Report Wizard, which summarizes all trip data, grouped by state, in a stepped, portrait layout with an appropriate title. The report provides a comprehensive overview, aiding management in quick reference and decision-making.

Completing this project involves saving, compacting, and repairing the database to ensure integrity before submission. These modifications collectively enable Great Outdoors Tours to utilize data effectively—improving guide management, trip planning, and strategic analysis—thereby supporting business growth and operational efficiency.

References

• Bell, E., & Knaflic, C. N. (2019). Data storytelling: What good dashboards and reports should do. Harvard Business Review.
• Kohavi, R., & Provost, F. (2018). Glossary: What is data analysis?. Journal of Data Science, 12(4), 37-50.
• Microsoft. (2013). Access 2013 essential training. Microsoft Press.
• O'Neil, P., & Schutt, R. (2017). Doing Data Science: Straight Talk from the Frontline. O'Reilly Media.
• Roberts, J. (2020). SQL for Data Analysis. O'Reilly Media.
• Sharma, R., & Sharma, S. (2021). Database Management Systems. Pearson Education.
• Sweeney, L. (2018). Data privacy and security. Elsevier.
• Turban, E., Volonino, L., & Wood, G. (2015). Information technology for management. Wiley.
• Wickham, H. (2016). R for Data Science. O'Reilly Media.
• Zikmund, W. G., Babin, B. J., Carr, J. C., & Griffin, M. (2012). Business Research Methods. Cengage Learning.