I’m working on a excel multi-part question and need a sample draft to help me understand better.
Navigate to the Working with Data Tutorials using this link https://edu.gcfglobal.org/en/access/ (Links to an external site.). Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well. Do not submit the assignment until all files are attached. The documents you submit should look like the documents shown at the end of each Challenge.
- Working with Tables – Review the tutorial.
- Working with Forms – Submit 2 screenshots after completing Step 3 and Step 5. Paste both screenshots into a Word Document, Save as YourUsername_Forms and attach to assignment. (10 points)
- Sorting and Filtering Records – Submit screenshot after completing Challenge Step 5. Paste into Microsoft Word. Save as YourUsername_Sorting and attach to assignment. (10 points
- Navigate to the Database Design Tips Tutorials using this link https://edu.gcfglobal.org/en/access/ (Links to an external site.). Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well. Do not submit the assignment until the two files are attached. The documents you submit should look like the documents shown at the end of each Challenge.
- Modifying Tables – Save the Challenge! Practice Document as Username_Tables and attach to the assignment. (10 points)
- Creating Forms- Save the Challenge! Practice Document as Username_CreateForms and attach to the assignment. (10 points)
- Formatting Forms -Review the tutorial.
- Designing Your Own Database – Review the tutorial.
- Designing a Simple Query
- Designing a Multi-table Query
- More Query Design Options
- Creating Reports
- Advanced Report Options
- Information is correct and written in your own words – 75%
- Academic writing style with correct spelling, grammar, punctuation – 20%
- Outside sources – 5%
Navigate to the Running Queries and Reports Tutorials using this link https://edu.gcfglobal.org/en/access/ (Links to an external site.). Review each tutorial and then write a summary.
Write, in your own words, a one-two paragraph summary on the Running Queries and Reports tutorials. Apply critical thinking and an academic writing style that demonstrates your understanding of the difference between a Microsoft Access database and an Excel spreadsheet by comparing the features of each and when they would be used as personal computer applications if applicable.Scoring criteria