- Software Tool to be used: Microsoft Access
- KJ’s Disclaimer about MS Access and it’s Relevance in the workplace:
- Granted, few organizations use MS Access as it is more of an individual solution tool and easy to navigate BUT…..
- MS Access showcases data tables, table relationships and more importantly, the ability to create queries of the data selecting whatever fields and attaching criteria (AND-n-OR) to FILTER or SUMMARIZE massive amounts of data easily
- Remember a “Query is a Query” no matter what language it is written in including SQL (Structured Query Language)
- Additionally, MS Access allows you to create data entry/inquiry forms and reports too which are NOT required for this assignment.
-
Instructions
- ghadah alshakkakee (name to be used in some data fields that require name)
- Step 1: View the assignment Description document with step-by-step instructions:
- ISAN3380-HW1-BigData-Access Queries.pdf (file below)
- Step 2: Download the 2 starter files to your local device/folder (Recommend the Downloads Folder so you remember WHERE you put them)
- Starter Access Database: Foodmart4g.accdb (file below)
- YOUR Answer Sheet: ISAN3380-HW1-LnameFname.docx (file below)
- Follow the Assignment Instructions creating the queries, Saving Results as PDF’s and Answering the questions in your answer sheet
- Once completed, Save/Close ALL files
- Submit all of the required files (or as many as you are able to create) to this Assignment by the due date.
Submit the following 6 files to/for this Assignment HERE:
-
- File 1: HW1-LnameFname-Top10Products.pdf
- File 2: HW1-LnameFname-Top10Custs.pdf
- File 3: HW1-LnameFname-SalesByStore.pdf
- File 4: HW1-LnameFname.docx or doc
- File 5: HW1-LnameFname.xlsx
- File 6: HW1-Foodmart4g.accdb
