Applying Data Management Concepts and Skills

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.

WRITE MY PAPER

Comments

Leave a Reply