Using Databases

1. Features

1.1. lookup wizard

1.2. Input maks

2. Database Terms

2.1. table, record, field

2.2. primary key

3. Database Components

3.1. tables

3.1.1. used to store data in the database

3.2. forms

3.2.1. used to input data into the database

3.3. reports

3.3.1. used to present information from the database

3.4. queries

3.4.1. used to look at only certain information

4. Tutorial Exercises

4.1. Tut1:Using MS Access

4.1.1. Creating a Database + Tables

4.1.2. Date types

4.1.3. Making a Primary Key

4.1.4. Table Size Properties

4.1.4.1. Feild size

4.1.4.2. Format

4.1.4.3. Default Value

4.1.4.4. Input Mask

4.1.4.5. validation rules

4.1.4.6. zero length

4.1.5. Data entry with form

5. What are they used for?

5.1. Business stores Customer and stock data

5.2. Hospitals store patient data

5.3. Schools store students data and reports, attendance

5.4. Teaching Notes

6. Database functions

6.1. Add, edit delete

6.2. sort, search, filter

7. Making a database

7.1. Design view, datasheet view