BYS [INT1011] – PDA IT in Business L7 (Access Database)

Description

This pack has plenty of practice in all things Database for the PDA in Business L7 qualification. Suggested solutions are included.

With over 40 different databases and 68 tasks to work on the price reflects the size of this resource.

Part 1 – Introduction to Relational Database Design
SQA Unit Code F84X 34 – Design a relational database structure from source documents.
23 different tasks using 8 different databases this resource covers:
• Identifying a suitable primary key.
• Designing a database table with suitable fields and establishing appropriate primary key(s).
• Determining suitable field type (e.g. text, date, currency etc.)
• Re-designing a database table into separate tables with appropriate primary key(s).
• Creating a database with multiple tables and identifying primary and foreign keys.
• Drawing ER diagrams to represent relationships between entities (tables).
• Using standard database notation to show entities and attributes for tables.

Part 2 – Modify and Store Data
SQA Unit Code F84X34 – Modify and store data using a relational database.
25 different tasks using 13 different databases this resource covers:
• Modifying database tables by changing field type.
• Inserting additional records into a database table.
• Editing data in a table.
• Sorting data in a table.
• Creating a form from a database table.
• Adding additional information to a form.
• Making changes to a form in design view e.g. changing font/size/colour, adding logos etc.

Part 3 – Query and Present Information
SQA Unit Code F84X 34 – Query and present information to aid decision making.
20 tasks from 20 different databases this resource covers:
• Creating queries for sorting data.
• Creating and running various queries (dates, text, values, yes/no etc.)
• Creating reports from a database table.
• Grouping reports and sorting alphabetically.
• Editing a table in design view.
• Creating a query then turn into a report.