different Explain what validation means and how it can be performed. Show how to add operators such as a validation by demonstrating some of the validation types (for example, a >=, BETWEEN, Date or Age field must be in a given range). Dates should always be defined as AND, OR, NOT type Date/Time to ensure that only valid dates can be entered. Discuss why and the wildcard * telephone numbers should be held as text and not numbers (leading zeros will in queries not be displayed if held as a number, and spaces are not allowed.) Tell pupils to add validations to at least two fields. Using the Lookup Wizard when defining a text field will allow you to define a list Creating a of valid entries, e.g. or and no other values will be accepted when the “M” “F”, database table user inputs data. Some : Create the Give out Worksheet 3 Table Structure and ask pupils to fill this in. Make relationship between sure that every pupil has designed a table or tables based on a single entity two linked tables and which does not contain repeated fields. You do not want, for example, a Pupil table that has 10 fields for the 10 subjects they are studying. Learning Objectives Worksheet 17.3 will form part of their final assessment. In the final lesson, a database pupils will paste this into their assessment portfolio. with one or two Pupils can then load Access and create a table structure for their chosen tables application. Then they can add some records to their table, test out validations the and edit the structure if necessary. Ideally 10 records ought to provide enough database structure variety for meaningful queries in the next lesson. suitable field types including numbers and text validations and validation text to at least one field records to the table and test the validations Home Learning: Remember to check Lesson 2 - Queries homework. Make sure 1. Have pupils create a Learning Start the lesson by reminding pupils they have already created and used query from their own Objectives: queries in the first lesson using the Gotcha database.
different operators such as >=, BETWEEN, AND, OR, NOT and the wildcard * in queries Creating a database table Some : Create the relationship between two linked tables Learning Objectives a database with one or two tables the database structure suitable field types including numbers and text validations and validation text to at least one field records to the table and test the validations Explain what validation means and how it can be performed. Show how to add a validation by demonstrating some of the validation types (for example, a Date or Age field must be in a given range). Dates should always be defined as type Date/Time to ensure that only valid dates can be entered. Discuss why telephone numbers should be held as text and not numbers (leading zeros will not be displayed if held as a number, and spaces are not allowed.) Tell pupils to add validations to at least two fields. Using the Lookup Wizard when defining a text field will allow you to define a list of valid entries, e.g. “M” or “F”, and no other values will be accepted when the user inputs data. Give out Worksheet 3 Table Structure and ask pupils to fill this in. Make sure that every pupil has designed a table or tables based on a single entity and which does not contain repeated fields. You do not want, for example, a Pupil table that has 10 fields for the 10 subjects they are studying. Worksheet 17.3 will form part of their final assessment. In the final lesson, pupils will paste this into their assessment portfolio. Pupils can then load Access and create a table structure for their chosen application. Then they can add some records to their table, test out validations and edit the structure if necessary. Ideally 10 records ought to provide enough variety for meaningful queries in the next lesson. Lesson 2 - Learning Objectives: Queries Start the lesson by reminding pupils they have already created and used queries in the first lesson using the Gotcha database. Home Learning: 1. Have pupils create a query from their own Remember to check homework. Make sure
CompY9_1_Databases.docx