1
2
3
4
5
6
7
8
9Chapter 18: Data Manipulation (Access) |
|---|
Youtube Video Overview:
Part 1Part 2Part 3 |
November 2018 Paper 2 -- New UpdateQuestion PaperZipped source filesVideo Tutorial: Part 1, Part 2 (Label)
March 2018 Paper 2Question PaperZipped source filesVideo TutorialJune 2018 Paper 2 (22)Question PaperZipped source filesVideo TutorialJune 2018 Paper 2 (21)Question PaperZipped source filesVideo Tutorial
|
1.1 - Football TaskCSV Files: Football (Right Click >> Save As)Football Mock Exam -- Complete the Mock Exam to test your level of understandingTask 1 - InstructionsVideo Tutorial: Part 1, Part 2Extension Task: InstructionsReport 1: Full VideoReport 2: Full VideoReport 3: Full VideoReport 4: Full VideoTask 2 - InstructionsVideo Tutorial: Part 1, Part 2, Part 3Extension Task: InstructionsTask 3 - Instructions (Summery Query)Video Tutorial: Full VideoExtension Task: InstructionsTask 4 - Instructions (Labels)Video Tutorial: Full VideoExtension Task: InstructionsBarcelona Logo, Spain Logo & Brazil Logo (File Save Target As)
|
1.2 Movie TaskCSV Files: Movie (Right Click >> Save As)Task 1 - InstructionsExtension Task: InstructionsTask 2 - InstructionsExtension Task: InstructionsTask 3 - InstructionsTask 4 - InstructionsVideo Tutorials:Importing CSVWild Card Query Search |
1.3 Updated Movie TaskMovie Database
Task 1: Query SearchesVideo TutorialTask 2: Movie Queries
Task 3: Report Exam QuestionsVideo Tutorial Task 1Video Tutorial Task 2Video Tutorial Task 3Task 4: Summery & label
|
1.4 Cars Relationship Task
CSV Files: Cars, Distributors (Right Click >> Save As)
Car Queries and ReportsLabels
Video Tutorials:1. Import & RelationshipQuestion 1 |
1.5 Books Relationship Task
CSV Files: Authors, BookTable, ShopsLesson 1 & 2Lesson 3 & 4Lesson 5 & 6, ExtensionVideo Tutorials:Part 1 |
1.6 Phones Task (Relationship Task)Task PowerpointCSV Files: Mobile_Phones (Right Click >> Save As)1.7 Computer Games (Relationship Task)Task PowerpointCSV Files: Games, Onlineshop, Publisher, (Right Click >> Save As)1.8 Football Task (Relationship Task)Task PowerpointCSV Files:Football Player, Clubs (Right Click >> Save As)
1.9 Gym Task (Relationship Task)Task PowerpointCSV Files:Branches, GymMembers, PersonalTrainer (Right Click >> Save As)
2.0 March 2018 (New Calculated Fields and Search Criteria)Task PowerpointDatabase
Database: Video Tutorial
|
Mistakes Lesson
Query Task Extension
Football Database
Task: Instructions
Video Tutorial
Video Tutorials:
1. Import CSV
2. Create Database Table & Import CSV
3. Create Relationship
4. Create Drop Down Menu
5. Data Entry Form (IGCSE Exam)
6. Data Entry Form (Books)
7. Query & Report
8. Labels (Include Field Names)
9. Labels (No Fields Names)
10. Summery Query
11. Extract to Word
Exam Technique - Blank
Exam Technique
Exam Questions Sequence
