Skills Developed/Reinforced from Unit 4 in this Activity:
General Database
- Building and managing a relational database
- Designing and customizing tables and fields
- Linking related tables using key fields
- Entering/edit table data
- Building and running queries
- Importing data from external sources
- Exporting data for analysis using other tools
Excel Analytics and Visualization
- Pivot Tables
- Pivot Charts
Instructions to complete the activity:
- Download and Review the detailed Case Study 3 ITHelpDesk instructions (PDF)
- Download and Review the associated Case Study 3 Slide Set of Instructions (PDF)
- Download these two sets of data for completing the described steps: Case Study 3 Help Desk-Starter.accdb and Locations.txt
- Complete the entire set of Case Study #3 activities as described in the detailed instructions. When you are done, upload all of the required artifacts to this assignment folder.
Leave a Reply
You must be logged in to post a comment.