Build Your Skill Resources focus primarily on Microsoft Access tables, forms, queries and reports. There are resources suitable for students with no prior knowledge of databases where they can practice creating and amending tables and filter specific information.
There are also more complex tasks for those working at an advanced level including aggregate functions and calculations in queries, forms and reports.
Unfortunately, our Access resources cannot be “paperless”. However, with each resource pack students will get step-by-step instructions for each task as well as a “Condensed Pack” that fits onto just 2 – 3 pages of A4. Each resource has been designed so that there are plenty of hints and tips for the first 4 – 5 tasks and thereafter they get progressively more complex with less help, to get students thinking for themselves.
***New Freebie – Fix the Excel Error for H Admin***
All the Spreadsheet tasks from the 2018 - 2023 Higher Admin & IT Assignments with errors that need to be fixed 😁
Build Your Skill – Summary of Resources
These PDF files gives an idea of what the Build Your Skill Resources look like by using a series of screenshots to give examples and an overview of tasks.
BYS [DBV1002] – Queries (Level 1)
Basic query practice searching for specific text and sorting or descending on one field. See below for a full product description.
BYS [DBV1003] – Queries (Level 2)
Intermediate queries incorporating more complex criteria, eg searching between 2 values. See below for a full product description.
BYS [DBV1005] – Queries (Level 3)
Plenty of practice using the aggregate function (sum/count/ave/max/min) then add/subtract/multiply & divide calculated fields. See below for a full product description.
BYS [DBV1006] – Forms & Reports (Level 1)
Plenty of practice with basic Forms and Reports. See below for a full product description.
BYS [DBV1007] – Forms & Reports (Level 2)
More practice with Forms and Reports incorporating labels, sorting tables, queries and design view edits. See below for a full product description.
BYS [DBV1008] – Forms & Reports (Level 3)
Aimed at Higher, lots of practice with forms and reports incorporating sub forms, design view edits, report grouping and summary, calculated fields in queries and reports.
BYS [INT1001] – N6 Integrated Tasks (Pack 1)
Lots of practice with spreadsheets and databases. This pack is aimed at Higher Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 1 is based around Open Water Swimming Events.
BYS [INT1002] – N6 Integrated Tasks (Pack 2)
Lots of practice with spreadsheets and databases. This pack is aimed at Higher Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 2 is based around a Business Support and Training Organisation.
BYS [INT1003] – N6 Integrated Tasks (Pack 3)
Lots of practice with spreadsheets and databases. This pack is aimed at Higher Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 3 is based around Summer Activity Camps and Holiday Accommodation.
BYS [INT1004] – N5 Integrated Tasks (Pack 1)
Plenty of practice with spreadsheets, databases, word and powerpoint, this pack is aimed at N5 Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 1 is based around a car wash and valeting business.
BYS [INT1005] – N5 Integrated Tasks (Pack 2)
Plenty of practice with spreadsheets, databases, word and powerpoint, this pack is aimed at N5 Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 2 is based around a football club.
BYS [INT1006] – N5 Integrated Tasks (Pack 3)
Plenty of practice with spreadsheets, databases, word and powerpoint, this pack is aimed at N5 Admin and IT and incorporates many of the skills you would expect to see in the Assignment. Pack 3 is based around an administrator working on a cruise ship.
BYS [INT1007] – N4 Integrated Pack 1
Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit. Pack 1 is based around an ice-cream business.
BYS [INT1008] – N4 Integrated Pack 2
Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit. Pack 2 is based It is based around a Scottish loch with camping, wildlife and water activities and a community trying to keep it clean and safe.
BYS [INT1009] – N4 Integrated Pack 3
Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit. Pack 3 is based around and IT Training Business.