Session 10

* There are four database operations, three of which cause changes: 1. insert; 2. delete; 3. update; 4. select (only opens it).
* When constructing a database, ID IS KING!!
* All databases must 1. have an ID column, 2. use the AutoNumber data type to populate this column, 3. have a primary key defined.
* The new version of Access does these three things for you!
* DO NOT have spaces in your field names - either use capitals or underscores.
* SQL stands for Structured Query Language.
* In SQL * means all, e.g. the command "Select * from TableName".
* When writing our code in Visual Basic, objects need to be connected to a database.
* Rachael used the following analogies:
1. Connection String - The Supermarket address.
2. Connection Object - The car.
3. Command Object - The shopping list.
4. DataAdapter Object - Mum doing the shopping.
5. DataSet Object - The pantry.