Database cont'

There are 4 different operations
delete
update
insert
select

2 different types of databases
flat file (excel spreadsheets)
relational (access)

manipulating a database
ID is King, it's all about ID

auto number
go to the data type in access
Access does not renumber id, there all all unique, even if they have been deleted
All of our tables will have an ID column that belongs to the table

Primary key
Suitablility - access is for single users or small business users.
limitation - not suitable for the internet.

SQL - structured query language, when we want to do our insert, update, delete etc

No spaces eva between anything in programming - capital or underscore

Generate reports and quiries with access