1 / 15

Exam Review Project

Exam Review Project. Microsoft Access Exam: Football Statistics Problem. Exam Procedures. 10 minutes to review project before starting 60 minutes to complete the exam In this presentation, suggested timing guidelines are assigned to each step

tausiq
Download Presentation

Exam Review Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exam Review Project Microsoft Access Exam:Football Statistics Problem

  2. Exam Procedures • 10 minutes to review project before starting • 60 minutes to complete the exam • In this presentation, suggested timing guidelines are assigned to each step • Use these as a guide to indicate how far along in the project you should be at each step. • Consider practicing and re-doing steps for which you do not complete within the timing guideline.

  3. 10-Minute Exam Review Period • Read the Background Information and Project Statement sections of the instructions. • Look over the tables to get an idea of what kind of data is being used in this project. • The slides of this presentation will serve as a guideline to completing the project. • At the next slide, the clock starts and you will have 1 hour. The slides will automatically progress per the timing guidelines. Time: 10 minutes

  4. Step 1: Download XML Files • Access the XML files at the following URL:http://cs101.wvu.edu/resources/exam/review-projects/ • Exam review: Know what to do in downloading and know that if the contents are zipped, they must be extracted. Time: 2 minutes

  5. Step 2: Create an Access Database • Know how to launch Access and save a new blank database with the given name. Time: 2 minutes

  6. Step 3: Import XML Files • Know how to import XML files. • Be sure to verify the imported tables, opening them to be sure they imported correctly. Time: 2 minutes Points: 10 points

  7. Step 4: Create a New Table • Know how to create a table – two steps: • Part A is done in Design View. • Know how to set-up fields for different data types. • Part B is done in Datasheet View. • It is impossible to do Part B before Part A! • If you do setup a table incorrectly, the rest of your project will not work right. • Know how to troubleshoot common problems! Time: 5 minutes Points: 12.5 points total

  8. Step 6: Define Relationships • Know how to specify relationships • Drag between fields to create relationship lines • Instructions will indicate the tables of a relationship • Up to you to understand what fields are related! • Join fields of same data, usually of same name. • Problems here lead to trouble with your queries! Time: 4 minutes Points: 5 points total

  9. Step 7: Queries The queries will take the most time. Practice before the test. • Read over and select tables, fields. • Add Calculated Fields, using the Builder tool. Don’t forget about Aliasing. • Need a Totals Row? Look for keywords such as sum, average, number of. • Advanced features: Join Properties? Query-specific relationships? • Use the Criteria Row to restrict results by specifying criterion. Be able to use andandor criteria. • Format fields using the Property Sheet. May need to Run the query first. • Sort results using Sort Row. • Run the query to test. Time: 25 minutes Points: 7.5 points each

  10. Step 8: Form Wizard • Practice with the Form Wizard. • Most important part is to select the right fields from the right tables or queries. • Don’t forget to name both the Form and Sub-Forms, however. Time: 4 minutes Points: 7.5 points

  11. Step 9: Report Wizard • Don’t forget to name your report at the last step of the report wizard. • Read the Note in the Instructions: Use Layout View to modify the column widths so all fields are visible. • Know how to do this! (Don’t waste time if you are stuck.) Time: 3 minutes Points: 7.5 points

  12. Step 10: Analysis Questions • Standard table – two parts: • Design View first, Datasheet View second. • Answers go in datasheet view. • Use Memo data type for your responses. • Can also widen and stretch cells like in Excel for visibility. • Analysis questions are worth 20%! • If you’re running short on time, try to at least get these done since they’re worth a lot of points. Time: 10 minutes Points: 5 points each

  13. Step 11: Compact & Repair • Don’t forget this step! It appears after the analysis questions, and may be overlooked. • After Compact & Repair, the database will be saved (there is no notice that it completed). Time: 1 minute

  14. Submit your project • Finally, submit your files like any other project. • Close Access before submitting your project. • Be absolutely sure you do NOT submit the wrong file; i.e. with an L in the extension (*.*laccdb) • The correct file is one with a name such as filename.accdb Time: 2 minutes

More Related