Exam #2 Review Project

1. Exam #2Review Project Computer Science 101 West Virginia University

2. Exam Procedures 50 minutes to complete the exam

3. Step 1:Download & Extract Data • Access the data files at the following URL:http://cs101.wvu.edu/help/exam/exam-2/ • Know how to: • Download files • Extract contents of ZIP files

4. Step 2:Create a new Database • Know how to: • Start Microsoft Access • Create a new database

5. Points: 7.5 points Step 3 (7.5 POINTS):Import XML Files • Know how to: • Import structure and data from XML files

6. Steps 4A-b (10 POINTS TOTAL):Create new tables • Know how to: • Create new tables in Design View • Select appropriate data types • Select primary keys • Enter data into records

7. Step 5 (7.5 POINTS):Define Relationships • Know how to: • Create relationships involving single fields • Create relationships involving multiple fields • Require referential integrity • Apply cascade updates and cascade deletes

8. Steps 6A-E (7.5 POINTS EACH):Queries • Know how to: • Select tables to use in the query • Specify fields • Create and format calculated fields • Use aggregate (totals) functions • Sort • Specify criteria • Use SQL queries

9. Step 7 (7.5 POINTS):Form Wizard • Know how to: • Use the Form Wizard • Create forms with subforms

10. Step 8 (7.5 POINTS):Report Wizard • Know how to: • Use the Report Wizard • Group reports • Sort reports • Specify layouts • Resize report fields

11. Step 9A (2.5 points):analysis questions table • Know how to: • Create new tables in Design View • Select appropriate data types • Select primary keys

12. Steps 10A-e (5 points each):Analysis Questions Analysis questions are worth 20% of the grade! If you’re running short on time, try to at least get these done since they’re worth a lot of points.

13. Step 11:Compact & repair Database • Know how to: • Compact and Repair Database