Assessment Task 3 PDF

Preview

Summary

assessment 3 for sports diploma...

Description

ASSESSMENT TASK 3 Microsoft Access – Player Database 1. Open Microsoft Access and create a table with the fields and data below. Add the name of your Fantasy Player and fill in their fields with imaginary data.

FirstName FantasyPlayer Charles Larry Clyde Patrick Magic Michael Scottie John

LastName Barkley Bird Drexler Ewing Johnson Jordan Pippen Stockton

Club

Age

Salary

Philadelphia 76ers Boston Celtics Portland Trail Blazers New York Knicks LA Lakers Chicago Bulls Chicago Bulls Utah Jazz

29 35 30 29 32 29 26 30

$3,200,000 $7,070,000 $1,387,000 $3,139,000 $2,500,000 $3,250,000 $2,770,000 $2,100,000

2. Create a Query with the records ‘First Name’, ‘Last Name’, ‘Age’ and ‘Salary’. If you are unsure how to run a query this video may help. https://www.youtube.com/watch?v=n2LWqnN-yCY 3. Sort by ‘First Name’ ascending order. 4. For ‘Age’ set the criteria as greater (>) than 28. 5. For ‘Salary’ set the criteria as less (...