Get Started. It's Free
or sign up with your email address
Access by Mind Map: Access

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

12.5. Super Trumps