Yasar Ahmad website. Contact me on yahmad.nba@gmail.com
31 42 20131215_0737423 20131215_0737544 20131215_0738235 20131215_0738476 20131215_0740327 20131215_0758408 20131215_0758569
Chapter 18: Data Manipulation (Access)

March 2016 Paper 2

Question Paper

Zipped source files

 

Database: Video Tutorial

 

Nov 2016 Paper 2

Question Paper

Zipped source files

 

Database: Video Tutorial

 

Summer 2016 Paper 2 (21)

Question Paper

Zipped source files

 

Database: Video Tutorial

 

Summer 2016 Paper 2 (22)

Question Paper

Zipped source files

 

Database: Video Tutorial

 

 

1.1 - Football Task

 

CSV Files: Football (Right Click >> Save As)

 

Football Mock Exam -- Complete the Mock Exam to test your level of understanding

 

Task 1 - Instructions

 

Video Tutorial: Part 1, Part 2

Extension Task: Instructions

 

Report 1: Full Video

Report 2: Full Video

Report 3: Full Video

Report 4: Full Video

 

Task 2 - Instructions

 

Video Tutorial: Part 1, Part 2, Part 3

Extension Task: Instructions

 

Task 3 - Instructions (Summery Query)

 

Video Tutorial: Full Video

Extension Task: Instructions

 

Task 4 - Instructions (Labels)

 

Video Tutorial: Full Video

Extension Task: Instructions

 

Barcelona Logo, Spain Logo & Brazil Logo (File Save Target As)

 

 

1.2 Movie Task

 

CSV Files: Movie (Right Click >> Save As)

 

Task 1 - Instructions

Extension Task: Instructions

 

Task 2 - Instructions

Extension Task: Instructions

 

Task 3 - Instructions

Task 4 - Instructions

 

Video Tutorials:

Importing CSV

Wild Card Query Search

1.3 Updated Movie Task

 

Movie Database

 

Task 1: Query Searches

Video Tutorial

 

Task 2: Movie Queries

 

Task 3: Report Exam Questions

Video Tutorial Task 1

Video Tutorial Task 2

Video Tutorial Task 3

 

Task 4: Summery & label

 

 

1.4 Cars Relationship Task

 

CSV Files: Cars, Distributors (Right Click >> Save As)

 

Car Queries and Reports

Labels

 

Video Tutorials:

1. Import & Relationship

Question 1

1.5 Books Relationship Task

 

CSV Files: Authors, BookTable, Shops

 

Lesson 1 & 2

Lesson 3 & 4

Lesson 5 & 6, Extension

 

Video Tutorials:

Import CSV 1, 2, 3

Creating Relationship

Adding Records

Editing Records

Creating Input Form

1.6 Phones Task (Relationship Task)

 

Task Powerpoint

CSV Files: Mobile_Phones (Right Click >> Save As)

 

1.7 Computer Games (Relationship Task)

 

Task Powerpoint

CSV Files: Games, Onlineshop, Publisher, (Right Click >> Save As)

 

1.8 Football Task (Relationship Task)

 

Task Powerpoint

CSV Files:Football Player, Clubs (Right Click >> Save As)

 

1.9 Gym Task (Relationship Task)

 

Task Powerpoint

CSV Files:Branches, GymMembers, PersonalTrainer (Right Click >> Save As)

 

 

Mistakes Lesson

Files