1. Introduction
1.1. What is a database?
1.2. Examples of how databases are used in the real world
1.2.1. Internet search engines
1.2.2. Police Database
1.3. Advantages of data handling
1.4. Disadvantages of data handling
1.5. Comparison to spreadsheets
1.6. Lesson ideas
1.6.1. NGfL Cymru
1.6.1.1. Whoddunit - solve the mystery
1.6.2. Wordsearch maker
1.6.2.1. Database terminology
1.6.3. E-Fit
2. Basics
2.1. Data Structure
2.1.1. Fields (columns)
2.1.1.1. Data types
2.1.1.1.1. text
2.1.1.1.2. Number
2.1.1.1.3. String
2.1.1.1.4. Date/Time
2.1.1.1.5. Boolean
2.1.1.1.6. Others
2.1.1.2. Field lengths vs default
2.1.1.3. Primary Key Field
2.1.1.3.1. Autonumber
2.1.2. Records (Rows)
2.1.3. Files
2.1.4. How to design
2.1.4.1. Questions database needs to answer
2.1.4.2. Questions needed to create database
2.1.4.3. Articles
2.1.4.3.1. MS Server crash nearly causes 800 plane pile up
2.1.5. Lesson ideas
2.1.5.1. NGfL Cymru
2.1.5.1.1. Interactive animation about creating databases
2.2. Tables
2.2.1. Flat file vs Relational
2.3. Comparisons with Spreadsheets
2.3.1. Advantages
2.3.2. Disadvantages
2.3.3. Differences
2.3.4. Similarities
2.4. Add a record
2.5. Delete a record
2.6. Edit record
2.7. Lesson ideas
2.7.1. @largerama
2.7.1.1. Sherlock Holmes Detective Game
3. Testing
3.1. Validation
3.1.1. Rules
3.1.1.1. Data type
3.1.1.2. Range
3.1.1.3. Presence
3.1.1.4. Format
3.1.2. Text
3.2. Data integrity
3.3. Verification
4. Links to other software
4.1. Importing data CSV
4.2. Data logging
4.3. Google forms
4.4. Mail merge
4.4.1. Word processors
4.4.2. DTP
4.5. Data Collection
4.5.1. Open ended vs Closed qestions
4.5.2. Online
4.5.2.1. Google Forms
4.5.3. Ready Made Data Sets
4.5.4. Data Logging
4.5.5. Analogue vs Digital Data
5. Outputs
5.1. Reports
5.1.1. Design Considerations
5.1.1.1. Wizard vs Design View
5.1.1.2. Formatting
5.1.1.3. Headers & Footers
5.2. Searching data
5.2.1. Query Design
5.2.1.1. Wizard
5.2.1.2. Custom (design view)
5.2.1.2.1. Use of operators (>, <>, >=, etc)
5.2.1.3. Simple vs Complex
5.2.1.4. Saving queries
5.2.1.5. Running queries
5.2.2. Lesson ideas
5.2.2.1. NGfL Cymru
5.2.2.1.1. Interactive search one field
5.2.2.1.2. Interactive search two fields
5.3. Sorting Data
5.3.1. Simple vs Complex
5.3.2. Lesson ideas
5.3.2.1. NGfLCymru
5.3.2.1.1. Interactive animation
5.4. Charts / Graphs
5.5. Using calculations in fields
6. Inputs
6.1. User Interfaces
6.1.1. Tables
6.1.1.1. List view
6.1.2. Forms
6.1.2.1. Wizard vs Design view
6.1.2.2. Formatting
6.1.2.3. Headers & Footers
6.2. Use of drop down lists
6.2.1. How to construct
6.2.2. Allow additional entries vs limit to list
6.3. Input masks / characters
6.4. Reliability of data collected
6.4.1. Why use some data
6.4.2. Why not use other data
7. Printing
7.1. Adjusting margin size
7.2. Adjusting column size
8. Backing up
8.1. Versions
8.1.1. Grandfather
8.1.2. Father
8.1.3. Son
9. Users
9.1. Access rights
9.2. Multiple users
9.3. Data Security
9.4. Password protection
10. Evaluating
10.1. Compare expected results with actual
10.2. Compare data collected with alternate samples
11. Audience
11.1. Most appropriate input / output
12. Alternative Software
12.1. Excel
12.2. Branching Databases
12.2.1. @simonhaughton
12.2.1.1. Lesson ideas
12.2.1.2. Ask Oscar
12.2.1.3. Sample data
12.3. 2investigate
12.3.1. Lesson ideas
12.3.1.1. @simonhaughton
12.3.1.1.1. Introducing databases
12.3.1.2. @chrisleach78
12.3.1.2.1. Top Trumps
12.3.1.2.2. Games consoles Top Trumps
12.4. @simonhaughton
12.4.1. KS1 data handling ideas